Re: st: Need help with working with multiple files

[Steve Samuels <sjsamuels@gmail.com>]

Michael Steward (michaelstewartresearch@gmail.com):

You can loop, as Nick suggests. Put the data management tasks in
external do files, e.g. tasks1.do, tasks2.do, tasks3.do. Then something
like the following should work (not tested in Windows). See the help for
-include-. The big problem I anticipate is the mounds of output that
this could generate.


********************************* 
local ds1 "c/data/dataset-1"
local ds2 "c/data/newdata/dataset-2" // etc.

local all ds1 ds2  

foreach x in `all' {
   use `x', clear

   include tasks1
   include tasks2
   include tasks3

   save `x'_new, replace
}
*********************************

Steve 


On May 27, 2013, at 3:19 PM, Michael Stewart wrote:

Hi
I am trying to find a way to work multiple files successively.
I have multiple large files(really large) placed in different directories
I am trying to find a way to load each file into stata, complete bunch
of same datamagement tasks,create  a new file from it and places them
in a common folder

I could use a dofile and do something like

clear
use c\data\dataset-1
datamagement tasks
datamagement tasks
datamagement tasks
save c\data\dataset-1_new
clear
use c\data\newdata\dataset-2
datamagement tasks
datamagement tasks
datamagement tasks
save c\data\newdata\dataset-2_new
clear

But is there an elegant and simpler way to do it given that I have
nearly 15 files to do data management tasks.

Can we use foreach loop / forvalues loop or anything like that .Please suggest




--
Thank you ,
Yours Sincerely,
Mike.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/