Proc Import with Macro Variable

Annalena — Sat, 06 Jan 2018 20:08:11 GMT

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!

Re: Proc Import with Macro Variable

novinosrin — Sat, 06 Jan 2018 20:11:17 GMT

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;

topic Proc Import with Macro Variable in SAS Studio

Proc Import with Macro Variable

Re: Proc Import with Macro Variable