Creating a VBAR using a variable as weight for each value of another variable

[adhunamukherjee]

Hello SAS Communities, 

I have the following table:

StateCd	HypRelDeathInd	Frequency	ColPercent
Iowa	Yes	3	1.53
Mississippi	Yes	6	2.90
Utah	Yes	2	1.18

I want to create a vertical bar chart which displays the percentage of people who experienced a hypertension-related death for each of the 3 states.

The x axis should be Iowa, Mississippi and Utah. The bar chart for each x value should be the ColPercent value. It should look as follows:

Project 3 graph.png
I have only generated a bar chart which takes in a variable and plots the frequency of each value of the variable as the weight of the variable. 

I am not sure how to use another column as the weight of the bar chart. I need to implement the PROC SGPLOT which can achieve this.

Thank you,

Adhuna Mukhopadhyay

[ghosh]

There is a Weight option you can specify after the slash, but from your description I think you want to specify the colpct as a response

proc sgplot data=mydata;
  vbar StateCd /
    response=ColPct;
run;

[AnnaWoolery]

Hi Adhuna - to build off of what ghosh responded, below is the code I would use to achieve this 🙂

VBAR StateCd / RESPONSE = ColPercent
FILLATTRS = (COLOR = LIGHTSALMON)
DATALABEL = COLPercent;
FORMAT COLPercent 6.4;