topic Re: plot hbar across variable in SAS Studio

plot hbar across variable

YangYY — Tue, 22 Oct 2019 06:33:56 GMT

Hi,

I have a data set which includes city, continent and average. Now I want to plot a hbar to show the average of each city across different continents with height=2200.

The result should be something like the attached document.

My approach code is

proc sgplot data=have;
hbar cities / response=average;
run;

But I have no idea how to make it across the continent.

Please help me if you have an idea.

Thank you

Re: plot hbar across variable

PeterClemmensen — Tue, 22 Oct 2019 06:38:57 GMT

@YangYY can you post some sample data for us to work with? Makes it easier to provide a usable code answer.

Re: plot hbar across variable

YangYY — Tue, 22 Oct 2019 08:26:00 GMT

city Average continent

Tirana, Albania 83 Europe

Yerevan, Armenia 90 Asia

Brisbane, Australia 35 Australia

Melbourne, Australia 31 Australia

Perth, Australia 34 Australia

Thank you so much

Re: plot hbar across variable

PeterClemmensen — Tue, 22 Oct 2019 08:27:27 GMT

And you want 1 plot for each continent, correct?

Re: plot hbar across variable

YangYY — Tue, 22 Oct 2019 08:52:28 GMT

Yes,exactly.

Re: plot hbar across variable

PeterClemmensen — Tue, 22 Oct 2019 09:05:38 GMT

See if this gets you going.

data have;
input city $ 1-21 Average continent $ 25-33;
datalines;
Tirana, Albania      83 Europe
Yerevan, Armenia     90 Asia
Brisbane, Australia  35 Australia
Melbourne, Australia 31 Australia
Perth, Australia     34 Australia
;

proc sort data=have;
    by continent;
run;

proc sgplot data=have;
    by continent;
    hbar city / response=Average colorresponse=Average colormodel=(green gold red);
run;

Re: plot hbar across variable

YangYY — Tue, 22 Oct 2019 10:44:15 GMT

Thank you so much!

It works good. And I also wondering can I arrange them from more to less in each plot?

I have tried to sort the data by average before the proc sgplot but it doesn't work.

Re: plot hbar across variable

PeterClemmensen — Tue, 22 Oct 2019 10:48:57 GMT

Add

categoryorder=respdesc

after the / in the HBAR Statement.

Re: plot hbar across variable

YangYY — Tue, 22 Oct 2019 11:41:15 GMT

Thank you!!