%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;   %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. ... View more

Hi guys, I tried ODS html; and Tools-Options-Preferences-Results-Circle Create HIML; Both of them do not work and I still can't open html output. Can you give me some ideas? Thank you! ... View more

Hi guys, I want to create a table like this by using PROC REPORT:              -Gender-         -Gender-    Age  Female Male  Female Male Group     SBP  SBP     DBP  DBP <=50        XX     XX        XX     XX   >50        XX     XX        XX     XX The data set I have looks like this: Gender Age SBP DBP M 23 144 90 F 68 110 62 M 55 130 80 F 28 120 70 M 35 142 82 M 45 150 96 F 48 138 88 F 78 132 76 My problem is: I can create a new variable 'Age Group' with values '<=50' and '>50', but I couldn't group the created 'Age Group' variable. Can anyone give me some insights? Thank you. ... View more

Hi guys, do you have any idea on how to use proc transpose to convert data have---> data want? data have: Obs Subj X1 X2 X3 X4 X5 Y1 Y2 Y3 Y4 Y5 1      001 8 5 6 5 4 10 20 30 40 50 2      002 7 5 6 4 5 11 33 29 34 56 3      003 2 2 4 5 6 22 38 21 20 34 data want: Obs Subj Time X Y 1      001 1 8 10 2      001 2 5 20 3      001 3 6 30 4      001 4 5 40 5      001 5 4 50 6      002 1 7 11 7      002 2 5 33 8      002 3 6 29 9      002 4 4 34 10      002 5 5 56 I wrote the following codes: proc transpose data=learn.wide out=long; by Subj; var X1-X5 Y1-Y5; run; The problem is that X variables and Y variables are under the same column, looks like below: Subj    _name_   Col1 001     X1               8 001     X2               5 001     X3               6 001     X4               5 001     X5               4 001     Y1               10 001     Y2               20 ..... ... View more