BookmarkSubscribeRSS Feed
robertrao
Quartz | Level 8


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

4 REPLIES 4
AncaTilea
Pyrite | Level 9

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

Thanks.

Oleg_L
Obsidian | Level 7

Add MISSING option.

Proc summary data=have missing;

class ...

robertrao
Quartz | Level 8

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

Oleg_L
Obsidian | Level 7

That is right.

Oleg.

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1578 views
  • 3 likes
  • 3 in conversation