Hi please have look at output sample, a am not getting the desired output in the total. I need only DPD column for each month data. I have also reposted the input datastep In the end. Please help me about it, i am new user to SAS Loan_ID,Loan_Disbursement_Date,Product_Code,App_Status,Payment_Frequency,Score,EMI_Date,EMI_Received_Date,Account_Number,Account_Open_Date,Age,Gender,Income,City,Nationality,ds,dpd,where 1,"November 28, 2015",3,1,Monthly,297,"December 28, 2015","March 19, 2016",A0001,"January 14, 2014",42,2,28553,Kolkata,India,WORK.JAN,82,1 2,"November 02, 2015",1,1,Monthly,398,"December 03, 2015","March 16, 2016",A0002,"December 17, 2013",29,2,50014,Bangalore,India,WORK.JAN,104,1 3,"February 10, 2015",3,1,Monthly,184,"March 13, 2015","April 30, 2015",A0003,"December 13, 2011",22,2,29490,Bangalore,India,WORK.JAN,48,1 4,"April 08, 2015",4,1,Monthly,365,"May 09, 2015","June 18, 2015",A0004,"October 27, 2011",51,2,51984,Bangalore,India,WORK.JAN,40,1 5,"June 29, 2015",1,1,Monthly,364,"July 30, 2015","October 20, 2015",A0005,"May 18, 2011",36,1,88854,Delhi,India,WORK.JAN,82,1 6,"September 29, 2015",1,1,Monthly,372,"October 30, 2015","February 18, 2016",A0006,"August 11, 2011",26,2,87160,Delhi,India,WORK.JAN,111,1 7,"November 04, 2015",1,1,Monthly,295,"December 05, 2015","March 22, 2016",A0007,"February 14, 2013",42,1,84044,Bangalore,India,WORK.JAN,108,1 8,"June 25, 2015",4,1,Monthly,191,"July 26, 2015","September 10, 2015",A0008,"August 05, 2013",48,1,85523,Delhi,India,WORK.JAN,46,1 9,"August 24, 2015",2,1,Monthly,392,"September 24, 2015","September 27, 2015",A0009,"February 13, 2011",22,1,92429,Bangalore,India,WORK.JAN,3,1 10,"June 06, 2015",2,1,Monthly,190,"July 07, 2015","October 25, 2015",A0010,"May 01, 2011",44,1,69001,Kolkata,India,WORK.JAN,110,1 ################ Datastep ############ data WORK.JAN; infile datalines dsd truncover; input Loan_ID:BEST. Loan_Disbursement_Date:NLDATE. Product_Code:BEST. App_Status:BEST. Payment_Frequency:$7. Score:BEST. EMI_Date:NLDATE. EMI_Received_Date:NLDATE. Account_Number:$5. Account_Open_Date:NLDATE. Age:BEST. Gender:BEST. Income:BEST. City:$9. Nationality:$5. ds:$200. dpd:32. where:32.; datalines4; 1,"November 28, 2015",3,1,Monthly,297,"December 28, 2015","March 19, 2016",A0001,"January 14, 2014",42,2,28553,Kolkata,India,WORK.JAN,82,1 2,"November 02, 2015",1,1,Monthly,398,"December 03, 2015","March 16, 2016",A0002,"December 17, 2013",29,2,50014,Bangalore,India,WORK.JAN,104,1 3,"February 10, 2015",3,1,Monthly,184,"March 13, 2015","April 30, 2015",A0003,"December 13, 2011",22,2,29490,Bangalore,India,WORK.JAN,48,1 4,"April 08, 2015",4,1,Monthly,365,"May 09, 2015","June 18, 2015",A0004,"October 27, 2011",51,2,51984,Bangalore,India,WORK.JAN,40,1 ;;;;
... View more
