topic Producing report in Word for frequency data from survey in SAS Procedures

Producing report in Word for frequency data from survey

hypermonkey2 — Wed, 06 Mar 2013 01:58:55 GMT

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!!

Re: Producing report in Word for frequency data from survey

Reeza — Wed, 06 Mar 2013 02:27:24 GMT

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;