topic ODS EXCEL Title in ODS and Base Reporting

ODS EXCEL Title

dtchoi86 — Fri, 26 May 2017 13:06:08 GMT

I'm trying to place a message above the table. Is there a way to make the first sentence bold, but the following sentences not bold.

I have...

title1 j=left lspace=0 height=10pt font="&font." color=red BOLD "WARNING THIS IS EXPLORATORY" NOTBOLD? "REST OF THE PARAGRAPH";

Also, I see that when the title is really long, about a typical paragraph, there is a decent white gap between the top of the speadsheet and where the message starts. Any ideas on thi as well?

Thank you!

Re: ODS EXCEL Title

RW9 — Fri, 26 May 2017 13:14:56 GMT

Well, for your first question:

title1 j=left lspace=0 height=10pt font="&font." color=red bold "WARNING THIS IS EXPLORATORY";
title2 ... "REST OF THE PARAGRAPH";

You can have up to 10 titles. If it was RTF you were outputting to then you could use inline tags to aid, but that doesn't work in tagsets.excelxp output.

For your second point, you seem to mistake what a title is. A title is a shorter text to give some overview to a report. If you plan to put out paragraphs of text then put that in a dataset and proc report it out with notab split, i.e. so all the text appears in one printout then your other output, but all as one sheet. In fact, if your dealing with spreadsheets in general titles are a bit pointless - spreadsheets are not word procecessors.

Re: ODS EXCEL Title

dtchoi86 — Fri, 26 May 2017 14:17:09 GMT

I apologize, but could you provide reference or an example on the proc report notab split?

Re: ODS EXCEL Title

RW9 — Fri, 26 May 2017 14:53:05 GMT

Its not the proc report but the ods options:

You might even be able to do:

ods tagsets.excelxp options(sheet_name="Sheet1");

proc report data=text...;

proc report data=your_data...;

ods tagsets.excelxp options(sheet_name="Sheet2");

...

Reference on options here:

https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html

Re: ODS EXCEL Title

ballardw — Fri, 26 May 2017 21:12:54 GMT

You may want to consider that the Style used for your ODS output sets defaults for such things as title and footnote text appearance. If you use the same options repeatedly you may want to make a custom version of the style you use to set such things.

You may also want to use ODS Text instead of Title statements.

Re: ODS EXCEL Title

SuzanneDorinski — Sat, 27 May 2017 15:57:22 GMT

You could use PROC ODSTEXT.

ODS EXCEL FILE="/folders/myfolders/SAS Communities/add_titles_to_Excel.xlsx" 
  options(sheet_name="Use ODSTEXT"
          sheet_interval='none'
          embedded_titles='yes');

* h statement is new for PROC ODSTEXT in SAS 9.4M4. 
* but it does NOT show up in ODS EXCEL...;

proc odstext;
  *h "WARNING: THIS IS EXPLORATORY" / style=[color=red];
  p "WARNING: THIS IS EXPLORATORY." / style=[color=red font_weight=bold];
  p "Once the spreadsheet has passed the internal review procedures, it will be posted to the company internet site.";
  p "Please contact Jane Moneypenny for more details.  Thank you and have a nice day!";
run;

proc print data=sashelp.class;
run;

ODS EXCEL CLOSE;