&syspbuff couldn't resolve to the value assigned

chouchou — Tue, 11 Nov 2014 04:15:42 GMT

%macro pbuffparms / parmbuff;

ods graphics on / reset=all;

%*----Process this section when parameter values specified;

%if &syspbuff ne %then %do;

%let i=1;

%let month=%scan(&syspbuff,&i);

%do %while(&month ne);

proc sgplot data=books.ytdsales

(where=(month(datesold)=&month));

title “Section Sales Report for Month &month”;

hbar section / response=saleprice stat=sum

datalabel;

yaxis label=' ';

run;

%let i=%eval(&i+1);

%let month=%scan(&syspbuff,&i);

%end;

%*----Process this section when no parameter values

specified;

%else %do;

proc sgplot data=books.ytdsales;

title “Annual Section Sales by Quarter”;

hbar section / response=saleprice stat=sum

group=datesold;

yaxis label=' ';

label datesold='Quarter';

format datesold qtr.;

run;

%end;

%mend pbuffparms;

*----Analyze sales for August and November;

%pbuffparms(8,11) It only comes out one graph titled "Section Sales Report for Month &month", obviously &syspbuff wasn't resolved. Could anyone help me out with this problem? Thank you so much.

Re: &syspbuff couldn't resolve to the value assigned

art297 — Tue, 11 Nov 2014 05:08:33 GMT

Your logic appears to work .. at least the following worked for me:

data test;

set sashelp.class;

datesold=mdy(age-10,1,2014);

run;

%macro pbuffparms / parmbuff;

%*----Process this section when parameter values specified;

%if &syspbuff ne %then %do;

%let i=1;

%let month=%scan(&syspbuff,&i);

%do %while(&month ne);

proc print data=test

(where=(month(datesold)=&month));

title “Section Sales Report for Month &month”;

run;

%let i=%eval(&i+1);

%let month=%scan(&syspbuff,&i);

%end;

%mend;

%pbuffparms(4,6)

topic &syspbuff couldn't resolve to the value assigned in SAS Programming

&syspbuff couldn't resolve to the value assigned

Re: &syspbuff couldn't resolve to the value assigned