BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
palolix
Lapis Lazuli | Level 10

 

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.

 

palolix_0-1775779617679.png

 

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
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 ;

View solution in original post

2 REPLIES 2
Ksharp
Super User
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 ;
palolix
Lapis Lazuli | Level 10

It worked! Thank you so much Ksharp!!

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 310 views
  • 2 likes
  • 2 in conversation