topic Re: Plot for multiple variables in SAS Programming

Plot for multiple variables

Yashponde — Wed, 05 Jun 2019 09:59:53 GMT

Hi guys,

I have created a table containing sum of a few variables. I wanted to plot the sum of these variables on a graph, preferably a histogram.

This would help me understand the different variables on a graph.

proc sql;
create table t4 as
select sum(Hardplastics) as Hard_Plastics, sum(Softplastics) as Soft_Plastics, sum(plasticlines) as Plastic_Lines, sum(styrofoam) as Styrofoam, sum(pellets) as Pellets, sum(driftingwood) as Drifting_Wood, sum(pumice) as Pumice
from assign2.survey;
run;

Intended Output

Re: Plot for multiple variables

Ksharp — Wed, 05 Jun 2019 14:03:27 GMT

proc sql;
create table have as
select 'age' as name length=20,sum(age) as sum from sashelp.class
union
select 'weight' as name length=20,sum(weight) as sum from sashelp.class
union
select 'height' as name length=20,sum(height) as sum from sashelp.class;
quit;
proc sgplot data=have;
vbar name / response=sum nostatlabel;
yaxis display=(noline) grid;
run;

Re: Plot for multiple variables

ballardw — Wed, 05 Jun 2019 14:42:30 GMT

It appears that you are in the same class as the author of https://communities.sas.com/t5/SAS-Programming/Renaming-variables-then-assign-a-numeric-to-the-renamed-variable/m-p/563682

may be it is time to form a study group?