Deleting observations based on date

[aperansi]

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. 

Can someone help me create an if statement that will delete any observations that come after the 15th of every month?

[novinosrin · Accepted solution]

without sample, I am guessing

if day(date)>15 then delete;

[aperansi]

so the variable in question is called est_date, so would I replace the "date" you have in the parentheses with est_date?

[novinosrin]

yes that's correct

[aperansi]

thank you so much for your help!

[novinosrin]

You are welcome. Thank you for your questions and participation on the community