BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Felix_
Obsidian | Level 7

Hi Community,

I modified a product ID in a dataset following if a Special condition is true:

num_extend = CATT("°", num);

So in the dataset there are num:extends like this:

 

 

°1234

2345

3456

°4567

...

When i print a table on a RTF file it generates following:

pic3.PNG

 

Is there an Option preventing this?

 

Thank you in advance & best regards,

Felix

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26
Link was broken for me...here's the link that worked:
http://www2.sas.com/proceedings/forum2007/099-2007.pdf

cynthia

View solution in original post

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Avoid using that at all, just add a superscript element:

data ...;
  num_extend=cats('^super{o}',num);
run;

ods escaechar="^";

proc report data=...
run;

That should put a small o before it, or you could put out the specfic character using escape codes.  The problem I see is that you have a special character in your code, writing to a text file, then read by Word and processed.  Any of those processes could either change or not understand that symbol.

Felix_
Obsidian | Level 7

Thank you for the Suggestion. Unfortunately this is even worse.

 

In the RTF Output it Shows following:

 

supero1234

super2345

super3456

supero5678

 

... maybe i have to take just another Symbol to indicate the numbers.

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Sorry, got the bracket in the wrong place, should be:

data ...;
  num_extend=cats('^{super o}',num);
run;

ods escaechar="^";

proc report data=...
run;

You can find out about this in the paper:

http://www2.sas.com/proceedings/forum2007/099-2007.pdf 

Cynthia_sas
Diamond | Level 26
Link was broken for me...here's the link that worked:
http://www2.sas.com/proceedings/forum2007/099-2007.pdf

cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 4 replies
  • 1577 views
  • 1 like
  • 3 in conversation