topic Graphing Proc Tabulate Output in ODS and Base Reporting

Graphing Proc Tabulate Output

deleted_user — Tue, 13 Mar 2007 14:30:44 GMT

Hi. This might be a basic question but my SAS skills are a bit rusty. I have created tables using proc tabulate that show the range of responses to a survey question over the course of 4 periods. I now want to graph the data from each table. Does Proc Tabulate allow me to output the data? Do I need to do this using a different procedure and then output it? Thanks.

Re: Graphing Proc Tabulate Output

deleted_user — Tue, 13 Mar 2007 16:14:08 GMT

although Proc Tabulate has an out= option you might find it simpler to graph the input to tabulate. If you post some sample data, preliminary (Tabulate) code and some idea of the dimensions/responses that you are interested in graphing, we might be able to help.

Good Luck

PeterC

Re: Graphing Proc Tabulate Output

deleted_user — Tue, 13 Mar 2007 17:30:28 GMT

Here's a sample of the code:

proc tabulate data=second;
by unit;
tables q19*colpctn,quarter;
class q19 quarter;
format q19 ep.;
run;

This creates a basic 5x4 table. However, there are 28 units so there are 28 separate tables. The basic layout of the table is:

Quarter 1 Quarter 2 Quarter3 Quarter4
Excellent 50% 44% 53% 40%
Very Good 31% 39% 20% 40%
Good 9% 11% 20% 10%
Fair 3% 0% 7% 7%
Poor 6% 6% 0% 3%