topic Re: Plotting Frequencies in ODS and Base Reporting

Plotting Frequencies

BTAinRVA — Mon, 09 Dec 2013 17:39:00 GMT

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

Re: Plotting Frequencies

AncaTilea — Mon, 09 Dec 2013 18:10:16 GMT

Something like this would work:

data in;

input status group $;

datalines;

1 G

1 T

1 G&T

1 GorT

1 G

0 T

0 GorT

1 GorT

1 G&T

0 G&T

0 G

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.

Re: Plotting Frequencies

Reeza — Mon, 09 Dec 2013 18:25:47 GMT

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;

Re: Plotting Frequencies

BTAinRVA — Mon, 09 Dec 2013 19:54:05 GMT

Reeza,

I learned something new today! Makes it all worthwhile.

Thanks,

Brian