Help using Base SAS procedures

Proc Summary : Class Stmt

Reply
Super Contributor
Posts: 1,041

Proc Summary : Class Stmt


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

Super Contributor
Posts: 543

Re: Proc Summary : Class Stmt

Posted in reply to robertrao

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

Thanks.

Regular Contributor
Posts: 151

Re: Proc Summary : Class Stmt

Posted in reply to robertrao

Add MISSING option.

Proc summary data=have missing;

class ...

Super Contributor
Posts: 1,041

Re: Proc Summary : Class Stmt

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

Regular Contributor
Posts: 151

Re: Proc Summary : Class Stmt

Posted in reply to robertrao

That is right.

Oleg.

Ask a Question
Discussion stats
  • 4 replies
  • 181 views
  • 3 likes
  • 3 in conversation