topic Re: Selecting MAX VALUE by visit number in SAS Health and Life Sciences

Selecting MAX VALUE by visit number

deleted_user — Wed, 18 Apr 2007 15:46:01 GMT

I have the following data:

id visit# score
1 00 5
1 02 7
1 04 3
2 00 2
2 02 1
2 04 8

How do I get the variable "maxscore" to display the maximum score up until that visit, looking at also previous ones? It should look something like this:

id visit# score maxscore
1 00 5 5
1 02 7 7
1 04 3 7
2 00 2 2
2 02 1 2
2 04 8 8

What is the SAS code that I need to get the table above?
Thank you very much!

Re: Selecting MAX VALUE by visit number

SSN_Ravi — Thu, 19 Apr 2007 10:05:08 GMT

Just try the following code, I hope it will work for u.

data b;
set a;
retain score1 maxsc;
by id;
if first.id then score1=0;
maxsc=max(score,score1);
score1=maxsc;
run;

regards,
S.S.N.Ravi.

Re: Selecting MAX VALUE by visit number

deleted_user — Thu, 19 Apr 2007 15:06:46 GMT

That works! Thanks very much!!!