BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
2 REPLIES 2
deleted_user
Not applicable
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
deleted_user
Not applicable
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%
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1305 views
  • 0 likes
  • 1 in conversation