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

rykwong — Thu, 05 Oct 2017 15:46:42 GMT

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

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

Reeza — Thu, 05 Oct 2017 16:09:37 GMT

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.

topic Re: need to perform a large number of proc anova on the same class variable, proc freq for trend as in SAS Programming

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

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