topic Re: Proc Summary : Class Stmt in SAS Procedures

Proc Summary : Class Stmt

robertrao — Wed, 19 Jun 2013 13:10:18 GMT

Hi,

When I use the Proc Summary with Class statement and if for a particular ID I dont have the corresponding physician!!!!!!

I am not getting any of that the records for that particular ID in the Output dataset??????

Could you please explain???Does SAS work like that or am I doing it wrong?????

proc summary data=have;

class ID name sex physician;

var value;

output out=want

Thanks

Re: Proc Summary : Class Stmt

AncaTilea — Wed, 19 Jun 2013 13:14:05 GMT

Please provide some sample data (take ou the real ID and physicians, but make up some data).

Thanks.

Re: Proc Summary : Class Stmt

Oleg_L — Wed, 19 Jun 2013 13:21:38 GMT

Add MISSING option.

Proc summary data=have missing;

class ...

Re: Proc Summary : Class Stmt

robertrao — Wed, 19 Jun 2013 13:41:45 GMT

Hi I used like this.is that right????

proc summary data=have NWAY MISSING;

class ID name sex physician;

var value;

output out=want

Thanks

Re: Proc Summary : Class Stmt

Oleg_L — Wed, 19 Jun 2013 13:52:58 GMT

That is right.

Oleg.