https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Multireport-title-for-the-first-report-title-for-the/m-p/506546#M21918 <PRE class="tw-data-text tw-ta tw-text-small"><SPAN>Hello, I have a display problem with this method. When I set at the beginning embedded_titles = 'yes', I have two concerns 1 / at the beginning of the display I have this displayed #byval (sex) 2 / the title of the report below the value of the title byval If I remove embedded_titles = 'yes' in beginning, no title #byval in second report<BR />my objectifs are<BR />1/ Insert the title of the report 2/ then, if there are titles that result from the #byval then it appears after the title of the report Thank you for your help</SPAN>&nbsp;</PRE><P>&nbsp;</P><PRE><CODE class=" language-sas">proc sort data=sashelp.class out=class; by sex; run; ODS LISTING CLOSE; ods escapechar="~"; ods excel file="H:\newdirectory\test.xls" options(sheet_name='test' sheet_interval='none' suppress_bylines='yes' ); ods text="~{style[color=Black fontstyle=italic font_weight=bold] Report 1}"; proc report data= class ; run; ods text="~{style[color=Black fontstyle=italic font_weight=bold] Report 2}"; ods excel options(embedded_titles='yes' ); proc report data= class ; by sex; title j=l '#byval(sex)'; run; ods _all_ close; ODS LISTING CLOSE;</CODE></PRE><P>&nbsp;</P> Mon, 22 Oct 2018 17:35:09 GMT mansour_ib_sas 2018-10-22T17:35:09Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Multireport-title-for-the-first-report-title-for-the/m-p/506546#M21918 <PRE class="tw-data-text tw-ta tw-text-small"><SPAN>Hello, I have a display problem with this method. When I set at the beginning embedded_titles = 'yes', I have two concerns 1 / at the beginning of the display I have this displayed #byval (sex) 2 / the title of the report below the value of the title byval If I remove embedded_titles = 'yes' in beginning, no title #byval in second report<BR />my objectifs are<BR />1/ Insert the title of the report 2/ then, if there are titles that result from the #byval then it appears after the title of the report Thank you for your help</SPAN>&nbsp;</PRE><P>&nbsp;</P><PRE><CODE class=" language-sas">proc sort data=sashelp.class out=class; by sex; run; ODS LISTING CLOSE; ods escapechar="~"; ods excel file="H:\newdirectory\test.xls" options(sheet_name='test' sheet_interval='none' suppress_bylines='yes' ); ods text="~{style[color=Black fontstyle=italic font_weight=bold] Report 1}"; proc report data= class ; run; ods text="~{style[color=Black fontstyle=italic font_weight=bold] Report 2}"; ods excel options(embedded_titles='yes' ); proc report data= class ; by sex; title j=l '#byval(sex)'; run; ods _all_ close; ODS LISTING CLOSE;</CODE></PRE><P>&nbsp;</P> Mon, 22 Oct 2018 17:35:09 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Multireport-title-for-the-first-report-title-for-the/m-p/506546#M21918 mansour_ib_sas 2018-10-22T17:35:09Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Multireport-title-for-the-first-report-title-for-the/m-p/506550#M21919 options nobyline;<BR />I think that removes the by titles. Then you can explicitly control them using your own Title2 statements. You'll need to reference the by variables using #byval notation. See the documentation for more details and examples<BR /><BR /><A href="https://documentation.sas.com/?docsetId=grstatproc&amp;docsetTarget=n1ukd9sqgqiwwhn1mrx4c1rbse1j.htm&amp;docsetVersion=9.4&amp;locale=en#p0uv7aycufekfdn1jyaf35cvxeuj" target="_blank">https://documentation.sas.com/?docsetId=grstatproc&amp;docsetTarget=n1ukd9sqgqiwwhn1mrx4c1rbse1j.htm&amp;docsetVersion=9.4&amp;locale=en#p0uv7aycufekfdn1jyaf35cvxeuj</A> Mon, 22 Oct 2018 17:51:53 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Multireport-title-for-the-first-report-title-for-the/m-p/506550#M21919 Reeza 2018-10-22T17:51:53Z