Could you please help me on the below query where i m trying to retreive data for past 1 month from current date. query used: proc sql noprint; create table test1 as Select distinct quote_number(alphnumeric), effective, TRANSACTIONDATE from Libname.table where datepart (TRANSACTIONDATE) < intnx('month',today(),-1) and quotenumber like 'Q%' order by transactiondate desc; Quit; sample result set of the data retrieved: QCAH3107000623 27OCT2018:00:00:00.000000 24OCT2018:21:39:25.228000 Actually i need past 6-month's data but first trying out to get with 1 month and to apply it for 6 months This gives me result of 22 million. Kindly help!
... View more
