I have a data set like Agreementno serialno agreementdate amount intrest ab10005 7456q9 10jan2012:00:00:00 150000 700 cd20006 6783q8 15feb2012:00:00:00 700000 bv40007 7672q5 07mar2011:00:00:00 80000 gu80005 7637q8 09mar2010:00:00:00 90000 900 I have to create a dataset by proc sql which contain colomn like Ageementno,col1,col2,col4,serialno,col5,col6,agreementdate,recciptno,amount,intrestt. below calculation has been done in new dataset recciptno=agreementno+last 2 digit of serialno+first 2 digit of agreement date+amount intrest=if intrest is null then put 400 ,if intrest greater then 700 put 300 col6="dh" example of required data as mention below agreementno col1 col2 col4 serialno col5 col6 agreementdate recieptno amount intrest ab10005 7456q9 dh 10jan2012:00:00:00 ab10005q910150000 150000 700 cd20006 6783q8 dh 15feb2012:00:00:00 cd20006q815700000 700000 400 bv40007 7672q5 dh 07mar2011:00:00:00 bv40007q50780000 80000 400 gu80005 7637q8 dh 09mar2011:00:00:00 gu80005q80990000 90000 300 Please help me to write the query in proc sql statement Regards, Ashwini
... View more