BookmarkSubscribeRSS Feed
erima_goyal
Calcite | Level 5

I am using Base SAS (SAS Release 9.04.01M6P110718). We were recently upgraded to this version. I noticed that "categoryorder = respdesc", that was used to sort the categories in final graph, is not working in this version. Is there a work around? Here is the complete code

 

PROC SGPANEL DATA=input_data;
FORMAT change mm3fmt. ind_grp tierfmt. group groupfmt.;
panelby group/ novarname columns=3 headerattrs=( family=arial size=10 weight=bold);
styleattrs datacolors=(grey grey grey);
hbar ind_grp/ response=change
stat=sum dataskin=pressed barwidth=0.8 categoryorder=respdesc datalabel datalabelattrs=(size=10 weight=bold color = black) ;
title "YoY Change";
rowaxis display=(nolabel) valueattrs=(size=9);
colaxis display=(noticks novalues) label = "ABC not included" labelattrs=(color=black);
run;

 

Thanks,

Erima

3 REPLIES 3
DanH_sas
SAS Super FREQ

What happens if you remove the COLUMNS=3 and set LAYOUT=ROWLATTICE on the PANELBY statement?

erima_goyal
Calcite | Level 5

Hi Dan, 

 

I tried both columnlattice and rowlattice. The later does not work for the way I want to look at things, for the column lattice here are the challenges I see

1. The graph gets reduced to two column by default. I need four columns side by side

2. It still does not sort

 

Thanks,

Erima

DanH_sas
SAS Super FREQ

Hey Erima,

 

Can you post a picture of the original layout you wanted?

 

Thanks!

Dan

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register 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
  • 3 replies
  • 615 views
  • 2 likes
  • 2 in conversation