As I was cutting and pasting this together, I began to worry that it was going to work - BUT - is still doesn't work. The same dysfunction. But it is different today, I'll explain after this:
/*New EG Node*/
ODS document name=excel(write);
ODS document close;
title;footnote;
/*New EG Node*/
ODS document name=excel(UPDATE) DIR=(PATH=\Table_1);
title "Table 1";
title2 "Lorem ipsum dolor Average Daily Populations";
title3 "and sit amet Rates Per 1,000 consectetur Population ";
title4 "for 2021*";
title5 " ";
%let Caveats="This is an Excel copy of data provided monthly and published at http://adipiscing.elit.Fusce/pub Refer to the his data's correspondng published report for all caveats to the data.";
Footnote &Caveats;
title6 &Caveats;
proc report data=sashelp.CARS(OBS=50) style(header)=[background=lightgray Font_Weight=Bold] ;
Column Make Model Type Origin DriveTrain MSRP;
run;
title;
ODS document;
/*New EG Node*/
ODS document name=excel(UPDATE) DIR=(PATH=\Table_2);
Title "Table 2";
Title2 "Mauris Ex Libero, pretium";
Title3 "Nec Ultricies sed, Report";
Title4 "for 2021*";
Title5 " ";
Title6 "*The following tristique non nulla did not transmit information on their populations using the instrument developed per In at luctus leo, therefore their contributions can not be represented in statistics above. For these vitae volutpat mauris, only the Suspendisse vestibulum finibus population is provided. These counts are omitted from the total, but not the grand total:";
Title7 "Commodo Nulla Sagittis Ligula Quis Vestibulum Vehicula";
proc report data=sashelp.CARS(OBS=50) style(header)=[background=lightgray Font_Weight=Bold] ;
Column Make Model Type Invoice EngineSize Cylinders Horsepower MPG_City MPG_Highway Weight;
run;
title;
ODS document close;
/*New EG Node*/
ODS document name=excel(UPDATE) DIR=(PATH=\Table_3);
title "Table 3";
title2 "&ReportMonthYear Nunc Sed Malesuada Sapien";
option missing=" ";
proc report data=SASHELP.PRDSAL3(OBS=35) style(header)=[background=lightgray Font_Weight=Bold];
Column COUNTRY STATE COUNTY ACTUAL PREDICT PRODTYPE PRODUCT YEAR;
run;
title;
ODS document close;
/*New EG Node*/
title;footnote;*<--- this title should work;
ODS document name=excel(UPDATE) DIR=(PATH=\Table_3\Caveats);
data _NULL_;
if 0 then set SAShelp.Holiday nobs=n;
if n>1
then line="Proin id turpis sit amet neque bibendum rhoncus. Donec elementum convallis quam quis faucibus noted below:";
else line="";
call symput("TABL_3_NR_Occs_Caveat",line);
stop;
run;
proc ODStext;
p "Table 3 Caveats"/style=systemTitle;
p " ";
p "Donec pharetra risus sit amet dolor dignissim, vitae luctus lectus lacinia. Vivamus pellentesque facilisis nisi et rhoncus. ";
p "";
p "Donec Odio Tellus Maximus Vel Turpis Vitae Mattis";
p "";
p "&TABL_3_NR_Occs_Caveat";
run;
title;
proc print data=SAShelp.Holiday(OBS=7) NoObs;
var name desc;
run;
ODS document close;
/*New EG Node*/
options fmterr;
title;footnote;
ODS Excel
options(
embedded_titles='ON'
embedded_footnotes='ON'
sheet_interval='NONE'
/*--------*/
Frozen_Headers="8"
SHEET_NAME="Tbl1"
);
proc document name=excel ;
replay \Table_1#1\Report#1\Report#1\Report#1;
run;
ODS Excel options (
sheet_interval='NOW'
Frozen_Headers="9"
SHEET_NAME="Tbl2"
);
proc document name=excel ;
replay \Table_2#1\Report#1\Report#1\Report#1;
run;
ODS Excel options (
sheet_interval='NOW'
Frozen_Headers="4"
SHEET_NAME="Tbl3a"
);
proc document name=excel ;
replay \Table_3#1\Report#1\Report#1\Report#1;
run;
ODS Excel options (
sheet_interval='NOW'
Frozen_Headers="0"
SHEET_NAME="Tbl3b"
);
proc document name=excel ;
replay \Table_3#1\Caveats#1;
run;
ODS Excel close;
... View more
