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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.