Im trying to run couple reports that reading from different datasets. For some reason, it keeps giving me this "WARNING: Apparent symbolic reference DATASETS_JUL_2016 not resolved.", and the macro is not working. Can someone please tell me what is wrong with my code below.
%macro report(datasets);
ODS Tagsets.ExcelXP FILE= "J:\mydrive\&datasets_JUL_2016.xls" style=fancyprinter;
proc report data=&datasets nofs split='*';
column School ID Class student;
define School / display style={just=left foreground=black cellwidth=70};
define ID / display style={just=left foreground=black cellwidth=70};
define Class / display style={just=left foreground=black cellwidth=70};
define Student / display style={just=left foreground=black cellwidth=70};
run;
ODS Tagsets.ExcelXP close;
%mend report;
%report(abc);
%report(efg);
This line
ODS Tagsets.ExcelXP FILE= "J:\mydrive\&datasets_JUL_2016.xls" style=fancyprinter
contains
&datasets_JUL_2016
which is being treated as a single macro variable. It should be
&datasets._JUL_2016
to indicate the the literal text _JUL_2016 is appended to the value of &datasets. Note the added period.
Can you post the log after turning on MPRINT and SYMBOLGEN.
options MPRINT SYMBOLGEN;
This line
ODS Tagsets.ExcelXP FILE= "J:\mydrive\&datasets_JUL_2016.xls" style=fancyprinter
contains
&datasets_JUL_2016
which is being treated as a single macro variable. It should be
&datasets._JUL_2016
to indicate the the literal text _JUL_2016 is appended to the value of &datasets. Note the added period.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: