About MikeSimmos

MikeSimmos · ‎08-30-2011

Thanks art297, I changed to double quotations and it's now reading the macro variable properly. Yes I never thought that would be the issue since single quotations has always worked in SAS 9.1. Glad it's resolved, thanks again for your help.

MikeSimmos · ‎08-30-2011

Hi, I export a report to Excel daily, with the data in the filename changing each day as follows in an extract of the full code: %let endDate=20110830; proc export data=summarylessgst1 outfile='H:\Output\Summary &endDate..xls' dbms=excel replace; run; I had no problem with this when using SAS 9.1, but now I have moved to SAS 9.2, the output does not recognise &endDate., and instead outputs a file named: 'Summary &endDate..xls' &endDate works fine in the rest of the code, i.e. when only selecting transactions with a date before &endDate. Can anyone help to provide an explanation and/or solution as to why the proc export outfile does not replace &endDate with the specified date? Thanks

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Problem using %let macro in Proc Export filename

Problem using %let macro in Proc Export filename

Problem using %let macro in Proc Export filename

Problem using %let macro in Proc Export filename