I have an excel file report name Reference_Report. The file name ends with a time stamp every time it is exported to my machine. My library reference the report in my desktop. Instead of updating the file name, I thought I would use a wild card. When I run the code SAS gives me ERROR: Physical file does not exist, C:\WINDOWS\system32\FILENAME.xlsx What am I doing wrong? libname Ref 'C:\Users\1\Desktop\';
%let location = 'C:\Users\1\Desktop\';
%let file = 'Reference_Report';
%let extension ='.xlsx';
%let filename = &location&file*&extension;
proc import
datafile = filename
out = Ref.Report1
dbms = xlsx
replace;
run;
... View more
