topic Re: Need help to derive LATEST date (MHENTPT) between two date variables in SAS Programming https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842056#M332952 Input variables are in character format and desired also should be either date 1 or date2 variable only whichever is latest. If date1 is 14APR2008 and date2 is 29OCT2022, desired result should be 29OCT2022 WHICH IS latest date. Hope u understand Wed, 02 Nov 2022 11:34:54 GMT kumar19 2022-11-02T11:34:54Z Need help to derive LATEST date (MHENTPT) between two date variables https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842053#M332949 <P>Hi Everyone.&nbsp;</P><P>I have a query.&nbsp;</P><P>I am deriving MHENTPT in MH domain. as per spec, it should be whichever is latest date between DSSTDAT and SFDAT.&nbsp;</P><P>please help me with syntax on how to dervie it&nbsp;</P> Wed, 02 Nov 2022 11:15:08 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842053#M332949 kumar19 2022-11-02T11:15:08Z Re: Need help to derive LATEST date (MHENTPT) between two date variables https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842054#M332950 <P>You have to be more specific. What does your data look like? What does your desired result look like?</P> Wed, 02 Nov 2022 11:27:32 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842054#M332950 PeterClemmensen 2022-11-02T11:27:32Z Re: Need help to derive LATEST date (MHENTPT) between two date variables https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842056#M332952 Input variables are in character format and desired also should be either date 1 or date2 variable only whichever is latest. If date1 is 14APR2008 and date2 is 29OCT2022, desired result should be 29OCT2022 WHICH IS latest date. Hope u understand Wed, 02 Nov 2022 11:34:54 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842056#M332952 kumar19 2022-11-02T11:34:54Z Re: Need help to derive LATEST date (MHENTPT) between two date variables https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842060#M332955 <LI-SPOILER>&nbsp;</LI-SPOILER><P><SPAN>Input variables are in character format and desired also should be either date 1 or date2 variable only whichever is latest. If date1 is 14APR2008 and date2 is 29OCT2022, desired result should be 29OCT2022 WHICH IS latest date. Hope u understand</SPAN></P> Wed, 02 Nov 2022 11:53:06 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-to-derive-LATEST-date-MHENTPT-between-two-date/m-p/842060#M332955 kumar19 2022-11-02T11:53:06Z