Hi everyone,
I have the responses from a survey. Some variables have multiple responses (check all that apply) and I was able to code them into binary responses (0/1) into each variable.
I need to calculate the frequency- count and percent of each variable (response) and present the numbers. My problem is that my output is not in the format it needs to be displayed.
Here is the SAS code I am using for above output- ( uses only one of the question responses- Q2_0 and its responses)
I need to do this for all the survey questions and their responses.
proc freq data=survey order= freq; table Relation__Mother Relation__Father Relation__Gaurdian Relation__Other; run;
The output needs to look like this- (Expected Output format)
I am sure I am missing the simplest of the step in my code, but I really could use help here, in the midst of running codes for 20 different things at the same time.
I have also attached the data.
Many thanks,
Sincerely,
Anu
With dichotomous 0/1 coded variables the Sum is the count of 1's and the Mean is the percent in decimal form.
I would be very hesitant in many cases to show a "cumulative" frequency or and especially percent as it may imply something not shown without a LOT of verbiage to describe the contents of the table and interpretation may be somewhat odd. For example think very carefully what is the denominator of that cumulative percent? Now, think again. After that, write it out so we can see what you think it should be.
With dichotomous 0/1 coded variables the Sum is the count of 1's and the Mean is the percent in decimal form.
I would be very hesitant in many cases to show a "cumulative" frequency or and especially percent as it may imply something not shown without a LOT of verbiage to describe the contents of the table and interpretation may be somewhat odd. For example think very carefully what is the denominator of that cumulative percent? Now, think again. After that, write it out so we can see what you think it should be.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.