Hello, i'm using the below code to check a file create date and later assign that date to a macro variable (moddate). The code works fine when file exists but when there is no file in the declared path then I want moddate to be zero. %let Filenm= c:\xyz.xls; filename finput pipe %unquote(%str(%'dir "&filenm" /t:w /a:-d%')); data _null_; infile finput firstobs = 6; input moddate ?? :mmddyy8. modtime ?? & time8.; if moddate ne . then call symput('moddate',moddate); run; %put moddate = &moddate.; i tried if moddate ne . then call symput('moddate',moddate); else call symput('moddate',0); Now, if I add the above else statement the moddate is giving zero even when the file exist. So how do I assign moddate to 0 only when the file doesn't exist. Thanks in advance for your help!
... View more