https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-access-the-link-in-an-external-look-up-table/m-p/16471#M3470 Hi:<BR /> Several answers posted in the Macro forum.<BR /> <A href="http://support.sas.com/forums/thread.jspa?threadID=3038&amp;tstart=0" target="_blank">http://support.sas.com/forums/thread.jspa?threadID=3038&amp;tstart=0</A><BR /> cynthia Thu, 08 May 2008 15:54:50 GMT Cynthia_sas 2008-05-08T15:54:50Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-access-the-link-in-an-external-look-up-table/m-p/16470#M3469 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. <BR /> <BR /> errorvar lookupfile<BR /> state /c:/myfile/state.csv<BR /> gender /c:/myfle/gender.csv<BR /> ...<BR /> <BR /> 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. <BR /> <BR /> Can anybody help me find a solution? Thanks a million. Thu, 08 May 2008 13:14:06 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-access-the-link-in-an-external-look-up-table/m-p/16470#M3469 deleted_user 2008-05-08T13:14:06Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-access-the-link-in-an-external-look-up-table/m-p/16471#M3470 Hi:<BR /> Several answers posted in the Macro forum.<BR /> <A href="http://support.sas.com/forums/thread.jspa?threadID=3038&amp;tstart=0" target="_blank">http://support.sas.com/forums/thread.jspa?threadID=3038&amp;tstart=0</A><BR /> cynthia Thu, 08 May 2008 15:54:50 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-access-the-link-in-an-external-look-up-table/m-p/16471#M3470 Cynthia_sas 2008-05-08T15:54:50Z