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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.