First thing you did not reference your "filename" macro variable.Should look like:
proc import
datafile = &filename.
out = Ref.Report1
dbms = xlsx
replace;
run;
Second your "filename" will be built incorrectly. By placing quote characters in the Location,File and Extension variables your Filename is: 'C:\Users\1\Desktop\''Reference_Report'*'.xlsx'
Which has two single quotes in the middle and other extra quotes. If you want to generate 'C:\Users\1\Desktop\Reference_Report*.xlsx'
You need different code.
%let location = C:\Users\1\Desktop\;
%let file = Reference_Report;
%let extension =.xlsx;
%let filename = "&location.&file.*&extension.";
%put &filename.;
Double quotes are used so the macro variables will resolve inside them.
But if you have more than one of the "reference_report.xlsx" files in that folder proc import will choke on that as it doesn't deal with multiple input files.
... View more