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
my objectifs are
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
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.