The SAS Output Delivery System and reporting techniques

multiple Proc Report on same worksheet - Footnote spacing

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

multiple Proc Report on same worksheet - Footnote spacing

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(Smiley Wink 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??

 

 

 


Accepted Solutions
Solution
‎03-02-2018 08:53 AM
Super User
Super User
Posts: 9,599

Re: multiple Proc Report on same worksheet - Footnote spacing

Tagset option: sheet_interval="none"

This will put all output on the same sheet.

View solution in original post


All Replies
Solution
‎03-02-2018 08:53 AM
Super User
Super User
Posts: 9,599

Re: multiple Proc Report on same worksheet - Footnote spacing

Tagset option: sheet_interval="none"

This will put all output on the same sheet.

Highlighted
SAS Super FREQ
Posts: 9,371

Re: multiple Proc Report on same worksheet - Footnote spacing

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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 218 views
  • 1 like
  • 3 in conversation