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!!
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.