Help using Base SAS procedures

Producing report in Word for frequency data from survey

Reply
Occasional Contributor
Posts: 10

Producing report in Word for frequency data from survey

Hi all,

I've been using the following code to produce frequency counts and percentages of Yes responses for a series of binary questions on a survey (contained in "dataset").

proc tabulate data=dataset;

     var _NUMERIC_;

     table _NUMERIC_,n='Count' sum='Number of ones' mean= 'Percent ones'*f=percent10.2;

run;

How can i only select certain survey questions (variables) and present them neatly in table form, say, in Word, without manually transcribing everything?

I'd love to learn about different ways to do this, since I expect to need to run this for numerous data sets.

Many thanks!!

Super User
Posts: 18,549

Re: Producing report in Word for frequency data from survey

I'd suggest figuring out how to get the data you want in SAS using proc tabulate first.

To get your data to Word you can use ODS RTF. To specify only questions of interest you could put the variables in the table list rather than _numeric_.

For example:

ods rtf file="C:\temp\test.rtf" style=meadow;

*I'm not sure this proc tabulate code would actually work;

proc tabulate data=dataset;

     var var_1 var_2;

     table var_1 var_2, n='Count' sum='Number of ones' mean= 'Percent ones'*f=percent10.2;

run;

ods rtf close;

Ask a Question
Discussion stats
  • 1 reply
  • 132 views
  • 3 likes
  • 2 in conversation