https://communities.sas.com/t5/ODS-and-Base-Reporting/extract-quarterly-data/m-p/19071#M3693 allow SAS to derive the start date for "last-quarter"<BR /> <BR /> Something like [pre] %let qtr_start = %sysfunc( intnx( qtr, "&amp;sysdate"d, 0 ), date9 );<BR /> ...<BR /> where transaction_date GE "&amp;qtr_start"d [/pre]<BR /> but that depends on using a suitable format for the quarter date.<BR /> With "implicit-pass-thru" the SAS engine will do any reformatting from DATE9 to the style for your dbms. If you are using 'explicit-pass-thru' you need to prepare the proper format<BR /> <BR /> good luck<BR /> <BR /> PeterC Tue, 27 May 2008 07:56:12 GMT deleted_user 2008-05-27T07:56:12Z https://communities.sas.com/t5/ODS-and-Base-Reporting/extract-quarterly-data/m-p/19070#M3692 would appreciate if anybody could give me logic to pull data for the last quarter from the database. right now to pull for 1 month I am using<BR /> sysdate(add_months('mmyyyy'-1) some thing on these lines. Tue, 20 May 2008 15:25:44 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/extract-quarterly-data/m-p/19070#M3692 deleted_user 2008-05-20T15:25:44Z https://communities.sas.com/t5/ODS-and-Base-Reporting/extract-quarterly-data/m-p/19071#M3693 allow SAS to derive the start date for "last-quarter"<BR /> <BR /> Something like [pre] %let qtr_start = %sysfunc( intnx( qtr, "&amp;sysdate"d, 0 ), date9 );<BR /> ...<BR /> where transaction_date GE "&amp;qtr_start"d [/pre]<BR /> but that depends on using a suitable format for the quarter date.<BR /> With "implicit-pass-thru" the SAS engine will do any reformatting from DATE9 to the style for your dbms. If you are using 'explicit-pass-thru' you need to prepare the proper format<BR /> <BR /> good luck<BR /> <BR /> PeterC Tue, 27 May 2008 07:56:12 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/extract-quarterly-data/m-p/19071#M3693 deleted_user 2008-05-27T07:56:12Z