Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!umich!samsung!brutus.cs.uiuc.edu!psuvax1!psuvm!PANAM!AHMED From: AHMED@PANAM.BITNET (Zulfi Ahmed, Tr. & Supp. Specialist) Newsgroups: bit.listserv.sas-l Subject: Attention PROC TABULATE gurus Message-ID: Date: 7 Feb 90 20:42:00 GMT Sender: "SAS(r) Discussion" Reply-To: "Zulfi Ahmed, Tr. & Supp. Specialist" Lines: 42 Approved: NETNEWS@PSUVM Gateway Original_To: BITNET%"sas-l@tcsvm" Original_cc: AHMED Hi folks, I have survey data that was distributed to different classes. The survey record itself has the class number and 10 questions with answers ranging from 1 to 5. **************************************** section q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 =>This line is not in the data file 1111 1 1 1 2 3 4 5 5 3 3 2222 2 3 4 5 2 1 1 1 1 3 . . 1111 1 1 1 1 3 4 2 3 4 1 *************************************** I need to determine the frequency of answers to each question by class, i.e, I would llike a report for each class on a separate page with Q!-Q10 going down vertically, and frequency of ocuurrence of the choices going horizontally. Following is a desired format. SECTION 1111 1 2 3 4 5 __________________________ Q1 20 13 11 11 10 Q2 . Q3 . . . . . Q10 . __________________________ I have used the following which gives me a report of frquency by each class but it is not in the format I want: ************************************************************* PROC TABULATE; CLASS SECTION Q1-Q10 MISSING F=8.2; TABLE (Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10)*(N)/RTS=12 CONDENSE; BY CLASS; ************************************************************* I have racked my brains with the PROC TABULATE section of the manual without luck. Any help would be appreciated.