need to run proc anova and proc freq for trend for a large number of variables

rykwong — Thu, 05 Oct 2017 15:43:10 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 run proc anova and proc freq for trend for a large number of variables

WarrenKuhfeld — Thu, 05 Oct 2017 22:50:38 GMT

proc anova supports multiple dependents. proc freq supports multiple variables too.

proc anova data=sashelp.class;
   class sex;
   model age height weight = sex;
   run;

Re: need to run proc anova and proc freq for trend for a large number of variables

rykwong — Fri, 06 Oct 2017 00:34:58 GMT

many thanks to all

topic Re: need to run proc anova and proc freq for trend for a large number of variables in SAS Programming

need to run proc anova and proc freq for trend for a large number of variables

Re: need to run proc anova and proc freq for trend for a large number of variables

Re: need to run proc anova and proc freq for trend for a large number of variables