Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: forval query
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: forval query
Date
Fri, 5 Apr 2013 15:26:07 +0100
Maarten's code can be automated one step further
unab stubs : r2*
local stubs : subinstr local stubs "r2" "", all
forvalues i = 2/10 {
local j = 1990 + (2*`i')
foreach stub of local stubs {
rename r`i'`stub' `stub'_`j'
}
}
The double loop can be shortened, at the risk of some loss of clarity
forvalues i = 2/10 {
foreach stub of local stubs {
rename r`i'`stub' `stub'_`= 1990 + 2*`i''
}
}
Nick
[email protected]
On 5 April 2013 15:20, Maarten Buis <[email protected]> wrote:
> On Fri, Apr 5, 2013 at 4:13 PM, Mirnezami, Oliver wrote:
>> I can repeat your set of commands for each variable e.g.
>>
>> forvalues i = 2/10 {
>> local j = 1990 + (2*`i')
>> rename r`i'mobila mobila_`j'
>> ma drop j
>> }
>>
>>
>> forvalues i = 2/10 {
>> local j = 1990 + (2*`i')
>> rename r`i'lgmusa lgmusa_`j'
>> ma drop j
>> }
>>
>> Etc.
>>
>> However, I have do this for many variables so can you plug in a line with a list of these variables to avoid repeating the command over and over again?
>
> local stubs "mobila lgmusa"
>
> forvalues i = 2/10 {
> local j = 1990 + (2*`i')
> foreach stub of local stubs {
> rename r`i'`stub' `stub'_`j'
> }
> }
>
> -- Maarten
>
> ---------------------------------
> Maarten L. Buis
> WZB
> Reichpietschufer 50
> 10785 Berlin
> Germany
>
> http://www.maartenbuis.nl
> ---------------------------------
> *
> * 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/