foreach var - problem "ambiguous abbreviation"

[Ronald Biefinger]

Hi
I have a panel data set and want to automate the following routine:

replace yr2005 = yr2005*100
replace yr2006 = yr2006*100
etc.

I tried it with

foreach var of varlist y* {
replace y* = y*/1000000
}

However I receive the error "ambiguous abbreviation".

Please help, thank you.

[Clyde Schechter]

What you want is

foreach var of varlist y* {
    replace `var' = `var'*100
}

By the way, I don't understand why you would divide by 1000000 in your loop to try to replicate a series of multiplications by 100. So I corrected that part, too.

[Nick Cox]

Note that if

 
 replace y* = y*/1000000

worked then the rest of the loop would be almost redundant.

[Ronald Biefinger]

Thank you for your quick responses. Appreciate your help!
Best