https://communities.sas.com/t5/SAS-Programming/How-to-compare-date-1-and-date2-existing-and-get-the-difference/m-p/718298#M222272 <P>What is the logic which says use DATE2 = 08/02/2019 instead of DATE2 = 10/03/2019 on some rows, and use DATE2 = 10/03/2019 instead of DATE2 = 08/02/2019 on other rows??</P> Wed, 10 Feb 2021 17:26:31 GMT PaigeMiller 2021-02-10T17:26:31Z https://communities.sas.com/t5/SAS-Programming/How-to-compare-date-1-and-date2-existing-and-get-the-difference/m-p/718295#M222270 <P>Hi ,</P> <P>&nbsp;</P> <P>I have the following data.I need to compare date1 with date2(with the existing one) and get the period in days .</P> <P>&nbsp;</P> <P>subj&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; date1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; date2&nbsp;&nbsp;</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; 07/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; 08/02/2019&nbsp; &nbsp;08/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp;09/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; 11/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; 14/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; 18/02/2019</P> <P>1&nbsp; &nbsp; &nbsp; 25/02/2019</P> <P>1&nbsp; &nbsp; &nbsp;03/03/2019</P> <P>1&nbsp; &nbsp; &nbsp;04/03/2019</P> <P>1&nbsp; &nbsp; &nbsp; 06/03/2019</P> <P>1&nbsp; &nbsp; &nbsp;07/03/2019</P> <P>1&nbsp; &nbsp; &nbsp;08/03/2019</P> <P>1&nbsp; &nbsp; &nbsp;09/03/2019</P> <P>1&nbsp; &nbsp; 10/03/2020&nbsp; &nbsp;10/03/2020</P> <P>1&nbsp; &nbsp; &nbsp;11/03/2020</P> <P>1&nbsp; &nbsp; &nbsp;13/03/2020</P> <P>1&nbsp; &nbsp; &nbsp;15/03/2020</P> <P>1&nbsp; &nbsp; &nbsp; 17/03/2020</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>I need as</P> <P>&nbsp;</P> <P>subj&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; date1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; date2&nbsp; &nbsp; &nbsp; days</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-5</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -4</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-3&nbsp;</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-2</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; 07/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; 08/02/2019&nbsp; &nbsp;08/02/2019&nbsp; &nbsp; &nbsp; &nbsp; 0</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp;09/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> <P>1&nbsp; &nbsp; &nbsp; 11/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P> <P>1&nbsp; &nbsp; &nbsp; 14/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P> <P>1&nbsp; &nbsp; &nbsp; 18/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7</P> <P>1&nbsp; &nbsp; &nbsp;03/03/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-7</P> <P>1&nbsp; &nbsp; &nbsp;04/03/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -6</P> <P>1&nbsp; &nbsp; &nbsp; 06/03/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-4</P> <P>1&nbsp; &nbsp; &nbsp;07/03/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -3</P> <P>1&nbsp; &nbsp; &nbsp;08/03/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -2</P> <P>1&nbsp; &nbsp; &nbsp;09/03/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>1&nbsp; &nbsp; 10/03/2020&nbsp; &nbsp;10/03/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P> <P>1&nbsp; &nbsp; &nbsp;11/03/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> <P>1&nbsp; &nbsp; &nbsp;13/03/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P> <P>1&nbsp; &nbsp; &nbsp;15/03/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P> <P>1&nbsp; &nbsp; &nbsp; 17/03/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7</P> <P>&nbsp;</P> <P>Appreciate your help.Thanks</P> <P>&nbsp;</P> Wed, 10 Feb 2021 16:25:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-compare-date-1-and-date2-existing-and-get-the-difference/m-p/718295#M222270 sri1 2021-02-10T16:25:04Z https://communities.sas.com/t5/SAS-Programming/How-to-compare-date-1-and-date2-existing-and-get-the-difference/m-p/718298#M222272 <P>What is the logic which says use DATE2 = 08/02/2019 instead of DATE2 = 10/03/2019 on some rows, and use DATE2 = 10/03/2019 instead of DATE2 = 08/02/2019 on other rows??</P> Wed, 10 Feb 2021 17:26:31 GMT https://communities.sas.com/t5/SAS-Programming/How-to-compare-date-1-and-date2-existing-and-get-the-difference/m-p/718298#M222272 PaigeMiller 2021-02-10T17:26:31Z