topic how to efficiently program and get the earliest date in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687328#M208639 <P>Hi,</P><P>&nbsp;</P><P>I have 5 variables with dates (RFENDTC0-RFENDTC33), and i need to derive a variable, "RFENDTC", that contains the earliest date out of the 5 variables. How would I efficiently program this?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HitmonTran_0-1601322695326.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/49908i0BE19845DBF986A5/image-size/medium?v=v2&amp;px=400" role="button" title="HitmonTran_0-1601322695326.png" alt="HitmonTran_0-1601322695326.png" /></span></P><P>&nbsp;</P> Mon, 28 Sep 2020 19:51:57 GMT HitmonTran 2020-09-28T19:51:57Z how to efficiently program and get the earliest date https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687328#M208639 <P>Hi,</P><P>&nbsp;</P><P>I have 5 variables with dates (RFENDTC0-RFENDTC33), and i need to derive a variable, "RFENDTC", that contains the earliest date out of the 5 variables. How would I efficiently program this?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HitmonTran_0-1601322695326.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/49908i0BE19845DBF986A5/image-size/medium?v=v2&amp;px=400" role="button" title="HitmonTran_0-1601322695326.png" alt="HitmonTran_0-1601322695326.png" /></span></P><P>&nbsp;</P> Mon, 28 Sep 2020 19:51:57 GMT https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687328#M208639 HitmonTran 2020-09-28T19:51:57Z Re: how to efficiently program and get the earliest date https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687330#M208640 rfendtc = min(of rfendtc0-frendtc33); Mon, 28 Sep 2020 20:00:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687330#M208640 Reeza 2020-09-28T20:00:51Z Re: how to efficiently program and get the earliest date https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687332#M208641 thanks!<BR /> Mon, 28 Sep 2020 20:05:18 GMT https://communities.sas.com/t5/SAS-Programming/how-to-efficiently-program-and-get-the-earliest-date/m-p/687332#M208641 HitmonTran 2020-09-28T20:05:18Z