how to make proc report read from multiple data sets?

[ernie86]

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);

[Tim_SAS · Accepted solution]

SAS thinks your macro variable is &datasets_JUL_2016. Put a period between datasets and _JUL, like this:

&datasets._JUL_2016