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!!
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.
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 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)";
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.