topic multiple Proc Report on same worksheet - Footnote spacing in ODS and Base Reporting

multiple Proc Report on same worksheet - Footnote spacing

cuevasj — Fri, 02 Mar 2018 13:08:29 GMT

I am trying to get two proc reports to display on one excel worksheet, but I keep getting two worksheets, one for each proc report.

/************************************/

%let _odsdest=tagsets.excelxp;
%let rc=%sysfunc(stpsrv_header(Content-type,application/vnd.ms-excel));
%let rc=%sysfunc(stpsrv_header(Content-disposition,attachment%str(;) filename=FDU_Report_&doe_year._SchoolNo_9876_&today..xml));

%stpbegin();

proc sql;

...

quti;
proc sql;

...

quit;

ods tagsets.excelxp options(frozen_headers='1'
autofilter='yes'
autofit_height='yes'
sheet_name='FDU Report');

%let bwidth=borderleftwidth=1px borderrightwidth=1px borderbottomwidth=1px bordertopwidth=1px;
%let bstyle= borderleftstyle=solid borderrightstyle=solid borderbottomstyle=solid bordertopstyle=solid;
options missing=' ' nomprint nomlogic;

proc report data=overall_detials missing nowd split='~';

...

run;

proc report data=details missing nowd split='~' ;

...

run;

ods _all_ close;

What am I missing or can this not be done??

Re: multiple Proc Report on same worksheet - Footnote spacing

RW9 — Fri, 02 Mar 2018 13:33:26 GMT

Tagset option: sheet_interval="none"

This will put all output on the same sheet.

Re: multiple Proc Report on same worksheet - Footnote spacing

Cynthia_sas — Fri, 02 Mar 2018 13:33:44 GMT

Hi:
The only way I know to get 2 procedures on one sheet with ODS TAGSETS.EXCELXP or ODS EXCEL is to use the SHEET_INTERVAL= suboption. I do not see that in your code. There have been several other postings about the use of SHEET_INTERVAL, I think you'll find them if you search.

Cynthia