topic Re: Help with Dates Dilema in New SAS User https://communities.sas.com/t5/New-SAS-User/Help-with-Dates-Dilema/m-p/568445#M11669 <P>Use the COALESCEC function</P> <P><A href="https://documentation.sas.com/?cdcId=pgmmvacdc&amp;cdcVersion=9.4&amp;docsetId=lefunctionsref&amp;docsetTarget=p1g9btrql8d9x6n1iz6yowaqrq1v.htm&amp;locale=en">https://documentation.sas.com/?cdcId=pgmmvacdc&amp;cdcVersion=9.4&amp;docsetId=lefunctionsref&amp;docsetTarget=p1g9btrql8d9x6n1iz6yowaqrq1v.htm&amp;locale=en</A></P> Mon, 24 Jun 2019 18:06:57 GMT PaigeMiller 2019-06-24T18:06:57Z Help with Dates Dilema https://communities.sas.com/t5/New-SAS-User/Help-with-Dates-Dilema/m-p/568443#M11668 <P>Hello,&nbsp; I am having an issue figuring out how to do this on SAS. I have provided a picture below</P><P>&nbsp;</P><P>MC3-1 are different months of completion. I need the latest month of completion which would be MC3 if it has a month, MC2 if MC3 is missing and MC1 if MC3 and MC2 are missing.&nbsp;</P><P>&nbsp;</P><P>What would be the simplest way of doing this?&nbsp;</P><P>&nbsp;</P><P>Thank you.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 225px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30497i5FB802FB08223361/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Mon, 24 Jun 2019 17:58:08 GMT https://communities.sas.com/t5/New-SAS-User/Help-with-Dates-Dilema/m-p/568443#M11668 UMR13 2019-06-24T17:58:08Z Re: Help with Dates Dilema https://communities.sas.com/t5/New-SAS-User/Help-with-Dates-Dilema/m-p/568445#M11669 <P>Use the COALESCEC function</P> <P><A href="https://documentation.sas.com/?cdcId=pgmmvacdc&amp;cdcVersion=9.4&amp;docsetId=lefunctionsref&amp;docsetTarget=p1g9btrql8d9x6n1iz6yowaqrq1v.htm&amp;locale=en">https://documentation.sas.com/?cdcId=pgmmvacdc&amp;cdcVersion=9.4&amp;docsetId=lefunctionsref&amp;docsetTarget=p1g9btrql8d9x6n1iz6yowaqrq1v.htm&amp;locale=en</A></P> Mon, 24 Jun 2019 18:06:57 GMT https://communities.sas.com/t5/New-SAS-User/Help-with-Dates-Dilema/m-p/568445#M11669 PaigeMiller 2019-06-24T18:06:57Z