drill down report automate through mail

[ramak]

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 

[Kurt_Bremser]

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.

[ramak]

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. 

[ramak]

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.