Repeated measure to be sorted by three variable and select minimum by a variable

desireatem — Wed, 11 Apr 2018 18:02:25 GMT

Hello,

I have this data that I want to sort by SID New_dt and NIPR.

For each subject I want just the minimum NPIR for that day. I also want to delete all observations with missing NPIR

For example this data should be reduced to Data A below:

Should be reduced TO Data A :

Re: Repeated measure to be sorted by three variable and select minimum by a variable

Astounding — Wed, 11 Apr 2018 18:20:04 GMT

A one-step way:

proc summary data=have nway;

where npir > .;

class sid new_dt;

var npir;

output out=want (drop=_type_ _freq_) min=;

run;

If your actual data set contains additional variables, it becomes more problematic and we'd have to examine some of the details within the data.