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...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.