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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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