While using this solution with ODS Excel, the title and footnote is not printing out. They are showing in the Results window but not to the output file. Also, If I use more than 1 title and footnote, the resultant file gets corrupted. options mprint mlogic symbolgen;
%macro dummyprint(dsname);
proc sql noprint;
select count(*) into : reccount
from &dsname.;
quit;
%let reccount = %sysfunc(coalescec(&reccount,0));
%if &reccount=0 %then %do;
Proc odstext;
p "No records found";
run;
%end;
%mend;
ods Excel file='c:\temp\CheckScenario4.xls'
options(sheet_name="Tab_Name_here" frozen_headers='5');
data class;
stop;
set sashelp.class;
run;
title1 "Report Name and Place here";
title2 "Report date and time here";
footnote1 j=l "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it?";
footnote2 j=l "Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.";
%dummyprint(class);
Proc Print data=class;
Run;
Ods excel close; Any idea, what is happening here?
... View more