sgplot sorting by frequency

[zimcom]

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!!

[FreelanceReinh · Accepted solution]

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.

[zimcom]

Thank you so much!!!

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

[FreelanceReinh]

---

@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)";