solution data bank; input @1 trans_dt date9. @13trans_amt comma7.; format trans_dt date9. trans_amt comma8.; datalines; 01jan2017 89,000 02feb2017 75,000 03mar2017 96,000 04apr2017 65,000 05may2017 10,000 06jun2017 25,000 07jul2017 36,000 08aug2017 32,000 09sep2017 46,000 10oct2017 50,000 11nov2017 31,000 ; run; data trans; set bank; where trans_dt >= '01Jan2017'd and trans_dt<= '01apr2017'd ; run; proc sql; create table trans2 as select * from bank where trans_dt between '01Jan2017'd and '31mar2017'd ; quit;
... View more