The SAS Output Delivery System and reporting techniques

ODS Email application sends emall but no xml

Reply
Frequent Contributor
Posts: 123

ODS Email application sends emall but no xml

ODS TAGSETS.ExcelXP file="&ReportOut1..xml" Path="&OutDir" style=&dors_style;

 

%CoverSheet(&ReportName,&pbd_date_key,&Version);

/*sheet1 prior bus day*/

ODS TAGSETS.ExcelXP

   options(sheet_interval='none'

           default_column_width='8'

           sheet_name="Prior Bus Day_Summary"

           center_horizontal="no"

           Orientation='Landscape'

           embedded_titles='Yes'

           fittopage="No"

           blackandwhite="No"

           Embedded_Footnotes='Yes'

              absolute_column_width='7'

           autofit_height="Yes");

 

%NoAccountLogic(reg_1_summary,&ReportName);

 

Proc tabulate data=reg_1_summary order= data format=10. S=[cellwidth=150];

Class THRD_PARTY_ORIG_NM Platform ;

Var ln ;

Table THRD_PARTY_ORIG_NM=' ' all={label='Grand Total' S=[background = lightblue cellwidth=160]} *[STYLE=[Font_Weight=BOLD]],

         Platform='Platform '*ln=' '*sum=' '

       all={label='Grand Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] *ln=' '*sum=' ' / box='3rd Party Name';

           TITLE 'Prior Bus Day Summary';

           footnote1 &dekeyp;

run;

 

ODS TAGSETS.ExcelXP

   options(sheet_interval='none'

           default_column_width='8'

           sheet_name="Prior Bus Day_Detail"

           center_horizontal="no"

           Orientation='Landscape'

           embedded_titles='Yes'

           fittopage="No"

           blackandwhite="No"

           Embedded_Footnotes='Yes'

              absolute_column_width='7'

           autofit_height="Yes");

 

%NoAccountLogic(reg_1,&ReportName);

 

PROC REPORT DATA=reg_1 headskip split='*' wrap nowd

 

           style(report)=[background=black cellspacing=10 just=center font_size=11pt font_face="Calibri" bordercolor=black borderwidth=1]

           style(column)=[background=white font_size=10pt bordercolor=black borderwidth=1]

                     ;

COLUMNS _all_;

   ;

 

       DEFINE ln_nbr / Display style(column)={tagattr="format:0000000000" cellwidth=80pt just=right} "LOAN NUMBER";

              

       FOOTNOTE1 justify=Left Height=8pt "&FNote1";

           FOOTNOTE2 justify=Left Height=8pt "&ReportName";

 

           FOOTNOTE1 justify=Left Height=8pt "&FNote1";

           FOOTNOTE2 justify=Left Height=8pt "&ReportName";

 

           run;

 

/*email application*/          

               

%let mailto= %str(xxxx.A.yyyy@me.com;          

             );           

               

%let Main_Mess=My message;               

Data _NULL_;              

%sysexec /dors09/reporting/prod/scripts/sendmail.pl              

&mailto "&OutDir" "&ReportOut1..xml" "&Main_Mess" ;           

Run;

 

The report is to produce one 2 tab report. (Prio Bus Day Summary and Prior Bus Day Detail) "&ReportOut1..xml" controls the output. What is happening is when I run the report it produces the email reference but not xml output. Here are my questions

  1. Looking at the code any ideas of why I only get the email reference but not actual xml data
  2. Since this is 2 tab report is there a way to format this so that a two tab report is produced

 

 

Post a Question
Discussion Stats
  • 0 replies
  • 390 views
  • 0 likes
  • 1 in conversation