The SAS Output Delivery System and reporting techniques

Embedded_Footnotes='Yes' option in tagsets.ExcelXP not working?

Reply
N/A
Posts: 0

Embedded_Footnotes='Yes' option in tagsets.ExcelXP not working?

Hey there...

SAS seems to handle the option fine, but when I try to open up the file I get an error message. If I remove this option and then run the same program, I can open the file just fine.

Anybody else experiencing this?

Thanks,
D.
SAS Employee
Posts: 88

Re: Embedded_Footnotes='Yes' option in tagsets.ExcelXP not working?

The problem here is that we are adding a footer tag in the style section when you specify this H=2 option on the footnote statement. The below duplicates the problem. I will follow-up further on the tracking entry that is currently open.

ods tagsets.excelxp file="temp1.xls" options(embedded_footnotes="yes");

proc print data=sashelp.class;
title1 h=4 "US Corporate Banking";
title2 h=4 "Profitability Analysis by Product Group";
title3 h=4 "Q2 2006 Qtr Results (000's) USD";
title4 h=3 "Based on Economic Equity Model";
footnote h=2 "Version: 20060615";
run;

ods tagsets.excelxp close;


SAS Institute Inc. http://www.sas.com
9.01.01M3P02022006

<---------------------
N/A
Posts: 0

Re: Embedded_Footnotes='Yes' option in tagsets.ExcelXP not working?

was there a resolution to the original issue ?

A feature-ette is surfacing for footnotes with excelXP.
The embedded footnotes are appearing just once
(as I presume they should accoding to my request embed_titles_once='yes' )

However, rather than appearing like "end notes" - at the end, they are appearing after the first proc print by-group SUM lines (where I expect a page break would have occurred in other destinations)

I experience this on excelXP v1.70.
Is it the same on the latest version?

PeterC
Ask a Question
Discussion stats
  • 2 replies
  • 140 views
  • 0 likes
  • 2 in conversation