Why do I not see the "Concatenate Worksheet Pages" option on my
Stat/Transfer? I have version 8.0.
On Fri, May 23, 2008 at 12:55 PM, Steven Dubnoff <[email protected]> wrote:
>> 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 [email protected]
> 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/
>
*
* 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/
