https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-there-an-option-to-control-the-header-footer-in-ODS-EXCELXP/m-p/29673#M4485 Is there a style in PROC TEMPLATE that controls this?<BR /> <BR /> Here's without a header and is OK:<BR /> options TOPMARGIN=1.35IN BOTTOMMARGIN=1.00IN LEFTMARGIN=0.25IN;<BR /> <BR /> Here is the log after adding a HEADER guess, which is obviously wrong:<BR /> options TOPMARGIN=1.25IN BOTTOMMARGIN=0.80IN LEFTMARGIN=0.25IN <BR /> 655 HEADER=0.10 ;<BR /> ______ <BR /> ______ <BR /> ______ <BR /> 13 <BR /> 13 <BR /> 13 <BR /> ERROR 13-12: Unrecognized SAS option name, HEADER. <BR /> ERROR 13-12: Unrecognized SAS option name, HEADER. <BR /> ERROR 13-12: Unrecognized SAS option name, HEADER. Fri, 08 May 2009 17:59:27 GMT Dennis_Hernan 2009-05-08T17:59:27Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-there-an-option-to-control-the-header-footer-in-ODS-EXCELXP/m-p/29673#M4485 Is there a style in PROC TEMPLATE that controls this?<BR /> <BR /> Here's without a header and is OK:<BR /> options TOPMARGIN=1.35IN BOTTOMMARGIN=1.00IN LEFTMARGIN=0.25IN;<BR /> <BR /> Here is the log after adding a HEADER guess, which is obviously wrong:<BR /> options TOPMARGIN=1.25IN BOTTOMMARGIN=0.80IN LEFTMARGIN=0.25IN <BR /> 655 HEADER=0.10 ;<BR /> ______ <BR /> ______ <BR /> ______ <BR /> 13 <BR /> 13 <BR /> 13 <BR /> ERROR 13-12: Unrecognized SAS option name, HEADER. <BR /> ERROR 13-12: Unrecognized SAS option name, HEADER. <BR /> ERROR 13-12: Unrecognized SAS option name, HEADER. Fri, 08 May 2009 17:59:27 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-there-an-option-to-control-the-header-footer-in-ODS-EXCELXP/m-p/29673#M4485 Dennis_Hernan 2009-05-08T17:59:27Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-there-an-option-to-control-the-header-footer-in-ODS-EXCELXP/m-p/29674#M4486 My own answer from Chevell<BR /> This work with Embedded_headers='NO'<BR /> <BR /> Print_Header_margin: Default Value ''<BR /> This is the header margin as set in the page setup dialog window.<BR /> Valid values are measurements in inches. The default is 0.5.<BR /> <BR /> Print_Footer_margin: Default Value ''<BR /> This is the footer margin as set in the page setup dialog window.<BR /> Valid values are measurements in inches. The default is 0.5. Fri, 08 May 2009 18:54:40 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-there-an-option-to-control-the-header-footer-in-ODS-EXCELXP/m-p/29674#M4486 Dennis_Hernan 2009-05-08T18:54:40Z