The SAS Output Delivery System and reporting techniques

Plotting Frequencies

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 126
Accepted Solution

Plotting Frequencies

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


Accepted Solutions
Solution
‎12-09-2013 01:25 PM
Grand Advisor
Posts: 16,393

Re: Plotting Frequencies

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;

View solution in original post


All Replies
Super Contributor
Posts: 543

Re: Plotting Frequencies

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.

Solution
‎12-09-2013 01:25 PM
Grand Advisor
Posts: 16,393

Re: Plotting Frequencies

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;

Frequent Contributor
Posts: 126

Re: Plotting Frequencies

Reeza,

I learned something new today! Makes it all worthwhile.

Thanks,

Brian

Post a Question
Discussion Stats
  • 3 replies
  • 295 views
  • 3 likes
  • 3 in conversation