Assign category to max age below 24Months

bharath86 — Thu, 12 Nov 2020 22:03:07 GMT

Hi, I want to assign category to the ID 1234 if age < =24. In the below example I have 3 rows in this ID which satisfies the condition.

But I want the category to be assigned to the max age (only) available below 24 months, In this case it is 12 months.

Condition for version is either 0 or 1.

Can't figure out how to get this done. Please advise.

ID	Age in months	Version	Category
1234	0.032854209	0	Severe
1234	2	0	Severe
1234	12	0	Severe

Thank you

Re: Assign category to max age below 24Months

Kurt_Bremser — Fri, 13 Nov 2020 06:59:15 GMT

I'd use a double DO loop:

proc sort data=have;
by id age;
run;

data want;
do until (last.id);
  set have;
  by id;
  if age le 24 then maxage = max(maxage,age);
end;
do until (last.id);
  set have;
  by id;
  category = (maxage = age);
  output;
end;
drop maxage;
run;

topic Assign category to max age below 24Months in Statistical Procedures

Assign category to max age below 24Months

Re: Assign category to max age below 24Months