PROC SQL: Delete rows in which two date fields differ by more than 250 days
Hi all, I;m not familiar with PROC SQL (I think its similar to MS SQL)
I am running a statistics program called SAS and am trying to delete certain rows in a database. The fields 'Date_Announced' and 'Date' are the ones I am concerned with. I'm trying to subtract the two coloumns and then delete the rows for which the result is >250 . The sheet is called Asx.mergernew.
Can someone help me with the exact command to type into my command window?
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!