I need a drill down report to send separate mail through automation in sas by concerned product,state,zone,npa flag
Values | |||
PRODUCT | ZDM | COUNT | POS |
FE | KARTHIK K | 2 | 66000 |
PURUSHOTHAM | 2 | 60000 | |
RAMA P | 1 | 30000 | |
RAVI K | 4 | 144000 | |
SAFFI J | 1 | 36000 | |
SUNIL SHARMA | 1 | 12000 | |
VENKATA K | 2 | 54000 | |
VISHAL PANDEY | 1 | 12000 | |
FE Total | 14 | 414000 | |
Grand Total | 14 | 414000 |
need to mail the drill down repot to all zdm against his product separately
Please post example data in the form of a data step with datalines or cards.
Nobody in his right mind will open an Excel file from the internet.
data sample;
input LOAN_NO $16. PRODUCT$ BOOK_FLAG$ FLAG$ STATE$ ZONE$ ZDM$ MANAGE_BY$ BKT$ POS NPA_FLAG$ STATUS$;
datalines;
B9CPR00013402122 FF OLD_BOOK DIRECT MAHARASHTRA WEST PURUSHOTHAM DSMG 13 18000 NPA Resolved
B9CPR00013402301 FE OLD_BOOK CORPORATE MAHARASHTRA WEST VENKATA BUSS 12 24000 NPA Unresolved
B9CPR00013402562 SHG NEW_BOOK DIRECT TELANGANA SOUTH BALAJI DSMG 10 24000 PNPA Unresolved
B9CPR00013402687 FE OLD_BOOK DIRECT PUNJAB NORTH SUNIL DSMG 9 12000 NPA Resolved
B9CPR00013402803 FE OLD_BOOK DIRECT ODISHA EAST KARTHIK BUSS 13 30000 NPA Resolved
B9CPR00013402900 FE NEW_BOOK DIRECT TAMILNADU SOUTH RAVI DSMG 8 36000 PNPA Unresolved
B9CPR00013403034 SHG NEW_BOOK CORPORATE KERALA SOUTH BALAJI BUSS 7 30000 PNPA Unresolved
B9CPR00013403124 FE OLD_BOOK CORPORATE MAHARASHTRA WEST PURUSHOTHAM DSMG 6 36000 NPA Unresolved
B9CPR00013403243 SHG NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 2 36000 PNPA Resolved
B9CPR00013403460 SHG OLD_BOOK DIRECT PUNJAB NORTH SAFFI BUSS 6 12000 NPA Unresolved
B9CPR00013403610 FE NEW_BOOK CORPORATE ANDHRAPRADESH SOUTH RAVI DSMG 4 36000 NPA Unresolved
B9CPR00013404916 FE OLD_BOOK DIRECT MAHARASHTRA WEST PURUSHOTHAM DSMG 3 24000 PNPA Resolved
B9CPR00013405049 SHG NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 2 24000 NPA Resolved
B9CPR00013503292 FE OLD_BOOK DIRECT ASSAM EAST KARTHIK BUSS 1 36000 NPA Unresolved
B9CPR00013503383 FE OLD_BOOK CORPORATE MADHYAPRADESH WEST VENKATA DSMG 5 30000 PNPA Unresolved
B9CPR00013503797 FE OLD_BOOK DIRECT TELANGANA SOUTH RAVI DSMG 5 36000 NPA Resolved
B9CPR00013504170 SHG NEW_BOOK DIRECT PUNJAB NORTH FAISAL BUSS 4 36000 PNPA Resolved
B9CPR00013504223 SHG NEW_BOOK CORPORATE KERALA SOUTH BALAJI DSMG 6 10200 NPA Unresolved
B9CPR00013504230 FE OLD_BOOK CORPORATE TELANGANA SOUTH RAVI DSMG 7 36000 PNPA Resolved
B9CPR00013504243 SHG NEW_BOOK DIRECT PUNJAB NORTH FAISAL BUSS 6 36000 NPA Unresolved
B9CPR00013504289 FE NEW_BOOK DIRECT ODISHA EAST VISHAL DSMG 9 12000 PNPA Unresolved
B9CPR00013504445 FE OLD_BOOK CORPORATE ODISHA EAST RAMA BUSS 7 30000 NPA Resolved
B9CPR00013504465 FE OLD_BOOK DIRECT PUNJAB NORTH SAFFI BUSS 8 36000 NPA Resolved
B9CPR00013504578 FF NEW_BOOK DIRECT MADHYAPRADESH WEST PURUSHOTHAM DSMG 1 13800 PNPA Unresolved
B9CPR00013504676 FF NEW_BOOK CORPORATE TELANGANA SOUTH BALAJI BUSS 2 24000 NPA Unresolved
B9CPR00013504740 FF OLD_BOOK CORPORATE PUNJAB NORTH SUNIL DSMG 3 24000 NPA Resolved
B9CPR00013530549 FF NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 3 24000 PNPA Unresolved
B9CPR00013530568 FF OLD_BOOK CORPORATE KERALA SOUTH RAVI BUSS 2 36000 NPA Unresolved
B9CPR00013530588 FF NEW_BOOK DIRECT ODISHA EAST VISHAL DSMG 8 30000 NPA Resolved
B9CPR00013530619 FF OLD_BOOK DIRECT KERALA SOUTH BALAJI DSMG 5 36000 PNPA Unresolved
B9CPR00013530725 FF OLD_BOOK CORPORATE TELANGANA SOUTH BALAJI BUSS 8 36000 NPA Resolved
B9CPR00013530947 FF OLD_BOOK DIRECT ODISHA EAST KARTHIK DSMG 1 36000 PNPA Unresolved
B9CPR00013530977 FF OLD_BOOK CORPORATE ASSAM EAST RAMA DSMG 2 24000 PNPA Resolved
RUN;
in the above data i want to mail automate drill down report to ZDM"s product wise sepatate by concern ZDM.
data sample;
input LOAN_NO $16. PRODUCT$ BOOK_FLAG$ FLAG$ STATE$ ZONE$ ZDM$ MANAGE_BY$ BKT$ POS NPA_FLAG$ STATUS$;
datalines;
B9CPR00013402122 FF OLD_BOOK DIRECT MAHARASHTRA WEST PURUSHOTHAM DSMG 13 18000 NPA Resolved
B9CPR00013402301 FE OLD_BOOK CORPORATE MAHARASHTRA WEST VENKATA BUSS 12 24000 NPA Unresolved
B9CPR00013402562 SHG NEW_BOOK DIRECT TELANGANA SOUTH BALAJI DSMG 10 24000 PNPA Unresolved
B9CPR00013402687 FE OLD_BOOK DIRECT PUNJAB NORTH SUNIL DSMG 9 12000 NPA Resolved
B9CPR00013402803 FE OLD_BOOK DIRECT ODISHA EAST KARTHIK BUSS 13 30000 NPA Resolved
B9CPR00013402900 FE NEW_BOOK DIRECT TAMILNADU SOUTH RAVI DSMG 8 36000 PNPA Unresolved
B9CPR00013403034 SHG NEW_BOOK CORPORATE KERALA SOUTH BALAJI BUSS 7 30000 PNPA Unresolved
B9CPR00013403124 FE OLD_BOOK CORPORATE MAHARASHTRA WEST PURUSHOTHAM DSMG 6 36000 NPA Unresolved
B9CPR00013403243 SHG NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 2 36000 PNPA Resolved
B9CPR00013403460 SHG OLD_BOOK DIRECT PUNJAB NORTH SAFFI BUSS 6 12000 NPA Unresolved
B9CPR00013403610 FE NEW_BOOK CORPORATE ANDHRAPRADESH SOUTH RAVI DSMG 4 36000 NPA Unresolved
B9CPR00013404916 FE OLD_BOOK DIRECT MAHARASHTRA WEST PURUSHOTHAM DSMG 3 24000 PNPA Resolved
B9CPR00013405049 SHG NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 2 24000 NPA Resolved
B9CPR00013503292 FE OLD_BOOK DIRECT ASSAM EAST KARTHIK BUSS 1 36000 NPA Unresolved
B9CPR00013503383 FE OLD_BOOK CORPORATE MADHYAPRADESH WEST VENKATA DSMG 5 30000 PNPA Unresolved
B9CPR00013503797 FE OLD_BOOK DIRECT TELANGANA SOUTH RAVI DSMG 5 36000 NPA Resolved
B9CPR00013504170 SHG NEW_BOOK DIRECT PUNJAB NORTH FAISAL BUSS 4 36000 PNPA Resolved
B9CPR00013504223 SHG NEW_BOOK CORPORATE KERALA SOUTH BALAJI DSMG 6 10200 NPA Unresolved
B9CPR00013504230 FE OLD_BOOK CORPORATE TELANGANA SOUTH RAVI DSMG 7 36000 PNPA Resolved
B9CPR00013504243 SHG NEW_BOOK DIRECT PUNJAB NORTH FAISAL BUSS 6 36000 NPA Unresolved
B9CPR00013504289 FE NEW_BOOK DIRECT ODISHA EAST VISHAL DSMG 9 12000 PNPA Unresolved
B9CPR00013504445 FE OLD_BOOK CORPORATE ODISHA EAST RAMA BUSS 7 30000 NPA Resolved
B9CPR00013504465 FE OLD_BOOK DIRECT PUNJAB NORTH SAFFI BUSS 8 36000 NPA Resolved
B9CPR00013504578 FF NEW_BOOK DIRECT MADHYAPRADESH WEST PURUSHOTHAM DSMG 1 13800 PNPA Unresolved
B9CPR00013504676 FF NEW_BOOK CORPORATE TELANGANA SOUTH BALAJI BUSS 2 24000 NPA Unresolved
B9CPR00013504740 FF OLD_BOOK CORPORATE PUNJAB NORTH SUNIL DSMG 3 24000 NPA Resolved
B9CPR00013530549 FF NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 3 24000 PNPA Unresolved
B9CPR00013530568 FF OLD_BOOK CORPORATE KERALA SOUTH RAVI BUSS 2 36000 NPA Unresolved
B9CPR00013530588 FF NEW_BOOK DIRECT ODISHA EAST VISHAL DSMG 8 30000 NPA Resolved
B9CPR00013530619 FF OLD_BOOK DIRECT KERALA SOUTH BALAJI DSMG 5 36000 PNPA Unresolved
B9CPR00013530725 FF OLD_BOOK CORPORATE TELANGANA SOUTH BALAJI BUSS 8 36000 NPA Resolved
B9CPR00013530947 FF OLD_BOOK DIRECT ODISHA EAST KARTHIK DSMG 1 36000 PNPA Unresolved
B9CPR00013530977 FF OLD_BOOK CORPORATE ASSAM EAST RAMA DSMG 2 24000 PNPA Resolved
RUN;in the above data i want to mail automate drill down report to ZDM"s product wise sepatate by concern ZDMdata sample;
input LOAN_NO $16. PRODUCT$ BOOK_FLAG$ FLAG$ STATE$ ZONE$ ZDM$ MANAGE_BY$ BKT$ POS NPA_FLAG$ STATUS$;
datalines;
B9CPR00013402122 FF OLD_BOOK DIRECT MAHARASHTRA WEST PURUSHOTHAM DSMG 13 18000 NPA Resolved
B9CPR00013402301 FE OLD_BOOK CORPORATE MAHARASHTRA WEST VENKATA BUSS 12 24000 NPA Unresolved
B9CPR00013402562 SHG NEW_BOOK DIRECT TELANGANA SOUTH BALAJI DSMG 10 24000 PNPA Unresolved
B9CPR00013402687 FE OLD_BOOK DIRECT PUNJAB NORTH SUNIL DSMG 9 12000 NPA Resolved
B9CPR00013402803 FE OLD_BOOK DIRECT ODISHA EAST KARTHIK BUSS 13 30000 NPA Resolved
B9CPR00013402900 FE NEW_BOOK DIRECT TAMILNADU SOUTH RAVI DSMG 8 36000 PNPA Unresolved
B9CPR00013403034 SHG NEW_BOOK CORPORATE KERALA SOUTH BALAJI BUSS 7 30000 PNPA Unresolved
B9CPR00013403124 FE OLD_BOOK CORPORATE MAHARASHTRA WEST PURUSHOTHAM DSMG 6 36000 NPA Unresolved
B9CPR00013403243 SHG NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 2 36000 PNPA Resolved
B9CPR00013403460 SHG OLD_BOOK DIRECT PUNJAB NORTH SAFFI BUSS 6 12000 NPA Unresolved
B9CPR00013403610 FE NEW_BOOK CORPORATE ANDHRAPRADESH SOUTH RAVI DSMG 4 36000 NPA Unresolved
B9CPR00013404916 FE OLD_BOOK DIRECT MAHARASHTRA WEST PURUSHOTHAM DSMG 3 24000 PNPA Resolved
B9CPR00013405049 SHG NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 2 24000 NPA Resolved
B9CPR00013503292 FE OLD_BOOK DIRECT ASSAM EAST KARTHIK BUSS 1 36000 NPA Unresolved
B9CPR00013503383 FE OLD_BOOK CORPORATE MADHYAPRADESH WEST VENKATA DSMG 5 30000 PNPA Unresolved
B9CPR00013503797 FE OLD_BOOK DIRECT TELANGANA SOUTH RAVI DSMG 5 36000 NPA Resolved
B9CPR00013504170 SHG NEW_BOOK DIRECT PUNJAB NORTH FAISAL BUSS 4 36000 PNPA Resolved
B9CPR00013504223 SHG NEW_BOOK CORPORATE KERALA SOUTH BALAJI DSMG 6 10200 NPA Unresolved
B9CPR00013504230 FE OLD_BOOK CORPORATE TELANGANA SOUTH RAVI DSMG 7 36000 PNPA Resolved
B9CPR00013504243 SHG NEW_BOOK DIRECT PUNJAB NORTH FAISAL BUSS 6 36000 NPA Unresolved
B9CPR00013504289 FE NEW_BOOK DIRECT ODISHA EAST VISHAL DSMG 9 12000 PNPA Unresolved
B9CPR00013504445 FE OLD_BOOK CORPORATE ODISHA EAST RAMA BUSS 7 30000 NPA Resolved
B9CPR00013504465 FE OLD_BOOK DIRECT PUNJAB NORTH SAFFI BUSS 8 36000 NPA Resolved
B9CPR00013504578 FF NEW_BOOK DIRECT MADHYAPRADESH WEST PURUSHOTHAM DSMG 1 13800 PNPA Unresolved
B9CPR00013504676 FF NEW_BOOK CORPORATE TELANGANA SOUTH BALAJI BUSS 2 24000 NPA Unresolved
B9CPR00013504740 FF OLD_BOOK CORPORATE PUNJAB NORTH SUNIL DSMG 3 24000 NPA Resolved
B9CPR00013530549 FF NEW_BOOK CORPORATE MAHARASHTRA WEST VENKATA DSMG 3 24000 PNPA Unresolved
B9CPR00013530568 FF OLD_BOOK CORPORATE KERALA SOUTH RAVI BUSS 2 36000 NPA Unresolved
B9CPR00013530588 FF NEW_BOOK DIRECT ODISHA EAST VISHAL DSMG 8 30000 NPA Resolved
B9CPR00013530619 FF OLD_BOOK DIRECT KERALA SOUTH BALAJI DSMG 5 36000 PNPA Unresolved
B9CPR00013530725 FF OLD_BOOK CORPORATE TELANGANA SOUTH BALAJI BUSS 8 36000 NPA Resolved
B9CPR00013530947 FF OLD_BOOK DIRECT ODISHA EAST KARTHIK DSMG 1 36000 PNPA Unresolved
B9CPR00013530977 FF OLD_BOOK CORPORATE ASSAM EAST RAMA DSMG 2 24000 PNPA Resolved
RUN;
in the above data i want to mail automate drill down report to ZDM"s product wise sepatate by concern ZDM.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: