GROTTA BAR

[desireatem]

Both can be used but I like the second plots. So they are both great solutions.

[desireatem]

Hello Reeza. I marked this as correct but for some reason the colors in the grotta bar does not match the key below. For home and IRF both should have same color for 0, 1, 2...., 6. Also how do I change the name form mrs_discharge in the key to "mrs at discharge"

[Reeza]

Show your full code with sample data. Obviously that isn't my code otherwise the categories would be as shown in the FORMAT statement.

[desireatem]

proc format;
value mRS_fmt
0 = "mRS 0"
1 = "mRS 1"
2 = "mRS 2"
3 = "mRS 3"
4 = "mRS 4"
5 = "mRS 5"
6 = "mRS 6";
run;

proc format;
value disposition_fmt
0 = "Home"
3 = "IRF";
run;

proc freq data=IRF_sub;
table disposition_1*mrs_discharge/ out=summary_data outpct;
format mrs_discharge mRS_fmt.;
run;

title "Discharge mRS by Disposition";
proc sgplot data=summary_data;
hbar disposition_1 / group = mrs_discharge response = pct_row stat=pct;
*to get counts labelled;
hbar disposition_1 / group = mrs_discharge response = count stat=sum seglabel x2axis;
x2axis display=none;
format disposition_1 disposition_fmt.;
run;

[Reeza]

Yeah, doesn't seem like it's quite right. Can you please clarify the requirements based on the sample data I provided. Exactly what numbers do you expect to see in the bars based on that random data.

[desireatem]

There are two gropus "Home Discharge" and "IRF Discharge" see table below. For for mRS at discharge equal 0, there were 75 from home discharge and 2 from IRF, so both should have same color . The proportion of the color in both group should be it proportion by group, that is 75/(75+176+ 106 +84+38+11+6) for home  discharge and 2/(2+32+36+59+86+16+8). Similar computation should be done for each mRS discharge by group

mRS at Hospital Discharge	Home Discharge	IRF Discharge
0	75	2
1	176	32
2	106	36
3	84	59
4	38	86
5	11	16
6	6	8

[Reeza]

If that was your data set does this graph show properly then?

proc transpose data=have out=tall;
by mrs;
var home irf;
run;



proc sgplot data=tall;
hbar _name_ / response = col1 group = mrs stat=pct;
run; 

[desireatem]

This is is an improvement but there are few issue.

1) The number for each color is not presented

2) The x-axis should be from 0 to 100%, since we are dealing with row percent.

3) I wish to change mrs_discharge on the key to "mRS at discharge"

[Reeza]

Is the data represented correctly such that I make those changes it would be what you need? I don't think that's right because if the bars are filled at 100% then that's a stacked bar chart, which this is not. It shows percent of total not row percent.

Which was the difference between the original two graphics created and my original question of which answer was right.....

[desireatem]

Thank you. I took off the percent in the x-axis and that's fine but how can I change the name in the key from "mrs_discharge" to "mRS at Discharge"???

[Reeza]

LABEL.

[desireatem]

Sorry Reeza, I do not understand. 

[Reeza]

Add a label to your variable.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsref/n1r8ub0jx34xfsn1ppcjfe0u16pc.htm

[desireatem]

Thank you, this complete it.