LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2011, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sun, 27 Nov 2011 16:12:22 -0500
Reply-To:     bbser 2009 <bbser2009@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         bbser 2009 <bbser2009@GMAIL.COM>
Subject:      Re: producing frequency percentages for multiple questions
Comments: To: "Painter, John (jsp9a)" <jsp9a@ESERVICES.VIRGINIA.EDU>
In-Reply-To:  <>
Content-Type: text/plain; charset="us-ascii"


This is just about the clumsiness you mentioned below. But I am not sure if this will be helpful. 1. Given 30 tables as SAS data sets, you might want to use macro loop and proc append to concatenate them automatically. 2. For raw data files, just use infile statement option filevar= to automatically concatenate them.

Regards, Max (Maaxx)

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Painter, John (jsp9a) Sent: November-26-11 3:06 PM To: SAS-L@LISTSERV.UGA.EDU Subject: [SAS-L] producing frequency percentages for multiple questions

Dear List,

I need to summarize % endorsing each response option for customer satisfaction survey data consisting of 14 questions (4-pt likert type scale) and 30 products. The data are summarized overall for each of the 14 questions, then by product so I have 31 tables in the end.

It has been a while since I've attempted this in SAS. For the overall table I can obtain the frequency stats using proc freq, save each data file, and concatenate them to form the desired table. But this seems very clumsy. Is there a more efficient procedure?

For the second type of report table I started with proc tabulate and this code:

Proc tabulate ; Class product q1 ; Table product q1 ; Run ; ODS OOUTPUT table=q1 ;

Which delivers the error "The variable Q1 conflicts with the keyword of the same name." The output looks like something I can use in a data step, but of course no data file is produced. Any advice? I would prefer to have percentages instead of counts. And I would like to include all 14 items in one analysis, instead of running the same procedure 14 times.

Hopefully this makes sense.

Thank you,


Back to: Top of message | Previous page | Main SAS-L page