This feature was introduced in Stat/Transfer version 9.
http://www.stattransfer.com/html/new.html
Friedrich
On Fri, May 23, 2008 at 3:02 PM, Rijo John <[email protected]> wrote:
> 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/
