Hello,
I have two issues with using ODS.
1. The title statement for the ODS PDF destination puts the entire title in 1 line because it is a paged destination. But the same title statement wraps the title if it is longer than the width of the cell in case of Excel. Note that I am not using tagsets to display the output but just pushing the output to Excel like this -
%IF &format = Excel
%THEN %DO;
%LET _ODSDEST = ;
%LET _ODSSTYLE = sasweb;
%LET _ODSSTYLESHEET = ;
%LET _ODSOPTIONS = ;
DATA _NULL_;
rc = STPSRV_HEADER('Content-type', 'application/vnd.ms-excel');
rc = STPSRV_HEADER('Content-disposition', 'attachment; filename=W_Util.xls'); RUN;
%END;
Q:Is there a way to unwrap the title in the excel output (without having to use tagsets)? The report output fits into a single page. So it helps me to avoid the usage of tagsets.excelxp.
2. I get a mysterious blue line extending the length of the longest proc report like this in the output.
Titles1-10;
table from a proc report
----------------------(blueline)------------
title "text";
table from a proc report
----------------------(blueline)------------
table from a proc report
Q: How do I remove this blue line and what is causing it?
Will posting the code from the title statements to the last proc report be helpful?
Thanks,
saspert