The SAS Output Delivery System and reporting techniques

Title Statements

Reply
Super Contributor
Posts: 268

Title Statements

Hello,
I am generating an excel report with 3 tables in a stored process. However, I have repeating title statements even though I have only 1 set of title statements at the top. So, I tried the workaround of using a blank statements -

title ;
footnote;

However this removes the repeating title statement but also removes any lines between the tables.

So, I changed the above statement to this -

title '';
footnote;

but I keep getting a single quote in the report when I should get a blank row. Any suggestions how to prevent that?

Thanks,
saspert.


%macro _overview_table;

proc sql noprint;
CREATE TABLE WORK.ovrvw_Cum_Elg_Pop AS SELECT *
from sashelp.class;
quit;


/* produce the proc report */
proc report data=ovrvw_Cum_Elg_Pop nowd
style(header)=[just=center font_face=arial foreground=white bordercolor=black background=#003300 font_weight=bold];
run;
quit;
%mend _overview_table;
/****************Call the macro to create overview table**********/
%_overview_table
/****************Call the macro to create overview table**********/


title '';
footnote ;
/*ods escapechar='^';*/
/**/
/*title1 j=left h=14pt 'ERROR_STP_XL_FMT' j=r '^S={preimage="/sasdev/logo.bmp"}';*COLOR=BLACK FONT=Arial Bold;*/


%_overview_table



title '';
footnote ;
/*Title1 h=14pt justify=left font=Arial Bold "Health Assessment Completion by Location Summary";*/

%_overview_table
Super User
Posts: 10,532

Re: Title Statements

Did you try putting any blanks within the quotes? Like TITLE ' ';

SAS generally treats 2 adjacent quotes as a way to say "print one". An example is:

TITLE 'This title displays a single '' quote within a title';
Super Contributor
Posts: 268

Re: Title Statements

Thank you. It does resolve the issue. So, even if I have three adjacent single qoutes, it is considered as one (title .. '''...)?
SAS Super FREQ
Posts: 8,743

Re: Title Statements

Hi:
I'm not sure what you mean by three adjacent single quotes. Can you post your whole TITLE statement???? I would hate for your stored process to get lost in "quote-land" because you accidentally used mismatched quotes.

Generally, if you pad your TITLE statement with spaces, the spaces show up in HTML output -- but might be suppressed in other result types that ignore white space. Really, if you are doing this with a stored process, you need to provide more information, such as your WHOLE title statement and information about what client application is going to receive these results. For example, I'm not sure that PowerPoint or Web Report Studio (since they use SASReport XML format) would respect white space no matter what you did. On the other hand, other client applications might respect additional white space in a TITLE statement.

cynthia
Super Contributor
Posts: 268

Re: Title Statements

Thank you Cynthia. I think your note answered my question.
Ask a Question
Discussion stats
  • 4 replies
  • 193 views
  • 0 likes
  • 3 in conversation