local files : dir . files "*.xls";
di `"`files'"';
local primo : word 1 of `files';
local files : list files - primo;
inputst `primo', /tsheet2 /y;
save temp, replace;
foreach f in `files' {;
inputst `f', /tsheet2 /y;
append using temp;
save temp, replace;
};
Nick
At 09.35 14/09/2007, you wrote:
>Dear Stata List,
>
>I am working on a project where we get excel data that has several sheets, for example:
>
>data.xls-sheet1, sheet2, sheet3, etc
>data.xls-sheet1, sheet2, sheet3, etc
>data.xls-sheet1, sheet2, sheet3, etc
>.
>.
>.
>datan.xls-sheetn1, sheetn2, sheetn3, etc
>
>We have several of such data sets, over n=200, say. Of these excel data sets, we are only interested in one sheet, say sheet2. How can one append these several sheet2s in one stata data sets in a simple program short of coping one at a time and then appending them?
>
>Your help will be highly appreciated,
>
>Best wishes,
>
>Patrick.
>
>_________________________________________________________________
>The next generation of Hotmail is here! http://www.newhotmail.co.uk
>
>*
>* 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/
