Proc Import with Macro Variable

[Annalena]

Hello ,

Im trying to import a few data sets in SAS Studio with a macro but somehow it isn't reading the macro statement in the filename and gives me an error:

%macro import(industry);

FILENAME REFFILE '/folders/myfolders/Bachelorarbeit/Daten/&industry..xlsx';

PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=&industry. REPLACE; 
GETNAMES=YES;
RUN;
%mend import;

%import (aerodef);
%import (automobiles);
/*etc.*/
run;

ERROR: Physical file does not exist, /folders/myfolders/Bachelorarbeit/Daten//&industry.xlsx.

How can edit this so that SAS recognizes it is a macro statement?

thanks!

[novinosrin · Accepted solution]

change to double quotes like this

%macro import(industry);

FILENAME REFFILE "/folders/myfolders/Bachelorarbeit/Daten/&industry..xlsx";

PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=&industry. REPLACE; 
GETNAMES=YES;
RUN;
%mend import;

%import (aerodef);
%import (automobiles);
/*etc.*/
run;