topic Re: using multiple data sets to create outputs from proc report in SAS Programming

using multiple data sets to create outputs from proc report

ernie86 — Fri, 22 Jul 2016 19:11:56 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: using multiple data sets to create outputs from proc report

Reeza — Fri, 22 Jul 2016 19:28:33 GMT

Can you post the log after turning on MPRINT and SYMBOLGEN.

options MPRINT SYMBOLGEN;

Re: using multiple data sets to create outputs from proc report

ballardw — Fri, 22 Jul 2016 19:34:38 GMT

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.