Plotting - 2 Categorical Columns and Y Numerical

Ariel_1 — Wed, 27 Mar 2019 21:38:01 GMT

I am trying to plot a vertical barplot that will have a Percentage in the y column (from 0 -100)

On the Horizontal Axis i want the labels to come from two separate columns. Does anyone have a recommendation

The data looks like this

Category sub-Categorical %

A 1 50

A 2 45

A 3 40

B 4 10

B 5 25

B 6 30

c 7 10

c 8 25

c 9 30

c 10 30

Re: Plotting - 2 Categorical Columns and Y Numerical

ballardw — Thu, 28 Mar 2019 17:11:15 GMT

One way:

data    have;
input Category  $        subCat  $   percent;
datalines;
A        1    50
A        2    45
A        3    40
B        4    10
B        5    25
B        6    30
c        7    10
c        8    25
c        9    30
c        10   30     
;
run;

proc sgplot data=have;
   vbar category/ response=percent group=subcat groupdisplay=cluster;
   yaxis label='Percent';
run;

proc sgpanel data=have;
  panelby category / layout=columnlattice novarname noborder colheaderpos=bottom;
  vbar subcat / response=percent  ;
  rowaxis grid;
run;

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

topic Re: Plotting - 2 Categorical Columns and Y Numerical in New SAS User

Plotting - 2 Categorical Columns and Y Numerical

Re: Plotting - 2 Categorical Columns and Y Numerical