The SAS Output Delivery System and reporting techniques

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

Reply
N/A
Posts: 0

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

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.
SAS Super FREQ
Posts: 8,864

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

Posted in reply to deleted_user
Hi:
Several answers posted in the Macro forum.
http://support.sas.com/forums/thread.jspa?threadID=3038&tstart=0
cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation