topic Re: ods tagsets.excelxp issue in SAS Programming

ods tagsets.excelxp issue

anandbillava — Wed, 02 Jul 2025 01:42:27 GMT

I have used ods tagsets.excelxp lot of times and never had any issues. But recently I am using it in a new instance of SAS and following things are not working. I have used similar code in the past and never had issues.

The styles using ods escapechar does not work. e.g. title1 "^S={color=CX5F9EA0} Note #2: URGENT " ;

The hyperlink to other sheets using url option (creating format) is not working

Can you please let me know what could be the issue. Is it something to do with excel or SAS version. I am using SAS 9.4 M7 Version (windows).

Re: ods tagsets.excelxp issue

Tom — Wed, 02 Jul 2025 02:16:37 GMT

Did you set the ODS ESCAPECHAR to ^ ?

Also I believe that method is deprecated and you should probably be using the newer syntax, which I believe involves *ESC* instead of an escape character.

Re: ods tagsets.excelxp issue

Ksharp — Wed, 02 Jul 2025 02:44:35 GMT

Could you use ODS EXCEL to instead of ODS TAGSETS.EXCELXP ?

If you are using TITLE statement, using option LINK= instead of url= style :

title j=l link="#目录!A1"  "(*ESC*)S={textdecoration=underline color=blue }返回目录";

Re: ods tagsets.excelxp issue

anandbillava — Wed, 02 Jul 2025 10:38:43 GMT

I tried that as well. I am trying to create link for column. Used format and also used an example from forum which worked for others. but not working for me. I am suspecting it may be something to do with my SAS and excel.

Re: ods tagsets.excelxp issue

anandbillava — Wed, 02 Jul 2025 10:45:33 GMT

ODS excel has limitation. It cannot create report with large number of records and columns. It throws memory error. Thats a known limitation

Re: ods tagsets.excelxp issue

Kathryn_SAS — Wed, 02 Jul 2025 11:35:53 GMT

I see that you opened a case with Technical Support. Based on that, I would suggest changing the file extension to XML. When I make that change to your code, it works as expected for me.

ods tagsets.excelxp file='try_hyper.xml' style=sasweb
options(sheet_name='Main');

If you continue to have problems, I would also suggest sending your log to the Technical Support case so that we can confirm if you are running the most current version of the tagset.

Re: ods tagsets.excelxp issue

anandbillava — Wed, 02 Jul 2025 11:33:07 GMT

Hi, Can you please remove that folder name from you last post. I accidentally sent it. I try to use that option as well. Created xml, html. No luck so far.

Re: ods tagsets.excelxp issue

anandbillava — Wed, 02 Jul 2025 11:40:40 GMT

I will wait for tech support to respond to my email and then will send the log.