DATA Step, Macro, Functions and more

drill down report automate through mail

Reply
Occasional Contributor
Posts: 9

drill down report automate through mail

I need a drill down report to send separate mail through automation in sas  by concerned product,state,zone,npa flag

 

 

 

  Values 
PRODUCTZDMCOUNTPOS 
FEKARTHIK K266000
 PURUSHOTHAM 260000
 RAMA P130000
 RAVI K4144000
 SAFFI J136000
 SUNIL SHARMA112000
 VENKATA K254000
 VISHAL PANDEY112000
FE Total 14414000
Grand Total 14414000

 

need to mail the  drill down repot to  all zdm against his product separately 

Super User
Posts: 7,832

Re: drill down report automate through mail

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 9

Re: drill down report automate through mail

Posted in reply to KurtBremser

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. 

Occasional Contributor
Posts: 9

Re: drill down report automate through mail

Posted in reply to KurtBremser

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. 

Ask a Question
Discussion stats
  • 3 replies
  • 267 views
  • 0 likes
  • 2 in conversation