# st: RE: RE: RE: RE : RE: Foreach and rename

 From "Martin Weiss" <[email protected]> To <[email protected]> Subject st: RE: RE: RE: RE : RE: Foreach and rename Date Mon, 25 Aug 2008 15:37:43 +0200

```Also note that you can -set trace on- to make Stata more verbose as to its
problems...

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Rajesh Tharyan
Sent: Monday, August 25, 2008 3:25 PM
To: [email protected]
Subject: st: RE: RE: RE : RE: Foreach and rename

Hi,

Alvine, You showed us your code . you didn�t show us that stata gave you.
You said But it doesn't work : "invalid syntax". Did stata say invalid

The following code works perfectly well (the loop is exactly your code!
Except 9 has been changed to 5)

clear
set obs 5
gen moi01008=0
gen moi02008=0
gen moi03008=0
gen moi04008=0
gen moi05008=0

forvalues i=1/5 {
rename moi0`i'008 date_modif_`i'
}

While the following code (where the moi3008 is missing)

clear
set obs 5
gen moi01008=0
gen moi02008=0
gen moi04008=0
gen moi05008=0

forvalues i=1/5 {
rename moi0`i'008 date_modif_`i'
}

Gives me

. forvalues i=1/5 {
2. rename moi0`i'008 date_modif_`i'
3. }
r(111);

not "invalid syntax" as mentioned in the original post.

When you post you have to show exactly what stata gave you, That makes it
easier for people trying to answer the query.

rajesh

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Martin Weiss
Sent: 25 August 2008 14:06
To: [email protected]
Subject: st: RE: RE : RE: Foreach and rename

Try this to see what I am trying to convey...

foreach number in 1 2 3 4 5{
di `number'
}

So yours would be

foreach i in 1 2 3 5 6 9{
rename moi0`i'008 date_modif_`i'
}

HTH
Martin

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, August 25, 2008 2:50 PM
To: [email protected]
Subject: st: RE : RE: Foreach and rename

Thak you for your answer , but it doesn't help me for the invalide syntax of

forvalues i=1/9 {
rename moi0`i'008 date_modif_`i'
}

-----Message d'origine-----
De : [email protected]
[mailto:[email protected]] De la part de Martin Weiss
Envoy� : 25 August 2008 14:40
� : [email protected]
Objet : st: RE: Foreach and rename

-h foreach- shows you that you can specify a -numlist- where you spell out
the members explicitly.

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, August 25, 2008 2:28 PM
To: [email protected]
Subject: st: Foreach and rename

Dear all,

I'd like to change the name of many variables in this way:

rename moi01008 date_modif_1
rename moi02008 date_modif_2
rename moi03008 date_modif_3
rename moi05008 date_modif_5
rename moi06008 date_modif_6
rename moi09008 date_modif_9

I'd like to use a loop, like

forvalues i=1/9 {
rename moi0`i'008 date_modif_`i'
}

But it doesn't work : "invalid syntax"

Even if this loop works, I have a problem with the value i=4,7 and 8 for
which moi0`i' does not exist.

How can I do ?

Thanks

Alvine

*****************************************************
Alvine BISSERY
Ing�nieur statisticien
Service de Biostatistique des Hospices Civils de Lyon
162 Avenue Lacassagne
69424 Lyon Cedex 03 - France
t�l: +33 4 72 11 57 55
fax: +33 4 72 11 51 41

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/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/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/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/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/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```