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??
Tagset option: sheet_interval="none"
This will put all output on the same sheet.
Tagset option: sheet_interval="none"
This will put all output on the same sheet.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.