BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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!
2 REPLIES 2
SSN_Ravi
Calcite | Level 5
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
Not applicable
That works! Thanks very much!!!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 2 replies
  • 851 views
  • 0 likes
  • 2 in conversation