Hello ,
I'm trying to get the percentage of 1=Yes values for each question (Q1,Q2 etc) within each ID variable. Below is my data sample and desired output.
I did this using PROC SQL with sub queries but I'd like to get the same results using one of SAS procedure, I don't know maybe proc tabulate or proc freq etc... Could you please help ?
Data
ID | Q1 | Q2 | Q3 | Q4 |
A | 1 | 1 | 1 | 1 |
A | 1 | 0 | 1 | 0 |
A | 0 | 0 | 1 | 0 |
A | 1 | 1 | 0 | 0 |
B | 1 | 1 | 0 | 0 |
B | 0 | 1 | 0 | 1 |
B | 0 | 0 | 1 | 0 |
Output
ID | Q1_P | Q2_P | Q3_P | Q4_P |
A | 0.75 | 0.5 | 0.75 | 0.25 |
B | 0.3333 | 0.666667 | 0.3333 | 0.3333 |
I don't know if it needs transpose or not. Maybe you just want percent.
I would go ahead as get N, count, and percent.
Thank you, it seems like your process also needs transpose procedure for the output. I'll work on that.
I don't know if it needs transpose or not. Maybe you just want percent.
Thank you so much, I learned another procedure today...way better than Proc sql....
Best Regards...
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.