Proc SGPANEL

[erima_goyal]

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

[DanH_sas]

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

[erima_goyal]

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]

Hey Erima,

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

Thanks!

Dan