proc summary nway help

michtka — Fri, 13 Apr 2012 14:55:17 GMT

Hi everyone, I need help with this for using proc summary....

I've got the next dataaset :

Obs VISit classy pop TREAT

1 Baseline Missing 1 Placebo

                              2    Week 12 LOCF      I            1     Placebo
                              3    Baseline                II           1     Placebo
                              4    Baseline                II           1     Placebo
                              5    Baseline                II           1     Placebo
                              6    Baseline                II           1     Placebo
                              7    Baseline                II           1     Placebo
                              8    Baseline                II           1     Placebo
                              9    Baseline                II           1     Placebo
                             10    Baseline                II           1     Placebo
                             11    Baseline                II           1     Placebo
                             12    Baseline                II           1     Placebo
                             13    Baseline                II           1     Placebo

                             14    Baseline                II           1     Placebo
                             15    Baseline                II           1     Placebo
                             16    Baseline                II           1     Placebo
                             17    Baseline                II           1     Placebo
                             18    Baseline                II           1     Placebo
                             19    Baseline                II           1     Placebo
                             20    Baseline                II           1     Placebo

                             21    Baseline                II           1     Placebo
                             22    Baseline                II           1     Placebo
                             23    Baseline                II           1     Placebo
                             24    Baseline                II           1     Placebo
                             25    Baseline                II           1     Placebo

                             26    Baseline                II           1     Placebo
                             27    Baseline                II           1     Placebo
                             28    Baseline                II           1     Placebo
                             29    Week 12 LOCF      II           1     Placebo

I type:

proc summary data=new nway;

class treat classy visit;

var pop;

output out=newsum(drop=_:);

run;

and I obtain:

Obs TREAt class VISit pop

                                    1    Placebo        I        Week 12 LOCF              1
                                    2    Placebo        I        Week 12 LOCF              1
                                    3    Placebo        I        Week 12 LOCF              1
                                    4    Placebo        I        Week 12 LOCF              1
                                    5    Placebo        I        Week 12 LOCF              .
                                    6    Placebo        II       Baseline                 26
                                    7    Placebo        II       Baseline                  1
                                    8    Placebo        II       Baseline                  1
                                    9    Placebo        II       Baseline                  1
                                   10    Placebo        II       Baseline                  0
                                   11    Placebo        II       Week 12 LOCF              1
                                   12    Placebo        II       Week 12 LOCF              1
                                   13    Placebo        II       Week 12 LOCF              1
                                   14    Placebo        II       Week 12 LOCF              1
                                   15    Placebo        II       Week 12 LOCF              .

I was expecting the real summary and as well the missing value, and it is not...what I am doing wrong here ?

Thanks in advance.

Re: proc summary nway help

michtka — Fri, 13 Apr 2012 15:09:42 GMT

I got it

proc summary data=new nway missing;

class treattxt eff_rslt visder;

var itt;

output out=newsum(drop=_:) n=n;

run;

Re: proc summary nway help

ballardw — Fri, 13 Apr 2012 15:11:04 GMT

If you want missing to be treated as a valid level of you class variable add the MISSING option to the class statement.

Class treat classy visit / missing;

You didn't request any summary functions for the variable. Request the statistics on the output statement.

output out=newsum(drop=_:) sum= ; if you only want sum if you want more statistics you'll need to provide output variable names for each statistic, syntax is

statistic-keyword<(variable-list)>=<name(s)>

or use the auto name option

output out=newsum(drop=_:) sum std /autoname;

Re: proc summary nway help

Linlin — Fri, 13 Apr 2012 15:12:09 GMT

try adding sum=

proc summary data=new nway;

class treat classy visit;

var pop;

output out=newsum(drop=_:) sum=;

run;

Linlin

Re: proc summary nway help

michtka — Fri, 13 Apr 2012 15:21:26 GMT

I did it adding missing as an option of proc summary...I think will be the same.

Re: proc summary nway help

michtka — Fri, 13 Apr 2012 15:21:56 GMT

thnaks, I did with n

topic Re: proc summary nway help in SAS Procedures

proc summary nway help

Re: proc summary nway help

Re: proc summary nway help

Re: proc summary nway help

Re: proc summary nway help

Re: proc summary nway help