Statalist


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

Re: st: Appending several excel data sets into one


From   Steven Dubnoff <sdubnoff@circlesys.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Appending several excel data sets into one
Date   Fri, 14 Sep 2007 12:58:32 -0700

Nick's Stata+Stat/Transfer program provides an elegant solution!

However, if you cannot guarantee that the second sheet of each workbook is actually named with the default "Sheet2", you should probably use the page number rather than the name in the '/t' switch as in:

inputst `primo', /t2 /y;

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