Statalist


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

Re: st: Importing data from excel with multiple worksheets


From   "Rijo John" <rmjohn@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Importing data from excel with multiple worksheets
Date   Fri, 23 May 2008 14:02:48 -0500

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/
>
*
*   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