topic Re: Proc SGPANEL in Graphics Programming

Proc SGPANEL

erima_goyal — Tue, 14 Jan 2020 17:50:25 GMT

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

Re: Proc SGPANEL

DanH_sas — Tue, 14 Jan 2020 19:32:37 GMT

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

Re: Proc SGPANEL

erima_goyal — Tue, 28 Jan 2020 21:26:53 GMT

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

Re: Proc SGPANEL

DanH_sas — Wed, 29 Jan 2020 13:46:36 GMT

Hey Erima,

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

Thanks!

Dan