i have
footnote2 " NOTE :1) < 100 -WHITE,
2) between 100 to 200 --PINK,
3) above 200 ---RED";
i want Footnote with text box and background color
data have;
input (a b c d) ($80.);
cards;
NOTE:
1) < 100 -WHITE
2) between 100 to 200 --PINK
3) above 200 ---RED
;
ods excel file='c:\temp\temp.xlsx' options(sheet_interval='none') ;
proc report data=sashelp.class nowd;
run;
proc report data=have nowd noheader ;
column a b c d;
define b/style={bordercolor=black borderwidth=2};
define c/style={bordercolor=black borderwidth=2 background=pink};
define d/style={bordercolor=black borderwidth=2 background=red};
run;
ods excel close;
According to the documentation and tests I did for one footnote it's possible to have only one background colour and multiple text colours. You can consider creating separated footnotes too. See the code snippet below.
Bart
ods pdf file="R:\test1.pdf";
title "Some title";
footnote1 "Some text";
footnote2
bcolor=lightgrey "NOTE:"
color=white "1) < 100 -WHITE,"
color=pink "2) between 100 to 200 --PINK,"
color=red "3) above 200 ---RED"
;
proc print data=sashelp.class(obs=7);
run;
ods _all_ close;
ods pdf file="R:\test2.pdf";
ods excel file="R:\test2.xlsx"
options(
EMBEDDED_FOOTNOTES="ON"
EMBEDDED_TITLES="ON"
);
title "Some title";
footnote1 "Some text";
footnote2 bcolor=white"NOTE: 1) < 100 -WHITE,";
footnote3 bcolor=pink "2) between 100 to 200 --PINK,";
footnote4 bcolor=red "3) above 200 ---RED";
;
proc print data=sashelp.class(obs=7);
run;
ods excel close;
ods pdf close;
I am using Proc Report, and I want footnotes to appear side by side .
Do you have any other possible suggestions, please?
Provide example data and full code for your current report.
Something like this may be possible with a Break or Rbreak.
data have;
input (a b c d) ($80.);
cards;
NOTE:
1) < 100 -WHITE
2) between 100 to 200 --PINK
3) above 200 ---RED
;
ods excel file='c:\temp\temp.xlsx' options(sheet_interval='none') ;
proc report data=sashelp.class nowd;
run;
proc report data=have nowd noheader ;
column a b c d;
define b/style={bordercolor=black borderwidth=2};
define c/style={bordercolor=black borderwidth=2 background=pink};
define d/style={bordercolor=black borderwidth=2 background=red};
run;
ods excel 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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.