08-24-2015 10:10 AM
See the log below. Can someone tell me how to call this macro variable in infile statement? Because I could not resolve the macro variable as per the log below.
1 %let filedate=%sysfunc(putn("&sysdate9"d-1,yymmdd10.));
2 %put &filedate;
ERROR: Physical file does not exist,
Note: I copy\paste only the required log and NOT everything.
08-24-2015 10:16 AM
I can't tell from the code you have given, how the infile statement looks. It should look like:
However, why do you need the macro variable at all?
08-24-2015 10:44 AM
Your error message could be interpreted as not a macro variable error, it could mean your macro variable has worked properly and your infile statement points to a file that doesn't exist.
It would help if you showed us the INFILE statement.
08-24-2015 11:20 AM
Looks like you used single quotes in the INFILE statement, so the macro variable was not expanded. Also I doubt the you want the double quote characters embedded into the filename.
infile "/usr/sas/sas_config/Lev1/SASApp/StoredProcessServer/Logs/SASApp_STPServer_&filedate._tmptcmsaslva2_*.log" ...
08-24-2015 11:26 AM
Yes, please show your INFILE statement.
If that is really the error message you are getting, I would guess maybe your infile statement looks something like:
The single quotes would keep &filedate from resolving. And you don't want double quotes in the middle of your file name.