Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Rubil Ivica" <irubil@eizg.hr> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | RE: st: issue with forvalues/foreach |
Date | Fri, 14 Dec 2012 14:27:40 +0100 |
I didn't send the actual code because it is long. The same problem appears whenever I have a path within the -forvalues- or -foreach- loop. The files are certainly in the folders that I am referring to in paths. -- Ivica Rubil Ekonomski institut || The Institute of Economics, Zagreb Trg J. F. Kennedyja 7, 10 000 Zagreb, Croatia tel. +385-1-2362-269 || fax. +385-1-2335-165 irubil@eizg.hr || www.eizg.hr -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Rebecca Pope Sent: 13. prosinac 2012 17:52 To: statalist@hsphsun2.harvard.edu Subject: Re: st: issue with forvalues/foreach Try this, since it looks like your files are all in the same directory: cd "F:\project\data\" forval i=1/30 { use `"dataset_`i'.dta"', clear compress var1 var2 save `"dataset_`i'.dta"', replace } Note on your -foreach- loop, you tell Stata that "country" is the macro. Therefore, your code should say: foreach country in croatia albania { use "F:\project\data\dataset_`country'.dta", clear compress var1 var2 save "F:\project\data\dataset_`country'.dta", replace } I also changed the colon in the save to an underscore, since I assume that is what you meant. If that doesn't work, please post the code you are really submitting. Perhaps there is something particular to it that isn't captured by your example. Best, Rebecca On Thu, Dec 13, 2012 at 10:36 AM, Rubil Ivica <irubil@eizg.hr> wrote: > William, what your suggested does not work either, even after > sustituting "/" for "\". > > > > > > -- > Ivica Rubil > Ekonomski institut || The Institute of Economics, Zagreb > Trg J. F. Kennedyja 7, 10 000 Zagreb, Croatia > tel. +385-1-2362-269 || fax. +385-1-2335-165 > irubil@eizg.hr || www.eizg.hr > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of William > Buchanan > Sent: 13. prosinac 2012 17:28 > To: statalist@hsphsun2.harvard.edu > Subject: Re: st: issue with forvalues/foreach > > Hi Ivica, > > Try: > > forv i = 1/30 { > use `"F:/project/data/dataset_`i'"', clear > compress var1 var2 > save `"F:/project/data/dataset_`i'b"', replace > clear > } > > It's probably a good idea not to permanently modify your data files (so > adding "b" to the end of the filename should make it easier to > distinguish the two). Also notice the use of "/" instead of "\" in the > file path. Using the "/" character will work on all platforms, and > avoids some of the problems that you faced. > > HTH, > Billy > > > On Dec 13, 2012, at 8:21 AM, Rubil Ivica wrote: > >> Dear Statalisters: >> >> When I to run the following (two artificial examples just to > illustrate >> the issue) >> >> forvalues i = 1(1)30 { >> use "F:\project\data\dataset_`i'.dta", clear >> compress var1 var2 >> save "F:\project\data\dataset_`i'.dta", replace >> clear >> } >> >> or for instance >> >> foreach country in croatia albania { >> use "F:\project\data\dataset_`i'.dta", clear >> compress var1 var2 >> save "F:\project\data\dataset:`i'.dta", replace >> clear >> } >> >> Stata returns >> >> file F:\project\data`i'.dta not found >> >> It seems strange to me that Stata "forgets" the exactly specified > path: >> "F:\project\data\dataset_`i'.dta" in the first example >> and >> "F:\project\data\dataset_`i'.dta" in the second example. >> >> >> >> >> -- >> Ivica Rubil >> Ekonomski institut || The Institute of Economics, Zagreb >> Trg J. F. Kennedyja 7, 10 000 Zagreb, Croatia >> tel. +385-1-2362-269 || fax. +385-1-2335-165 >> irubil@eizg.hr || www.eizg.hr >> >> >> * >> * 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/ > > * > * 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/ * * 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/