topic Re: Removing a variable level from sgpanel in Graphics Programming

Removing a variable level from sgpanel

palolix — Fri, 10 Apr 2026 00:11:17 GMT

Dear SAS Community,

Is it possible to remove the level 'Initial' of the Treatments in Day=3 and Day=7? Since there is no initial treatment for these two days I would like to remove it for day 3 and 7 but I could not figure it how.

proc sgpanel data=new ;
title "Navel Test 1,2,5: Comparison of 'L' by Treatment at day 0, 3, and 7";
where Test in(1,2,5);
panelby Day/ rows=1 onepanel sparse spacing=10 ;
vbar Trt/ group=TRT_day3 groupdisplay=cluster clusterwidth=0.8 response=Avg_L stat=mean ;
rowaxis values=(0 to 80 by 20) refticks=(values) ;
keylegend / title='3-day Trt' ;
colaxis display=(nolabel);
run;

I tried this but it didn't work:

if Day=3 and Trt='Initial' then delete;
else if Day=7 and Trt='Initial' then delete;
run;

I would greatly appreciate it your help!

Thank you very much!

Re: Removing a variable level from sgpanel

Ksharp — Fri, 10 Apr 2026 06:28:58 GMT

Try option 'proportional' and 'uniscale=row' :

proc sgpanel data=new ;
title "Navel Test 1,2,5: Comparison of 'L' by Treatment at day 0, 3, and 7";
where Test in(1,2,5);
panelby Day/ rows=1 onepanel sparse spacing=10 proportional uniscale=row ;

Re: Removing a variable level from sgpanel

palolix — Fri, 10 Apr 2026 15:51:36 GMT

It worked! Thank you so much Ksharp!!