This really shouldn't be so difficult. Maybe my brain is still in weekend mode. I have a table of students and four columns (Graduated, Transferred, Grad&Trans, GradOrTrans) that have 0 or 1 depending on if they graduated and/or transferred. How can I make a bargraph that shows the percentage of 1's in each column?
Thanks,
Brian
Here's an example using SASHELP.CLASS. This assumes you have SAS 9.3+ to use the STACKODS option and the concept that the average of a binary variable is the same as the percent (though that's not shown here).
proc means data=sashelp.class stackods mean;
var age weight height;
ods table Summary=Summary1;
run;
proc sgplot data=summary1;
vbarparm category=variable response=mean;
run;quit;
Something like this would work:
data in;
input status group $;
datalines;
1 G
1 T
1 G&T
1 GorT
1 G
1 G
1 G
0 T
0 T
0 GorT
0 GorT
0 GorT
1 GorT
1 GorT
1 GorT
1 G&T
0 G&T
0 G&T
0 G&T
0 G&T
0 G
1 T
1 T
1 G
;
PROC FREQ DATA = IN;TABLES GROUP;RUN;
PROC GCHART DATA = IN;
VBAR GROUP/SUMVAR = STATUS PCT;
RUN;QUIT;
There are more options to enhance the graph...but to get you started.
Good luck,
Anca.
Here's an example using SASHELP.CLASS. This assumes you have SAS 9.3+ to use the STACKODS option and the concept that the average of a binary variable is the same as the percent (though that's not shown here).
proc means data=sashelp.class stackods mean;
var age weight height;
ods table Summary=Summary1;
run;
proc sgplot data=summary1;
vbarparm category=variable response=mean;
run;quit;
Reeza,
I learned something new today! Makes it all worthwhile.
Thanks,
Brian
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.