BookmarkSubscribeRSS Feed
Andre
Obsidian | Level 7
In an annual production process of both pdf and excel files, i encounter some problems when in my code i use some ods sas facilities like
[pre]
1 ='Mineur^{super(6)}'
5='Carte^n "Vie privée ^n& familiale"'
12='Régulari ^n sation' or in another format
327,331,323,322,397,324,399,328,330,326,333,335,344,341,337,336,345=' Pays anciennement^n sous administration^n française^{super(4)}'
[/pre]
for a sentence/word cut in various header cells in a few proc tabulates.


In ods pdf is the result perfect.
[pre] [/pre]
With the tagsets 1.86, this kind of code produces xml files "Not well formed"
with errors like
^n is becoming ;
^{super(4) is becoming a tag B xmlns="http://www.w3.org/TR/REC-html40" followed by a inserted tag (where i have suppress the S to make it readable as we are in html) (4) but the constructed lines are false formed
[pre]


Pays anciennement
sous administration française (4)

[/pre]
in place of a well formed line like this one of another section
[pre]

Autres pays africains here without subscript
[/pre]

The same is encounter with tagsets 1.70 but just before i received from E.G. a tagset
(SAS 9.1.3, v1.38, 07/11/06) which was accepting those difficulties and ignoring them
with a call with those options
options(embedded_titles='yes' embedded_footnotes='yes' orientation='landscape').
[pre] [/pre]
As i am sorry about the non acceptance of my peculiar code with the tagsets since 1.70, my GENERAL question is
1) was this pass beyound with a recent option i am not aware of
2) in which text of E.G. or from his team are those limits mentionned
[pre] [/pre]
In practice, i am using the old tagset and the fact that superscript are disapearing
is acceptable
[pre] [/pre]
Andre
1 REPLY 1
Eric_SAS
SAS Employee
Hello Andre,

The newer versions of the Excel tagset do support superscript. version 1.86 is available on
the web at http://support.sas.com/rnd/base/ods/odsmarkup/

Also, I have an even newer version that I can send you directly if you send me an email directly at Eric.Gebhart@sas.com

It is a more recent version that has just not made it onto the web page yet.

Eric

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 1180 views
  • 0 likes
  • 2 in conversation