topic Re: Plotting proportions by groups in Graphics Programming

Plotting proportions by groups

BlueNose — Mon, 21 Sep 2015 04:23:35 GMT

Hello all,

I have a data looking roughly like this:

Event: 0/1

Group: G1 / G2

AgeBin: 20-30/30-40/40-50/...

I want to plot the proportion of the event (proportion of 1's) for each group, by age bin. I though to put the age bins on the x-axis, the proportion on the y-axis, and for each age bin, to plot twp points, maybe with different shapes of markers, one for each group, and then I can see what happens to the difference between the groups when the age changes.

1. How do I do that ? The data I specified is my variables as they are. I guess I need sgplots, but not sure how to do this task, it doesn't look straightforward.

2. Is there a better representation that can suit my data ?

Thank you in advance !

Re: Plotting proportions by groups

GraphGuy — Mon, 21 Sep 2015 14:48:56 GMT

Perhaps pre-summarize your data, and create a grouped bar chart, something like this?

http://robslink.com/SAS/democd75/holiday_shopping_plans.htm

http://robslink.com/SAS/democd75/holiday_shopping_plans_info.htm

Re: Plotting proportions by groups

Rick_SAS — Mon, 21 Sep 2015 18:21:18 GMT

You can run PROC MEANS or some other procedure to get the proportions for each group and for each age group.

Then you can just use the SCATTER statement to plot the proportions against the age, using the GROUP= option to distinguish the groups.

/* make up some data */
data Have;
set sashelp.class sashelp.class sashelp.class;
event = rand("bernoulli", logistic(1 - age/10));
run;

/* compute proportion for each age group and group */
proc means data=Have;
class sex age;
var event;
output out=out mean=Proportion;
run;

proc sgplot data=out;
WHERE _TYPE_=3;
scatter y=proportion x=age / group=sex;
run;