Hi, I've been searching for a solution for this problem for the past couple of days with no luck. I have a data set with a column called mail_file that has a file paths to other SAS data sets. I want to open those data sets and check to see if certain variables exist. This is the code I came up with: data lists; set list_to_load; dsid=open(mail_file, 'I' , , 'F'); if dsid^=0 then do; if varnum(dsid, 'PROMOCODE')=0 then column_exists=1; end; run; I always get a dsid of 0. The paths the of the files look like this: S:\Marketing\For_Output\listloadtest.sas7bdat. Is there any way I can use a variable in the open() function? Or is there another approach I can take to acomplish this task? Thanks a alot.
... View more