## Plotting Frequencies

Solved
Frequent Contributor
Posts: 140

# 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
Super User
Posts: 23,339

## 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;

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
Super User
Posts: 23,339

## 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: 140

## Re: Plotting Frequencies

Reeza,

I learned something new today! Makes it all worthwhile.

Thanks,

Brian

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
• 3 replies
• 355 views
• 3 likes
• 3 in conversation