topic Re: Create a bar chart with heights for the percentage of the month total in SAS Programming

Create a bar chart with heights for the percentage of the month total

kz_ — Mon, 13 Sep 2021 20:26:30 GMT

I want to create a bar chart of data that is similar to that below. The bar chart should

- have a separate plot for each type

- have a cluster for each group, which has two bars (one for each month)

- set the height of the bar for each month as the percentage that that group constitutes of the total for that month.

For example, in the first plot for "basic" there would be three clusters. The group 1 cluster would have one bar for 2019-01 of height 100% (it constitutes all the data for that month) and one bar of height 50% for 2019-02.

The group 2 cluster would be 0% for both months.

The group 3 cluster would be 0% for 2019-01 and 50% for 2019-02.

I added these percentages in the 4th column, but it obviously doesn't capture the 0% observations. Also the percentages are repeated for each type-group-month, but there should only be one bar for each combination.

Obviously, I have way more data (groups, types, months) than this.

(Also I don't know how to write the input for the date since my data are already in SAS - this reads the date in wrong, but I can't figure out why.)

Thanks in advance!

data noname; 
infile datalines delimiter= ',';
input type $ group yr_mo YYMMD. percent_of_month_by_type;
datalines; 
basic, 1, 2019-01, 100%
basic, 1, 2019-01, 100%
basic, 1, 2019-02, 50%
basic, 3, 2019-02, 50% 
normal, 1, 2019-01, 50%
normal, 2, 2019-01, 50%
normal, 2, 2019-02, 33%
normal, 3, 2019-02, 66%
normal, 3, 2019-02, 66%
;

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Mon, 13 Sep 2021 20:16:36 GMT

A nice alternative would be a way to construct a bar chart with user-defined heights for the bars. If you take out the repeated rows above, the height is specified by the percent on the right.

basic, 1, 2019-01, 100%
basic, 1, 2019-02, 50%
basic, 3, 2019-02, 50% 
normal, 1, 2019-01, 50%
normal, 2, 2019-01, 50%
normal, 2, 2019-02, 33%
normal, 3, 2019-02, 66%

Re: Create a bar chart with heights for the percentage of the month total

Reeza — Mon, 13 Sep 2021 19:20:20 GMT

If you put in fake values then plot that data wouldn't that be a user defined height?
How do you want to user define the heights? Is that via prompt or some file that's provided? Will all data be refreshed or will you expect users to manually enter all data each month?

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Mon, 13 Sep 2021 19:21:45 GMT

What I meant was that I have already calculated the percents for each month but I don't know how to create a plot from a summary table.

Re: Create a bar chart with heights for the percentage of the month total

Reeza — Mon, 13 Sep 2021 19:29:09 GMT

Which variable is that in the data you posted?

Re: Create a bar chart with heights for the percentage of the month total

Reeza — Mon, 13 Sep 2021 19:34:25 GMT

Here are instructions on how to create sample data:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

And you can find example code for various different bar charts here:
https://robslink.com/SAS/ods2/aaaindex.htm

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Mon, 13 Sep 2021 20:00:35 GMT

Thanks, that seems like a useful link, but it doesn't include what I'm looking for.

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Mon, 13 Sep 2021 20:01:37 GMT

It's not in the data set - it's in the description. The percents that I calculated are in a separate, summary dataset.

I can add it, but I will have to add more data.

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Mon, 13 Sep 2021 20:03:00 GMT

Maybe you can suggest how to create the percents as fake values. It seems that when making a bar chart, SAS counts the rows.

Re: Create a bar chart with heights for the percentage of the month total

Reeza — Mon, 13 Sep 2021 21:17:22 GMT

I'm sorry, your question is too unclear for me to answer. I don't know what your input data looks like or what you want to graph. Hopefully someone else will be able to assist you.

Re: Create a bar chart with heights for the percentage of the month total

ballardw — Mon, 13 Sep 2021 23:22:02 GMT

@kz_ wrote:

A nice alternative would be a way to construct a bar chart with user-defined heights for the bars. If you take out the repeated rows above, the height is specified by the percent on the right.
basic, 1, 2019-01, 100%
basic, 1, 2019-02, 50%
basic, 3, 2019-02, 50% 
normal, 1, 2019-01, 50%
normal, 2, 2019-01, 50%
normal, 2, 2019-02, 33%
normal, 3, 2019-02, 66%

First thing, this data makes more sense than the other.

data noname; 
infile datalines delimiter= ',-';
input type $ group yr mo percent_of_month_by_type percent.;
yr_mo = mdy(mo,1,yr);
format yr_mo yymmd.;
datalines; 
basic,1,2019-01,100%
basic,1,2019-02,50%
basic,3,2019-02,50%
normal,1,2019-01,50%
normal,2,2019-01,50%
normal,2,2019-02,33%
normal,3,2019-02,66%
;

proc sort data=noname;
   by type yr_mo group;
run;

proc sgplot data=noname;
   by type;
   vbar yr_mo /response=percent_of_month_by_type group=group
      groupdisplay=cluster;
   format percent_of_month_by_type percent6.;
   yaxis values=(0 to 1 by .25) label="Percent";
run;

Your date informat didn't work because there is no SAS supplied informat to read YYYY-MM data. So read the bits and use the MDY function as on way. Note use of two delimiters so the - is treated as a delimiter.

There is something needed to display "0" bars. One way is to include 0 values and use datalabel option, but no actual bar is visible just the number that would be 0% displayed near the axis.

Another way would be to use a DATTRMAP data set to provide the option of setting specific colors for each group value and to display the value of the group variable even when not present. Search the forum for some examples as this is a specially structured data set with specific variables and I'm too lazy to go into all the details (again).

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Fri, 17 Sep 2021 19:42:05 GMT

This almost works, but there is the same problem I was having. I want all the bars for group 1 to be adjacent to each other (I used the word 'cluster' in the question - maybe that was confusing).

Re: Create a bar chart with heights for the percentage of the month total

kz_ — Fri, 17 Sep 2021 19:42:42 GMT

In any case, I have decided on a different display of the data, so I will accept this as the solution.