https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537447#M6769 <P>thank you so much for your help!</P> Thu, 21 Feb 2019 16:27:03 GMT aperansi 2019-02-21T16:27:03Z https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537422#M6764 <P>I have a data set that I run every month with data from the 1st through the 30/31st, but I would like to delete observations that come after the 15th of that month.&nbsp;</P><P>&nbsp;</P><P>Can someone help me create an if statement that will delete any observations that come after the 15th of every month?</P> Thu, 21 Feb 2019 15:11:09 GMT https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537422#M6764 aperansi 2019-02-21T15:11:09Z https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537423#M6765 <P>without sample, I am guessing</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">if day(date)&gt;15 then delete;</CODE></PRE> Thu, 21 Feb 2019 15:13:52 GMT https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537423#M6765 novinosrin 2019-02-21T15:13:52Z https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537428#M6766 so the variable in question is called est_date, so would I replace the "date" you have in the parentheses with est_date? Thu, 21 Feb 2019 15:24:08 GMT https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537428#M6766 aperansi 2019-02-21T15:24:08Z https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537429#M6767 <P>yes that's correct</P> Thu, 21 Feb 2019 15:24:37 GMT https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537429#M6767 novinosrin 2019-02-21T15:24:37Z https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537447#M6769 <P>thank you so much for your help!</P> Thu, 21 Feb 2019 16:27:03 GMT https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537447#M6769 aperansi 2019-02-21T16:27:03Z https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537448#M6770 <P>You are welcome. Thank you for your questions and participation on the community</P> Thu, 21 Feb 2019 16:30:04 GMT https://communities.sas.com/t5/New-SAS-User/Deleting-observations-based-on-date/m-p/537448#M6770 novinosrin 2019-02-21T16:30:04Z