RE: st: issue with forvalues/foreach

["Rubil Ivica" <irubil@eizg.hr>]

Rebecca,
I tried -cd- and it doesn't work. Stata returns the same error message:

file F:\project\data`i'.dta not found
r(601);




--
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: 14. prosinac 2012 15:24
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: issue with forvalues/foreach

Just the loop should be sufficient. Long code is better than no code
when trying to answer a question.

Did you try -cd-?

Rebecca




On Fri, Dec 14, 2012 at 7:27 AM, Rubil Ivica <irubil@eizg.hr> wrote:
> 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/
*
*   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/