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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: