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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.