macro issue

noetsi

Fortran must die
#1
I built this macro

%Macro Tanisha(fileName=, extractDate=);
PROC IMPORT
DATAFILE="S:\CIU\sasTestFolder\&fileName"
OUT=sasuser.test1
DBMS=XLSX
REPLACE;
SHEET="Sheet1";
GETNAMES=YES;
DATAROW=2;
RUN;


Libname rims odbc dsn=rims readbuff=3000 schema=dbo user=ContinuousImpDBAccess pw=ContinuousImpDBAccess;
Libname rimsrpt odbc dsn=rimsreport readbuff=3000 schema=dbo user=ContinuousImpDBAccess pw=ContinuousImpDBAccess;
Libname rebapro odbc dsn=rebapro readbuff=3000 schema=dbo user=ContinuousImpDBAccess pw=ContinuousImpDBAccess;
Libname emplment odbc dsn=employment readbuff=3000 schema=dbo user=ContinuousImpDBAccess pw=ContinuousImpDBAccess;
run;

proc SQL;
Create table work.firstep
as select distinct t1.*
, "VR" || substr(cats ("0000000", put(CUSProfile_AN,7.)),length (strip (cats ("0000000", put(CUSProfile_AN,7.))))-6,7) as VRID
from sasuser.test1 t1
join rimsrpt.rptcasesummary t2
on t1.'SSN Without Dashes'n = t2.customerid
where t2.extractdate = &extractDate;
quit;

proc sql;

Create table work.firststep2 As
Select distinct t1.*
, t2.vrid
from sasuser.test1 t1
left join work.firstep t2
On t1.'SSN Without Dashes'n = t2.'SSN Without Dashes'n
;
quit;

proc sql;

Create table work.firststep2 As
Select distinct t1.*
,(CASE
WHEN '' = t1.VRID THEN 'Not a Customer'
ELSE 'Customer'
END) LABEL="CustomerFlag" AS CustomerFlag
from work.firststep2 t1;
quit;

PROC EXPORT DATA=WORK.firststep2
OUTFILE="s:\ciu\sastestfolder\exportversion"
DBMS=xlsx
replace;
RUN;

%mend;

I then call it

%Tanisha(filename='September21VRIDRequest.xlsx',extractdate='31aug2017'd);
RUN;

where there is a file called 'September21VRIDRequest.xlsx'

and I get

ERROR: Physical file does not exist, S:\CIU\sasTestFolder\'September21VRIDRequest.xlsx'.