The SAS Output Delivery System and reporting techniques

Is there an option to control the header & footer in ODS EXCELXP?

Reply
New Contributor
Posts: 2

Is there an option to control the header & footer in ODS EXCELXP?

Is there a style in PROC TEMPLATE that controls this?

Here's without a header and is OK:
options TOPMARGIN=1.35IN BOTTOMMARGIN=1.00IN LEFTMARGIN=0.25IN;

Here is the log after adding a HEADER guess, which is obviously wrong:
options TOPMARGIN=1.25IN BOTTOMMARGIN=0.80IN LEFTMARGIN=0.25IN
655 HEADER=0.10 ;
______
______
______
13
13
13
ERROR 13-12: Unrecognized SAS option name, HEADER.
ERROR 13-12: Unrecognized SAS option name, HEADER.
ERROR 13-12: Unrecognized SAS option name, HEADER.
New Contributor
Posts: 2

Re: Is there an option to control the header & footer in ODS EXCELXP?

My own answer from Chevell
This work with Embedded_headers='NO'

Print_Header_margin: Default Value ''
This is the header margin as set in the page setup dialog window.
Valid values are measurements in inches. The default is 0.5.

Print_Footer_margin: Default Value ''
This is the footer margin as set in the page setup dialog window.
Valid values are measurements in inches. The default is 0.5.
Ask a Question
Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 1 in conversation