Statalist


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

st: Appending several excel data sets into one


From   "Patrick Musonda" <pmuzho@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Appending several excel data sets into one
Date   Fri, 14 Sep 2007 07:35:18 +0000

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/




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