Statalist


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

Re: st: Appending several excel data sets into one


From   "C.I.D.E." <[email protected]>
To   [email protected]
Subject   Re: st: Appending several excel data sets into one
Date   Fri, 14 Sep 2007 17:56:35 +0200


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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index