Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Importing data from excel with multiple worksheets


From   Steven Dubnoff <sdubnoff@circlesys.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Importing data from excel with multiple worksheets
Date   Fri, 23 May 2008 10:55:26 -0700

I have  an excel file with many worksheets all of which contains same
set of variables but representing different states... is there an easier
way to stack all the excel sheets into one data and export it to stata?



The "Concatenate Worksheet Pages" option in Stat/Transfer was designed especially for problems such as this. To quote from the help:

>>

The option Concatenate Worksheet Pages allows you to combine worksheet pages into a single output file. This option is appropriate if your worksheet contains many sheets that are identical in structure. These can be then be combined into a single output file of any type.

For example, you may have a workbook that has 50 sheets, with one sheet for each state and the same variables on each sheet. If you check this box, Stat/Transfer will effectively combine the sheets into one large input file, dropping the field names, if necessary, on the second and higher sheets. You will end up with the data from all of your worksheet pages in a single output file.
>>

Best,

Steve



----------------------------------------------------------------
Steven Dubnoff sdubnoff@circlesys.com
Circle Systems We make your data instantly usable.
Download Stat/Transfer from http://www.stattransfer.com
1001 Fourth Avenue, #3200 (206) 682-3783
Seattle, WA 98154 Fax (206) 328-4788


*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/




© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index