how to make proc report read from multiple data sets?

ernie86 — Fri, 22 Jul 2016 18:39:26 GMT

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

Re: how to make proc report read from multiple data sets?

Tim_SAS — Fri, 22 Jul 2016 19:45:36 GMT

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

&datasets._JUL_2016

topic Re: how to make proc report read from multiple data sets? in ODS and Base Reporting

how to make proc report read from multiple data sets?

Re: how to make proc report read from multiple data sets?