I'd like to range check a dataset and have an external lookup table containing variable names and links to where their valid values are stored.
errorvar lookupfile
state /c:/myfile/state.csv
gender /c:/myfle/gender.csv
...
I want to retrieve the valid values stored in those lookup files and compare those values with my data. I want to create an indicator which equals "yes" when there is a match and "no" when there is no match.
Can anybody help me find a solution? Thanks a million.