topic Re: Maximum value of a numeric variable sorted by patients in SAS Programming

Maximum value of a numeric variable sorted by patients

Gothardt — Fri, 25 Mar 2016 12:11:31 GMT

Hi,

I have a dataset sorted by patients; e.g. 2 observations/lines (of data) for patient 1, 4 lines for patient 2 and so on. I have a variable (we call it "LINES") counting the lines for each patient (1, 2, 3, 4 and so on).

I need to create a new variable with data from the the last line for each patient, in other words the highest value of the variable "LINES" (sorted by patients).

How do I create a syntax with "highest value" (it should bed sorted by patients already) of a variable?

/Mette

Re: Maximum value of a numeric variable sorted by patients

Loko — Fri, 25 Mar 2016 12:21:05 GMT

Hello,

Instead of describing in words your situation it will be useful to post an example of your data.

It is easier to look at data you have - data you want than reading a description.

Re: Maximum value of a numeric variable sorted by patients

Kurt_Bremser — Fri, 25 Mar 2016 12:35:15 GMT

proc sort data=have;
by patient lines;
run;

data want;
set have;
by patient;
if last.patient;
run;

Re: Maximum value of a numeric variable sorted by patients

Gothardt — Thu, 31 Mar 2016 07:16:24 GMT

Thanks a lot KurtBremser. It was exactly the commando I needed. 🙂