topic Re: Derive the last date of a data column in SAS Programming https://communities.sas.com/t5/SAS-Programming/Derive-a-date-s-last-day-of-month/m-p/708385#M217698 <PRE><CODE class=" language-sas">DATE2=intnx('month',DATE,0,'e');</CODE></PRE> <P>Post title corrected it is meaningless as written.</P> Mon, 28 Dec 2020 06:10:49 GMT ChrisNZ 2020-12-28T06:10:49Z Derive a date's last day of month https://communities.sas.com/t5/SAS-Programming/Derive-a-date-s-last-day-of-month/m-p/708383#M217697 <P>I have a date column like this -</P> <P>&nbsp;</P> <P>Joining Date</P> <P>03/01/2020</P> <P>24/09/2020</P> <P>25/07/2019&nbsp;</P> <P>&nbsp;</P> <P>I want to derive the last date for the whole column like this -&nbsp;</P> <P>&nbsp;</P> <P>31/01/2020</P> <P>30/09/2020</P> <P>31/07/2019&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 28 Dec 2020 06:12:09 GMT https://communities.sas.com/t5/SAS-Programming/Derive-a-date-s-last-day-of-month/m-p/708383#M217697 Saurabh_Rana 2020-12-28T06:12:09Z Re: Derive the last date of a data column https://communities.sas.com/t5/SAS-Programming/Derive-a-date-s-last-day-of-month/m-p/708385#M217698 <PRE><CODE class=" language-sas">DATE2=intnx('month',DATE,0,'e');</CODE></PRE> <P>Post title corrected it is meaningless as written.</P> Mon, 28 Dec 2020 06:10:49 GMT https://communities.sas.com/t5/SAS-Programming/Derive-a-date-s-last-day-of-month/m-p/708385#M217698 ChrisNZ 2020-12-28T06:10:49Z