BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello!

I've tried to update our ExcelXP tagset from v1.53 to v1.86 as described in "Usage Note 32394: Installing and Storing Updated Tagsets for ODS MARKUP".
All I get are many errors stating SYMBOLIC REFERENCE NOT RESOLVED.

Comparing the code of v1.86 with version v1.53 shows that in v1.53 all statements using an & in double-quotation marks or without any marks are hidden from the macro-processor with %NRSTR().

Do I need to edit the code of v1.86 and add the (missing?) %nrstr()?
Or are there any system options I have to set before compiling v1.86?
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
I downloaded and installed the updated ExcelXP tagset at the link below, and had no errors when using it. Also, you referenced a prior version which is not mentioned on the page below.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/rnd/base/ods/odsmarkup/index.html
deleted_user
Not applicable
Hi Scott,
thank you for reply!

I have downloaded the exceltags.tpl (again) and submitted it using %include ...
and it worked!
The newly downloaded file displays on Windows like a UNIX-file: all lines merged together no CR/LF at eol. The previous file for v1.86 displayed 'correctly' in notepad but didn't work. strange.
Perhaps some infos lost during 'translation' - but it works now and that's it.

Thank you again.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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