topic How to select the max value from a range of measurements over time in SAS Data Management

topic How to select the max value from a range of measurements over time in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326895#M9521 <P> </P><P class="p1"><SPAN class="s1">I have a dataset where four scores were measured over time (R_score, M_score, S_score, and P_score). I have successfully matched these measurements to the time periods during which the subjects (e.g. STUDYID 0001 and 0002) were in a particular environment (SCHOOL vs. HOME). When I say "time period",</SPAN> this refers to a period of time marked by the same dates and environment. In this case, the first subject 0001 has multiple (14) observations/measurements taken in the SCHOOL environment during the time period <SPAN>02/06/2008-03/12/2010</SPAN>, followed by a period of time (<SPAN>03/13/2010-01/01/2015) </SPAN>in the HOME environment during which no measurements were taken and thus the R_score, M_score, S_score, and P_score variables are all missing (which is still useful data to retain for my purposes). <SPAN class="s1">Sample data is below:</SPAN></P><P class="p1"> </P><P class="p1"><SPAN class="s1"><STRONG>data</STRONG></SPAN> tempfile;</P><P class="p2">infile<SPAN class="s2"> datalines </SPAN>truncover<SPAN class="s2">;</SPAN></P><P class="p2">INPUT</P><P class="p1">environment$ studyID<SPAN class="s3">$4.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> StartDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> EndDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN></P><P class="p1">daysbwn Movementcode Movecode short_inc count</P><P class="p1">ScoreDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> R_Score M_Score S_Score P_Score;</P><P class="p1"><SPAN class="s4">format</SPAN> Startdate EndDate ScoreDate <SPAN class="s3">yymmdd10.</SPAN>;</P><P class="p2">datalines<SPAN class="s2">;</SPAN></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/06/2008 1 3 3 1</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/08/2008 1 3 3 1<SPAN class="Apple-converted-space">   </SPAN></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/12/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 03/17/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 05/21/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/06/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/26/2009 1 3 3 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/29/2009 1 3 3 2</P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/27/2009 1 3 3 2</FONT></P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/28/2009 1 4 4 3</FONT></P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/26/2009 1 5 4 2</FONT></P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 09/16/2009 1 4 5 2</FONT></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 12/14/2009 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/27/2010 1 4 4 2</P><P class="p1">HOME 0001 03/13/2010 01/01/2015 1755 3 2 0 3 . . . . .</P><P class="p1">HOME 0002 01/01/2007 07/31/2007 211 . . 0 1 . . . . .</P><P class="p1">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 . . . . .</P><P class="p1">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 08/01/2007 2 3 3 2</P><P class="p1">HOME 0002 08/29/2007 02/20/2008 175 3 2 0 3 . . . . .</P><P class="p1">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 . . . . .</P><P class="p1">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 02/21/2008 2 2 2 1</P><P class="p1">HOME 0002 03/06/2008 01/01/2015 2492 3 2 0 5 . . . . .</P><P class="p1">;</P><P class="p3"><STRONG>run</STRONG><SPAN class="s2">;</SPAN></P><P class="p1"><SPAN class="s1"><STRONG>proc</STRONG></SPAN> <SPAN class="s1"><STRONG>print</STRONG></SPAN> <SPAN class="s4">data</SPAN>=tempfile; <SPAN class="s1"><STRONG>run</STRONG></SPAN>;</P><P class="p1"> </P><P class="p1">Now I would like to select out the highest value seen for each of the four different score variables during each time period. For example (using red text to indicate the measurements of interest):</P><P class="p1"> </P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/06/2008 1 3 3 1</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/08/2008 1 3 3 1<SPAN class="Apple-converted-space">   </SPAN></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/12/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 03/17/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 05/21/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/06/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/26/2009 1 3 3 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/29/2009 1 3 3 2</P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/27/2009 1</FONT> 3 3 2</P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/28/2009</FONT> 1 4 4 <FONT color="#FF0000">3</FONT></P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/26/2009 <FONT color="#000000">1</FONT> 5 <FONT color="#000000">4 2</FONT></FONT></P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 09/16/2009</FONT> 1 4 <FONT color="#FF0000">5</FONT> 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 12/14/2009 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/27/2010 1 4 4 2</P><P class="p1"><FONT color="#FF0000">HOME 0001 03/13/2010 01/01/2015 1755 3 2 0 3 . . . . .</FONT></P><P class="p1"><FONT color="#FF0000">HOME 0002 01/01/2007 07/31/2007 211 . . 0 1 . . . . .</FONT></P><P class="p1">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 . . . . .</P><P class="p1"><FONT color="#FF0000">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 08/01/2007 2 3 3 2</FONT></P><P class="p1"><FONT color="#FF0000">HOME 0002 08/29/2007 02/20/2008 175 3 2 0 3 . . . . .</FONT></P><P class="p1">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 . . . . .</P><P class="p1"><FONT color="#FF0000">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 02/21/2008 2 2 2 1</FONT></P><P class="p1"><FONT color="#FF0000">HOME 0002 03/06/2008 01/01/2015 2492 3 2 0 5 . . . . .</FONT></P><P class="p1"> </P><P class="p1"><FONT color="#000000">If only a single row of measurements or only missing values are available, they should be the values chosen and kept in the dataset. If multiple rows of data are available, then the highest value available for each of the score variables should be chosen to produce something that looks like this (the ScoreDate can be dropped):</FONT></P><P class="p1"> </P><P class="p1">environment$ studyID<SPAN class="s3">$4.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> StartDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> EndDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1 </STRONG></SPAN>daysbwn Movementcode Movecode short_inc count R_Score M_Score S_Score P_Score</P><P class="p1"> </P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2</FONT> 1 <SPAN>5 5</SPAN> 3</FONT></P><P class="p1"><SPAN>HOME</SPAN><SPAN> 0001 03/13/2010 01/01/2015 1755 3 2 0 3 <FONT color="#FF0000">. . . .</FONT></SPAN></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">HOME 0002 01/01/2007 07/31/2007 211 . . 0 1</FONT> . . . .</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2</FONT> 2 3 3 2</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">HOME 0002 08/29/2007 02/20/2008 175 3 2 0 3</FONT> . . . .</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4</FONT> 2 2 2 1</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">HOME 0002 03/06/2008 01/01/2015 2492 3 2 0 5</FONT> . . . .</FONT></P><P class="p1"> </P><P class="p1"><FONT color="#000000">Any help to do this properly would be very much appreciated! Thank you in advance.</FONT></P> Tue, 24 Jan 2017 21:08:18 GMT Kels123 2017-01-24T21:08:18Z How to select the max value from a range of measurements over time https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326895#M9521 <P> </P><P class="p1"><SPAN class="s1">I have a dataset where four scores were measured over time (R_score, M_score, S_score, and P_score). I have successfully matched these measurements to the time periods during which the subjects (e.g. STUDYID 0001 and 0002) were in a particular environment (SCHOOL vs. HOME). When I say "time period",</SPAN> this refers to a period of time marked by the same dates and environment. In this case, the first subject 0001 has multiple (14) observations/measurements taken in the SCHOOL environment during the time period <SPAN>02/06/2008-03/12/2010</SPAN>, followed by a period of time (<SPAN>03/13/2010-01/01/2015) </SPAN>in the HOME environment during which no measurements were taken and thus the R_score, M_score, S_score, and P_score variables are all missing (which is still useful data to retain for my purposes). <SPAN class="s1">Sample data is below:</SPAN></P><P class="p1"> </P><P class="p1"><SPAN class="s1"><STRONG>data</STRONG></SPAN> tempfile;</P><P class="p2">infile<SPAN class="s2"> datalines </SPAN>truncover<SPAN class="s2">;</SPAN></P><P class="p2">INPUT</P><P class="p1">environment$ studyID<SPAN class="s3">$4.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> StartDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> EndDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN></P><P class="p1">daysbwn Movementcode Movecode short_inc count</P><P class="p1">ScoreDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> R_Score M_Score S_Score P_Score;</P><P class="p1"><SPAN class="s4">format</SPAN> Startdate EndDate ScoreDate <SPAN class="s3">yymmdd10.</SPAN>;</P><P class="p2">datalines<SPAN class="s2">;</SPAN></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/06/2008 1 3 3 1</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/08/2008 1 3 3 1<SPAN class="Apple-converted-space">   </SPAN></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/12/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 03/17/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 05/21/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/06/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/26/2009 1 3 3 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/29/2009 1 3 3 2</P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/27/2009 1 3 3 2</FONT></P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/28/2009 1 4 4 3</FONT></P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/26/2009 1 5 4 2</FONT></P><P class="p1"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 09/16/2009 1 4 5 2</FONT></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 12/14/2009 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/27/2010 1 4 4 2</P><P class="p1">HOME 0001 03/13/2010 01/01/2015 1755 3 2 0 3 . . . . .</P><P class="p1">HOME 0002 01/01/2007 07/31/2007 211 . . 0 1 . . . . .</P><P class="p1">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 . . . . .</P><P class="p1">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 08/01/2007 2 3 3 2</P><P class="p1">HOME 0002 08/29/2007 02/20/2008 175 3 2 0 3 . . . . .</P><P class="p1">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 . . . . .</P><P class="p1">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 02/21/2008 2 2 2 1</P><P class="p1">HOME 0002 03/06/2008 01/01/2015 2492 3 2 0 5 . . . . .</P><P class="p1">;</P><P class="p3"><STRONG>run</STRONG><SPAN class="s2">;</SPAN></P><P class="p1"><SPAN class="s1"><STRONG>proc</STRONG></SPAN> <SPAN class="s1"><STRONG>print</STRONG></SPAN> <SPAN class="s4">data</SPAN>=tempfile; <SPAN class="s1"><STRONG>run</STRONG></SPAN>;</P><P class="p1"> </P><P class="p1">Now I would like to select out the highest value seen for each of the four different score variables during each time period. For example (using red text to indicate the measurements of interest):</P><P class="p1"> </P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/06/2008 1 3 3 1</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/08/2008 1 3 3 1<SPAN class="Apple-converted-space">   </SPAN></P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 02/12/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 03/17/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 05/21/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/06/2008 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/26/2009 1 3 3 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/29/2009 1 3 3 2</P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/27/2009 1</FONT> 3 3 2</P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 07/28/2009</FONT> 1 4 4 <FONT color="#FF0000">3</FONT></P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 08/26/2009 <FONT color="#000000">1</FONT> 5 <FONT color="#000000">4 2</FONT></FONT></P><P class="p1"><FONT color="#FF0000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 09/16/2009</FONT> 1 4 <FONT color="#FF0000">5</FONT> 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 12/14/2009 1 4 4 2</P><P class="p1">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2 01/27/2010 1 4 4 2</P><P class="p1"><FONT color="#FF0000">HOME 0001 03/13/2010 01/01/2015 1755 3 2 0 3 . . . . .</FONT></P><P class="p1"><FONT color="#FF0000">HOME 0002 01/01/2007 07/31/2007 211 . . 0 1 . . . . .</FONT></P><P class="p1">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 . . . . .</P><P class="p1"><FONT color="#FF0000">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2 08/01/2007 2 3 3 2</FONT></P><P class="p1"><FONT color="#FF0000">HOME 0002 08/29/2007 02/20/2008 175 3 2 0 3 . . . . .</FONT></P><P class="p1">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 . . . . .</P><P class="p1"><FONT color="#FF0000">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4 02/21/2008 2 2 2 1</FONT></P><P class="p1"><FONT color="#FF0000">HOME 0002 03/06/2008 01/01/2015 2492 3 2 0 5 . . . . .</FONT></P><P class="p1"> </P><P class="p1"><FONT color="#000000">If only a single row of measurements or only missing values are available, they should be the values chosen and kept in the dataset. If multiple rows of data are available, then the highest value available for each of the score variables should be chosen to produce something that looks like this (the ScoreDate can be dropped):</FONT></P><P class="p1"> </P><P class="p1">environment$ studyID<SPAN class="s3">$4.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> StartDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1</STRONG></SPAN> EndDate <SPAN class="s3">mmddyy10.</SPAN>@+<SPAN class="s3"><STRONG>1 </STRONG></SPAN>daysbwn Movementcode Movecode short_inc count R_Score M_Score S_Score P_Score</P><P class="p1"> </P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">SCHOOL 0001 02/06/2008 03/12/2010 765 1 1 0 2</FONT> 1 <SPAN>5 5</SPAN> 3</FONT></P><P class="p1"><SPAN>HOME</SPAN><SPAN> 0001 03/13/2010 01/01/2015 1755 3 2 0 3 <FONT color="#FF0000">. . . .</FONT></SPAN></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">HOME 0002 01/01/2007 07/31/2007 211 . . 0 1</FONT> . . . .</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">SCHOOL 0002 08/01/2007 08/28/2007 27 1 1 1 2</FONT> 2 3 3 2</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">HOME 0002 08/29/2007 02/20/2008 175 3 2 0 3</FONT> . . . .</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">SCHOOL 0002 02/21/2008 03/05/2008 13 1 1 1 4</FONT> 2 2 2 1</FONT></P><P class="p1"><FONT color="#FF0000"><FONT color="#000000">HOME 0002 03/06/2008 01/01/2015 2492 3 2 0 5</FONT> . . . .</FONT></P><P class="p1"> </P><P class="p1"><FONT color="#000000">Any help to do this properly would be very much appreciated! Thank you in advance.</FONT></P> Tue, 24 Jan 2017 21:08:18 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326895#M9521 Kels123 2017-01-24T21:08:18Z Re: How to select the max value from a range of measurements over time https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326896#M9522 <P>"Each time period" means what exactly?</P> Mon, 23 Jan 2017 23:50:12 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326896#M9522 ballardw 2017-01-23T23:50:12Z Re: How to select the max value from a range of measurements over time https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326911#M9523 <P>I just corrected an error and added an additional explanation to my original post in response to your post. Please let me know if you still have questions. Thank you.</P> Tue, 24 Jan 2017 02:07:05 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326911#M9523 Kels123 2017-01-24T02:07:05Z Re: How to select the max value from a range of measurements over time https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326912#M9524 <PRE><CODE class=" language-sas">This does not solve the problem but may get you on the right path proc summary data=tempfile max nway; class environment studyID StartDate; id environment studyID StartDate; var R_Score M_Score S_Score P_Score; output out=max(drop=_type_ _freq_) max=; run;quit; proc print data=max; run; Obs ENVIRONMENT STUDYID STARTDATE R_SCORE M_SCORE S_SCORE P_SCORE 1 HOME 0002 2007-01-01 . . . . 2 HOME 0002 2007-08-29 . . . . 3 HOME 0002 2008-03-06 . . . . 4 SCHOOL 0001 2008-02-06 1 5 5 2 5 SCHOOL 0001 2010-03-13 . . . . 6 SCHOOL 0002 2007-08-01 2 3 3 2 7 SCHOOL 0002 2008-02-21 2 2 2 1 You can match back using the compound key plus each max score, or you can just repeat the key with each max score.</CODE></PRE> Tue, 24 Jan 2017 02:07:30 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-select-the-max-value-from-a-range-of-measurements-over/m-p/326912#M9524 rogerjdeangelis 2017-01-24T02:07:30Z