DATA Step, Macro, Functions and more

Disappearing percent sign in RTF column title

Reply
Respected Advisor
Posts: 4,659

Disappearing percent sign in RTF column title

Hi,

Can somebody tell me what happens to my percent character in the column title produced by:
 
data test; x=0.1; run;

ods rtf file="&sasforum.\Reports\test percent.rtf" style=journal;


proc sql;
select x label='% Detected' format=percentn7.1
from test;
quit;

 
ods rtf close;

Percent Column Title.PNG

PG

PG
Super User
Posts: 10,548

Re: Disappearing percent sign in RTF column title

Don't know why the RTF generator eats it but try '\% Detected'. I think the \ acts as an RTF escape character.

My guess is the % at the start of a string indicates some kind of predicate or code otherwise.

Respected Advisor
Posts: 4,659

Re: Disappearing percent sign in RTF column title

Thanks , I finally found it in the Doc. I thought that you could use anything as a label in SQL. Not so! There are rules:

A label can begin with the following characters: a through z, A through Z, 0 through 9, an underscore (_), or a blank space. If you begin a label with any other character, such as pound sign (#), then that character is used as a split character and it splits the label onto the next line wherever it appears. For example: select dropout label= '#Percentage of#Students Who#Dropped Out' from educ(obs=5);

If a special character must appear as the first character in the output, then precede it with a space or a forward slash (/).

So, my percent sign was used as a split character, which is why it was ignored.

PG

PG
Ask a Question
Discussion stats
  • 2 replies
  • 332 views
  • 0 likes
  • 2 in conversation