BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
2 REPLIES 2
Chevell_sas
SAS Employee
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

<---------------------
deleted_user
Not applicable
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 772 views
  • 0 likes
  • 2 in conversation