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!
It worked! Thank you so much Ksharp!!
Dive into keynotes, announcements and breakthroughs on demand.
Explore Now →Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.