Statalist


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

Re: st: Importing data from excel with multiple worksheets


From   "Friedrich Huebler" <fhuebler@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Importing data from excel with multiple worksheets
Date   Fri, 23 May 2008 15:29:11 -0400

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 <rmjohn@gmail.com> 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 <sdubnoff@circlesys.com> 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              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