Plotting Frequencies

[BTAinRVA]

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

[AncaTilea]

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.

[Reeza · Accepted solution]

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;

[BTAinRVA]

Reeza,

I learned something new today! Makes it all worthwhile.

Thanks,

Brian