Hi all,

I'm trying to run the following code where I try renaming a variable to a macro but it keeps failing.

foreach test in $Tests {

use "$crosswalk_path" if lcd == "`test'", clear
local testname = test[1]

capture noisily {
use "$data_extract_dir/`test'.dta", clear
merge m:1 msa date using "$data_extract_dir/Data.dta", ///

preserve
rename result `testname'
restore
}
}

The error message I keep getting is Syntax is rename oldname newname [, renumber[(#)] addnumber[(#)] sort ...] rename (oldnames) (newnames) [, renumber[(#)] addnumber[(#)] sort ...] rename oldnames , {upper|lower|proper}.

Can anyone help me fix this?