Hi:
I am having trouble analyzing Multiple Choice questions of a survey.
Survey Monkey provided me a table with all answers to my questions.
For multiple choice questions it coded each choice into one variable.
When I analyze the data for one question, I get many tables (one for each variable).
I would like to know if it possible to get all "choice" variables in one single table:
With the current code:
Proc freq data=work.cmoj;
Tables (
Principales_act_1
Principales_act_2
Principales_act_3
Principales_act_4
Principales_act_5
Principales_act_6
Principales_act_7
Principales_act_otro) *Attendance_2019/ nocol norow;
Run;
I get one table for each variable, but what I want to do is have one table that includes all choice variable in rows, and the crossed variable choices in columns.
Thank you very much.
Hi Reeza:
Thank you very much for answer. I think transposing would't do what I need.
My data structure is in this way:
Attribute__1 | Attribute__2 | Attribute__3 | Attribute__4 | Attribute__5 | Type_assit |
Socialize | freq | ||||
Sessions | Congress | ocas | |||
Sessions | Congress | Certification | Social Service | Socialize | freq |
Sessions | ocas | ||||
Sessions | Congress | Certification | freq | ||
Sessions | Congress | Certification | ocas | ||
Sessions | Congress | Certification | Socialize | freq |
What I want to read is in this way:
freq | ocas | Total | freq | ocas | Total | |
Sessions | 10 | 9 | 19 | 36% | 38% | 37% |
Congress | 7 | 6 | 13 | 25% | 25% | 25% |
Certification | 6 | 3 | 9 | 21% | 13% | 17% |
Social Service | 2 | 2 | 4 | 7% | 8% | 8% |
Socialize | 3 | 4 | 7 | 11% | 17% | 13% |
28 | 24 | 52 | 100% | 100% | 100% |
Hope this can illustrate my issue, thanks again for your time.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.