Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Steve Samuels <sjsamuels@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Need help with working with multiple files |
Date | Mon, 27 May 2013 20:23:23 -0400 |
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/