Re: st: issue with forvalues/foreach

[Rebecca Pope <rebecca.a.pope@gmail.com>]

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/