Producing report in Word for frequency data from survey

[hypermonkey2]

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

[Reeza]

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;