Selecting MAX VALUE by visit number

Reply
N/A
Posts: 0

Selecting MAX VALUE by visit number

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!
Contributor
Posts: 21

Re: Selecting MAX VALUE by visit number

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.
N/A
Posts: 0

Re: Selecting MAX VALUE by visit number

That works! Thanks very much!!!
Ask a Question
Discussion stats
  • 2 replies
  • 334 views
  • 0 likes
  • 2 in conversation