Hello everyone,

This might seem a very simplistic problem, but I am getting an error "varlist required" when I try to run a loop to clean variables with different names but with similar entry issues. I feel I have specified the varlist though. Here is the code below:


program define clean_var, rclass

version 13.1
syntax varlist

disp "Variable List: `varlist'"

foreach var in `varlist' {
disp "Looping through: `var'"

***** SUBSTR FIXES *****
replace `var' = trim(itrim(`var'))
replace `var' = subinstr(`var', char(10), "", .)
replace `var' = subinstr(`var', char(13), "", .)


***** CHARACTER FIXES *****
replace `var' = "" if `var' == "-"
replace `var' = "" if `var' == "`"
replace `var' = "" if `var' == ","


***** DATE FIXES ******
replace `var' = "1/2" if `var' == "02jan2003"
replace `var' = "1/2" if `var' == "02jan2003"
replace `var' = "1/2" if `var' == "02jan2019"

}

Any help would be really appreciated!

Thank you,
Ayon