cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ramak
‎08-25-2016
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: drill down report automate through mail

by Calcite | Level 5 in SAS Programming
‎08-23-2016 02:27 AM
‎08-23-2016 02:27 AM
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.  ... View more

Re: drill down report automate through mail

by Calcite | Level 5 in SAS Programming
‎08-23-2016 02:24 AM
‎08-23-2016 02:24 AM
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.  ... View more

drill down report automate through mail

by Calcite | Level 5 in SAS Programming
‎08-22-2016 09:43 AM
‎08-22-2016 09:43 AM
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  ... View more

loop queries for multiple calculation

by Calcite | Level 5 in SAS Programming
‎08-05-2016 11:27 AM
‎08-05-2016 11:27 AM
                      Existing Data Require by loop formula     Customer ID Account No Principle Loss Interest Loss Credit Balance Recovery1 Recovery2 Balance     12459699 1234567890 200 100 1000           12459699 3154645488 400 250             12459699 5074723086 500 300             12459699 6994800684 750 800             12459699 8914878282 120 40             13562246 1234557890 454 210 2000           13562246 1234567890 454 455             65646546 1234577890 44 212 1500           65646546 1234587890 21 113                                 Existing Data Require by loop formula     Customer ID Account No Principle Loss Interest Loss Credit Balance Recovery1 Recovery2 Balance     12459699 1234567890 200 100 1000 200 100 700     12459699 3154645488 400 250 700 400 250 50     12459699 5074723086 500 300 50 50 0 0     12459699 6994800684 750 800 0 0 0 0     12459699 8914878282 120 40 0 0 0 0     13562246 1234557890 454 210 2000 454 210 1336     13562246 1234567890 454 455 1336 454 455 427     65646546 1234577890 44 212 1500 44 212 1244     65646546 1234587890 21 113 1244 21 113 1110                       ... View more

Re: How to do a Drill Down

by Calcite | Level 5 in SAS Procedures
‎06-14-2016 02:10 PM
‎06-14-2016 02:10 PM
Dear Madam,   how to prepare male html and female html  and how to give path. ... View more

Create drill down on a KPI via Proc GKPI

by Calcite | Level 5 in SAS Programming
‎06-14-2016 12:24 PM
‎06-14-2016 12:24 PM
Dear Sir/Madam,   Please give a example with code and dataset. ... View more

Merge and center group variables in proc report

by Calcite | Level 5 in SAS Programming
‎06-14-2016 12:18 PM
‎06-14-2016 12:18 PM
Dear Sir/Madam,   spanrows is working only in sas studio when i trying to do with sas 4.3 EG it is not working please help ... View more

Re: SAS Proc Report in SAS 4.3 and studio

by Calcite | Level 5 in ODS and Base Reporting
‎06-09-2016 02:35 PM
‎06-09-2016 02:35 PM
this support note is not opening. ... View more

SAS Proc Report in SAS 4.3 and studio

by Calcite | Level 5 in ODS and Base Reporting
‎06-09-2016 12:40 PM
‎06-09-2016 12:40 PM
Dear Sir / Madam,   I want to arrange the defined across variable headers in order manually in proc report but by default it has come in alaphabatic order.    also i want to interlink the report like eg. when i click a state in a proc reort summary it will show the districts summary under the state and when I click on to district it will be show the citys summarys under district in sas 4.3 and sas studio programming.    Please help me sir. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-25-2016 07:38 AM
Quick links