Combining multiple excel document information (to use with Stata)
I am working with the US IRS data from a previous year. Each state is its own excel file with information about various information for every zipcode that state contains. I am trying to combine the excel data from all the states into a single file.
I feel the most rudimentary way would be to copy and paste, but would take a very long time with 50 files. To make things more complicated, I would not "copy all" the data; I would only copy the headers and information underneath (excluding the miscellaneous information). So I would have to copy a selected portion to be pasted in a new file.
I am doing this to create a stata data set, but I first need to import the information from excel (as a .csv file) as a single file that has all of the 50 states data.
Any tips or tricks to make this process more efficient are much appreciated, thanks!
Re: Combining multiple excel document information (to use with Stata)
please let me know if my question needs any clarification, thanks
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1