Thank you guys for the replies. As I'm sure you can tell, I am new to SAS, only been using it for about a month now. After posting again this morning and getting your comments back I found that my logic was in fact flawed and should not based upon the month and year values, but rather if the file itself exists. I proceeded to use the FILEEXIST function as was suggested yesterday. The code is as follows and ran properly without erroring out. %macro check1; %if %sysfunc(fileexist(&FILE_CHECK1.)) ge 1 %then %do; PROC IMPORT OUT = WORK.Rates_&YEAR4._H1 DATAFILE= YR4H1 DBMS=xlsx REPLACE; SHEET="SAS Prep"; GETNAMES=YES; RUN; %end; %else %put *************************** The file &FILE_CHECK2. does not exist ****************************; %mend check1; %check1 One mistake that I made along the way is that I tried to use the FILENAME that I had established for the import statement as a callable variable, which obviously is incorrect. I had to establish a new variable that added .xlsx onto the file path. Any other suggestions for improvements are greatly appreciated.
... View more