topic Re: SQL: Problem getting Barplot to sort? in SAS Software for Learning Community

SQL: Problem getting Barplot to sort?

davidjayjackson — Mon, 04 Nov 2024 22:49:30 GMT

Hey,

When I run the code below, the barplot is not shorting by city name and not city_count. Thanks David

libname party xlsx "/home/u64077777/My SAS File/Party.xlsx";


proc sql;
	drop table invites_summary;
	CREATE TABLE invites_summary AS
	SELECT City,count(*) as city_count
		FROM Party.contacts
		GROUP BY City;
quit;

proc sort data=invites_summary out=sorted_invites_summary;
    by descending city_count;
run;

proc sgplot data=sorted_invites_summary;
    hbar City / response=city_count;
    xaxis label="City";
    yaxis label="Number of People Invited";
run;

Re: SQL: Problem getting Barplot to sort?

ballardw — Mon, 04 Nov 2024 23:40:55 GMT

If you want the the plot to be sorted by the Response variable value you use the option CATEGORYORDER with either RESPASC or RESPDESC to order in response variable ascending or descending order respectively.

proc sgplot data=sorted_invites_summary;
    hbar City / response=city_count  categoryorder=respdesc;
    xaxis label="City";
    yaxis label="Number of People Invited";
run;

Note that for many of the graph types sorting the data doesn't really translate to order in the graph unless there is a DATA option for an some sort of Order related option.

Re: SQL: Problem getting Barplot to sort?

davidjayjackson — Tue, 05 Nov 2024 01:07:11 GMT

Thanks, that was what I was looking for.

David