10-05-2017 11:46 AM
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;
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.
10-05-2017 12:09 PM
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.