Hello community members, I am fairly novice SAS user and I am seeking help in perform certain analysis. To begin with, I have a dataset from a survey that asked participants to rate statements on a 5-point Likert scale. The dataset has about 80 variables representing the statements and variables on demographics (gender, age, race, etc.) and there are about 800 observations. Here is an example of the dataset. Due to certain privacy concern, I can not share the actual dataset: Observations Q1 Q2 Q3 Q4 Q5 1 Strongly Agree Agree Strongly Disagree Disagree Neutral 2 Agree Agree Disagree Neutral Neutral 3 Strongly Agree Strongly Disagree Agree Strongly Disagree Agree 4 Disagree Agree Neutral Strongly Agree Disagree 5 Disagree Agree Disagree 6 Strongly Disagree Strongly Agree Strongly Disagree Neutral Disagree 7 Agree Neutral Agree Agree Agree 8 Strongly Disagree Strongly Disagree Disagree Strongly Disagree Neutral 9 Neutral Strongly Disagree Strongly Agree Neutral Agree 10 Agree Strongly Agree Strongly Agree Agree Agree What I am interested in doing is combining some of these variables (i.e. Q1, Q3, and Q5) together to get an average frequency and percentage of observed responses. For example, the average frequency of responses across variable Q1, Q3, and Q5 that indicated they "Strongly Agree" is 4 observed responses out of 30 total responses which is about 13%. Conceptually, I understand how to do this, but not on SAS. I've tried Proc Freq to obtain frequency and percentage counts for one variable, but was unable to get the counts across more than one variable. Also, I am interested in cross tabbing the average count with the demographic variable as well, which seem to pose even more complication. I hope this makes sense. Thanks for any help.
... View more