Dear SAS community
I have a variable "gene" with 3 possible values (AA, AG, GG). I need to run proc anova to capture the 3 group mean systolic blood pressure (SBP), N of the 3 groups, F value and its P value, (correct for multiple comparison using Turkey) and P values comparing these group means. Would also want to plot the box plots of the 3 groups
So I run this code:
proc anova data = set1;
class gene; model SBP = gene; means gene /tukey cldiff;
run;
But beyond blood pressure I also need to run the same for 200 other continuous variables. Is there a way to generate a table that captures all of the above?
I also have 50 binary variables that I need to run proc freq for trend against the gene variable.
Any thoughts are much appreciated.
Thanks
Raymond
1. Create a macro for the procedures, see here: https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/
2. Capture the results from the ODS tables and store them, see here: https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html
3. Combine ODS output and format for your final results - likely data step and PROC PRINT or REPORT.
PS If you're hiring a SAS consultant for programming feel free to email me.
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 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.