topic Re: Creating a VBAR using a variable as weight for each value of another variable in SAS Programming

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

adhunamukherjee — Mon, 07 Dec 2020 02:31:38 GMT

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:

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

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

ghosh — Mon, 07 Dec 2020 04:07:31 GMT

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;

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

AnnaWoolery — Tue, 08 Dec 2020 16:01:33 GMT

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;