topic Re: sgplot sorting by frequency in Graphics Programming

sgplot sorting by frequency

zimcom — Tue, 22 Sep 2020 13:54:35 GMT

I am creating a bar graph using the following sgplot, the bar graph generated is sorted by the aedecod alphabetically, but I really want to bar graph sorted by the frequency of the aedecod,

proc sgplot data=SAE;
hbar aedecod / datalabel
fillattrs=graphdata2;
yaxis display=(nolabel);
xaxis grid;
run;

Thank you so much!!

Re: sgplot sorting by frequency

FreelanceReinh — Tue, 22 Sep 2020 14:10:40 GMT

Hi @zimcom,

Add the CATEGORYORDER= option to the existing options (DATALABEL and FILLATTRS=...) of the HBAR statement:

categoryorder=respdesc

to sort by descending frequencies or

categoryorder=respasc

to sort by ascending frequencies.

Re: sgplot sorting by frequency

zimcom — Tue, 22 Sep 2020 14:15:39 GMT

Thank you so much!!!

Another wish to have, can i add the total count in the graph title?

Re: sgplot sorting by frequency

FreelanceReinh — Tue, 22 Sep 2020 14:40:55 GMT

@zimcom wrote:
Another wish to have, can i add the total count in the graph title?

Sure. I would probably use a preliminary (DATA or PROC SQL) step to determine the total count and assign it to a macro variable. A reference to this macro variable could then be used in the TITLE statement.

Example -- assuming that the number of observations in dataset SAE equals the total count you need:

data _null_;
call symputx('nSAE',n);
stop;
set sae nobs=n; 
run;

title "SAE frequencies (total=&nSAE)";