topic Re: SAS macro in SAS Programming

SAS macro

scb — Mon, 30 Oct 2017 02:20:35 GMT

May I know what happened to code 1? I can import perfectly with code 2. May I know how to make code 1 works? Thanks.

%LET YYYYMM=201710;

/**Code 1**/

%macro checkds(dsn);
%if %sysfunc(exist(&dsn)) %then %do;
PROC IMPORT OUT=sales
DATAFILE=&dsn
DBMS=EXCEL REPLACE;
getnames=yes;
run;
%end;
%else %do;
DATA sales;
ID='';
AMOUNT=0;
RUN;
%end;
%mend checkds;
%checkds("d:\test\book1_&YYYYMM..xlsx")

/**code 2**/

PROC IMPORT OUT=SALES
DATAFILE="d:\test\book1_&yyyymm..xlsx"
DBMS=EXCEL REPLACE;
getnames=yes;
run;

Re: SAS macro

Astounding — Mon, 30 Oct 2017 02:41:24 GMT

As you can see from the macro call, Code #1 expects to receive a quoted path to a file. The macro checks to see whether that file actually exists. If it does, it imports the file into a SAS data set named SALES. If the file doesn't exist, the macro creates a SAS data set named SALES, holding just one observation where ID is blank and AMOUNT is 0.

Re: SAS macro

Kurt_Bremser — Mon, 30 Oct 2017 07:01:07 GMT

exist() is a function that checks for the existence of a SAS dataset, so it needs an argument that describes such (LIBNAME.DATASET). Since you want to check for an external (non-SAS) file, you need to use the fexist() function.