Dear Sir Madam I have a problem. I am using ODS Tagsets.excelxp to export into excel.(XLS file) I am not able to see the footnote in the excel file. Why?
data tbl1;
input ID Y w;
cards;
1 50 1000.5
2 30 2000.1
3 100 3000.2
4 5 4000
5 15 5000
;
run;
PROC SQL;
create table tbl2 as
select sum( Y) as Total_Y
from tbl1
;
QUIT;
PROC SQL;
create table tbl3 as
select ID ,Y,w format=comma12., Y/Total_Y as PCT format=percent9.
from tbl1,tbl2
;
QUIT;
ods path work.temptemp(update) sasuser.templat(update)
sashelp.tmplmst(read);
ods path show;
ods tagsets.excelxp file="/My path /example.xls"
style=htmlblue
OPTIONS( absolute_column_width="17,20,7,9,9,9,11,13,11,11,11"
autofit_heights='yes'
embedded_titles='yes'
embedded_footnotes="yes"
sheet_interval="NONE" );
title1 'report1';
footnote1 'Data from 2018';
PROC REPORT data=tbl3 NOWD split='~';
columns _ALL_;
define _ALL_/display;
run;
Title;
ods tagsets.excelxp close;
ods _all_ close;
... View more
