Selecting MAX VALUE by visit number

[deleted_user]

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!

[SSN_Ravi]

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.

[deleted_user]

That works! Thanks very much!!!