Mingfeng,
I'm a big fan of using -foreach- for these types of problems. The first thing is to make sure that your datasets are named in a similar way. In the example below I have used a set of datasets called data1, data2, ..., data30. Once that is done, you can place your -append- command inside a -foreach- loop. For instance:
use data1, clear
foreach num of numlist 2/30 {
append using data`num'
}
This code is really just a shortcut for the following:
use data1, clear
append using data2
append using data3
...
append using data30
Other variations are possible too, see -help foreach-.
-- Matt
[email protected]
-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Mingfeng Lin
Sent: Thursday, 20 November 2008 1:35 PM
To: [email protected]
Subject: st: combining many data files
Greetings!
I am wondering if there's a straightforward way to append a large
number of .dta files into one file using Stata? The -append- command
seems to disallow wildcards in the file names. I do find one method
from UCLA's ATS website,
http://www.ats.ucla.edu/stat/stata/faq/append_many_files.htm
but I'm still hoping there's an easier way, or somehow getting the
-append- command to recognize the wildcards - so that I could just
simply type
append using *.dta
Thanks :)
Mingfeng
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/