need to perform a large number of proc anova on the same class variable, proc freq for trend as well

[rykwong]

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

[Reeza]

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.