DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 53

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

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

 

 

Super User
Posts: 24,027

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

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.

 

 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation