How to access the link in an external look up table?

[deleted_user]

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.

[Cynthia_sas]

Hi:
Several answers posted in the Macro forum.
http://support.sas.com/forums/thread.jspa?threadID=3038&tstart=0
cynthia