topic Re: Help with SGPanel attributes in SAS Programming

Help with SGPanel attributes

sms1891 — Wed, 15 Feb 2023 16:56:25 GMT

Hi experts,

I generated an output using SGpanel, however for my y-axis variable (Enrollment_Year 2017, 2018, 2019, 2020, 2021, 2022), the graph output is giving me labeling only for even years and skipping out odd year labeling on the graph.

Thank you for your help in advance!

proc means data=bar1 noprint nway;
 class measure Enrollment_year ;
 var score ;
 where score >.;
 output out=bytype (drop=_type_ _freq_) n(score)=n mean(score )=mean  uclm(score)=uclm lclm(score )=lclm;
 run;  

* also make an overall graph;
proc means data=bar1 noprint nway;
 class Enrollment_year   ;
 var score ;
 where score >.;
 output out=bytypeall (drop=_type_ _freq_) n(score)=n  mean(score )=mean  uclm(score)=uclm lclm(score )=lclm;
 run;  
 data bytypeall; set bytypeall;
  measure="OVERALL"; 
  run;  
 

data bytype2; set bytype bytypeall;
 Activity=measure; * just renaming;
  
  meanround=round(mean,.1); format meanround 4.1;
  group=measure ||' '||  Enrollment_year || '  '||(put(n,$3.))||'  '||put(meanround,f4.1) ;

  typen=  Enrollment_year  || '  '||(put(n,$3.))||'  '||put(meanround,f4.1) ;
  labelatzero=.01;
  labelatzero2='N = '||(put(n,$3.));
  *if activity='OVERALL' then labelatzero2=' ';

run; 

title 'Dont use this plot because there are not enough practices in act 1 to 10 in early years';
* the problem with sgpanel is the number of graphs to look at is uneven and height cant be specified - ah - can change height though!;
ods graphics on /  border=off height=10in width=8in noscale outputfmt=png ;
proc sgpanel data=bytype2 ; 
 panelby Activity/ layout=panel border /*noheaderborder*/ columns=2 rows=8  skipemptycells /*onepanel*/ 
         headerbackcolor=lightgrey headerattrs=(family=arial size=9 weight=bold color=black);
 highlow y=Enrollment_year   high=uclm low=lclm/ type=bar barwidth=.5 nooutline fillattrs=(color=cx42A5F5)  transparency=.3
       name='bar' legendlabel='95% Confidence Interval';
 scatter y=Enrollment_year    x=mean/Markerattrs=( Symbol=CIRCLEFILLED color=black Size=12) NAME="dot" legendlabel='Mean'; 
   colaxis label='Score' min=0 max=4 values=(0 1 2 3 4) labelattrs=(family=arial size=10 weight=bold color=black); 
   rowaxis label='Enrollment Year' labelattrs=(family=arial size=8 weight=bold color=black) REVERSE ; 
   text y=Enrollment_year  x=labelatzero text= labelatzero2;
   keylegend 'dot' 'bar';
 run;

Re: Help with SGPanel attributes

ballardw — Wed, 15 Feb 2023 17:12:47 GMT

Add a VALUES= list of values to your Rowaxis statement.

   rowaxis label='Enrollment Year' labelattrs=(family=arial size=8 weight=bold color=black) values=(2017 to 2022 by 1) REVERSE ;

@sms1891 wrote:

Hi experts,

Thank you for your help in advance!

proc means data=bar1 noprint nway;
 class measure Enrollment_year ;
 var score ;
 where score >.;
 output out=bytype (drop=_type_ _freq_) n(score)=n mean(score )=mean  uclm(score)=uclm lclm(score )=lclm;
 run;  

* also make an overall graph;
proc means data=bar1 noprint nway;
 class Enrollment_year   ;
 var score ;
 where score >.;
 output out=bytypeall (drop=_type_ _freq_) n(score)=n  mean(score )=mean  uclm(score)=uclm lclm(score )=lclm;
 run;  
 data bytypeall; set bytypeall;
  measure="OVERALL"; 
  run;  
 

data bytype2; set bytype bytypeall;
 Activity=measure; * just renaming;
  
  meanround=round(mean,.1); format meanround 4.1;
  group=measure ||' '||  Enrollment_year || '  '||(put(n,$3.))||'  '||put(meanround,f4.1) ;

  typen=  Enrollment_year  || '  '||(put(n,$3.))||'  '||put(meanround,f4.1) ;
  labelatzero=.01;
  labelatzero2='N = '||(put(n,$3.));
  *if activity='OVERALL' then labelatzero2=' ';

run; 

title 'Dont use this plot because there are not enough practices in act 1 to 10 in early years';
* the problem with sgpanel is the number of graphs to look at is uneven and height cant be specified - ah - can change height though!;
ods graphics on /  border=off height=10in width=8in noscale outputfmt=png ;
proc sgpanel data=bytype2 ; 
 panelby Activity/ layout=panel border /*noheaderborder*/ columns=2 rows=8  skipemptycells /*onepanel*/ 
         headerbackcolor=lightgrey headerattrs=(family=arial size=9 weight=bold color=black);
 highlow y=Enrollment_year   high=uclm low=lclm/ type=bar barwidth=.5 nooutline fillattrs=(color=cx42A5F5)  transparency=.3
       name='bar' legendlabel='95% Confidence Interval';
 scatter y=Enrollment_year    x=mean/Markerattrs=( Symbol=CIRCLEFILLED color=black Size=12) NAME="dot" legendlabel='Mean'; 
   colaxis label='Score' min=0 max=4 values=(0 1 2 3 4) labelattrs=(family=arial size=10 weight=bold color=black); 
   rowaxis label='Enrollment Year' labelattrs=(family=arial size=8 weight=bold color=black) REVERSE ; 
   text y=Enrollment_year  x=labelatzero text= labelatzero2;
   keylegend 'dot' 'bar';
 run;

Re: Help with SGPanel attributes

sms1891 — Wed, 15 Feb 2023 17:29:12 GMT

Thank you for the response. Tried rowaxis label='Enrollment Year' labelattrs=(family=arial size=10 weight=bold color=black) values=(2017 to 2022 by 1) REVERSE ;

Still not working.