topic Re: WATERMARK IN SAS OUTPUT HIDE BEHIND DATA in ODS and Base Reporting

WATERMARK IN SAS OUTPUT HIDE BEHIND DATA

sam1231 — Wed, 18 Sep 2019 05:28:32 GMT

i AM USING DDE TO INVOKE VBA CODE FROM WORD FOR WATERMARK MY RTF OUTPUT!
But somehow watermarking "Confidential" hide behind table.

How to fix this?

Re: WATERMARK IN SAS OUTPUT HIDE BEHIND DATA

Reeza — Wed, 18 Sep 2019 07:30:26 GMT

Remove the code that adds it or remove it from the template, if you’re using one.

If you need help finding the code to delete, please post your code.

PS. All caps is the equivalent of yelling on the internet.

@sam1231 wrote:

HI

i AM USING DDE TO INVOKE VBA CODE FROM WORD FOR WATERMARK MY RTF OUTPUT!
But somehow watermarking "Confidential" hide behind table.

How to fix this?

Re: WATERMARK IN SAS OUTPUT HIDE BEHIND DATA

sam1231 — Wed, 18 Sep 2019 14:13:06 GMT

ODS PATH work.templat(update) sasuser.templat(read)
               sashelp.tmplmst(read);
Proc Template; 
      Define Style Styles.STNDR /*/ Store = SASuser.Templat*/;
             Parent = Styles.printer ;
             replace body from document /
                 leftmargin=1.10in
                 rightmargin=0.6in
                 topmargin=0.75in
                 bottommargin=0.5in
                 ;
              style table from table/
                frame=void
				WATERMARK=ON
      protectspecialchars=off
                rules=groups
                cellpadding=2pt cellspacing=1.25pt borderwidth=0.5pt; 
              Style SystemTitle From TitlesAndFooters /
                 Font = ( "Times New Roman",12Pt,Bold )
                 Just = Center ;

              Style SystemFooter From TitlesAndFooters /
                 Font = ( "Times New Roman",10Pt,Bold )
                 Just = Center ;
    replace HeadersAndFooters from Cell /

                font = fonts('docFont')
                foreground=colors('datafg')
                background=colors('databg')
                protectspecialchars=off;
    
    End ;
run;

Re: WATERMARK IN SAS OUTPUT HIDE BEHIND DATA

Reeza — Wed, 18 Sep 2019 17:05:09 GMT

WATERMARK = ON seems like where you'd start?