INSERT NEW LINE IN RTF

[saslove]

Hello,

I have this code to put the data I need separated by a comma. Now, what I need is a new line after the comma.

Currently, I have this

1 due to symptom1,2 due to symptom2,1 due to symptom3,3 due to symptom4,1 due to symptom5, 1 due to symptom6, and so on.. 

What I need is 

1 due to symptom1,

2 due to symptom12,

1 due to symptom3,

3 due to symptom4,

1 due to symptom5,

1 due to symptom6,

 and so on.. 

My code :

data want;
length cat $10000;
do until (last.death_onstudy);
set freqs;
by death_onstudy notsorted;
cat=catx(',',cat,death_reason);
end;
run;

Please help get each symptom to a new line. Thanks very much in advance!!!

[ChrisNZ]

You can use something like

CAT=catx(','||'0D0A'x, CAT DEATH_REASON);

Where it gets used depends on the output.

You won't see the LF in an HTML report for example.

[saslove]

Adding the '0D0A'x didn't work for me. I am creating rtf destination, but its all in one big line separated by commas. It doesn't add a line after commas. 

[ChrisNZ]

If you use proc report, you can insert RTF codes with the ~R prefix.

See here.

[ChrisNZ]

For example:

data T; 
  A=catx(','||'0d0a'x , 'ABC', 'DEF'); 
run;

[Tom]

A new line WHERE?  Your code seems to be just creating a character strings, not a report.

[saslove]

I need to use it in an ODS RTF destination.

[novinosrin]

data have;
str='1 due to symptom1,2 due to symptom2,1 due to symptom3,3 due to symptom4,1 due to symptom5, 1 due to symptom6';
run;

data want;
set have;
do _n_=1 to countw(str,',');
want=cats(scan(str,_n_,','),',');
output;
end;
run;

[saslove]

Thanks, I need it in the same cell. This puts a new row for each line, but I need everything in one cell. 

[Cynthia_sas]

Hi:

  ODS RTF supports the ESCAPECHAR and the {newline} function. In the example below, I declared my ESCAPECHAR to be caret ^, as shown in the code and it produced the same output in both PROC PRINT and PROC REPORT.

Hope this helps,

Cynthia

[ChrisNZ]

@Cynthia_sas I tried escaping a new line but never found the correct syntax.

I tried \line and \par and even unicode values.

It turns out {newline} does it. 

It's not easy finding the proper syntax.

Like the unicode implementation (and here)  I find this confusing.

[saslove · Accepted solution]

Solution that worked for me:

I used ods escapechar='^';

I added ^n where I want my line break. It doesn't show in the listing or dataset but t works on the rtf file and html file. 

 cat=catx(',^n',cat,death_reason);

[Cynthia_sas]

Hi:
That use of newline ^n is older code which has been replaced by the function-like syntax I showed in my post.
It may be that someday the use of the older ^n will no longer work, so I'd recommend to eventually move to ^{newline 1} so your code is current.
Cynthia

[saslove]

Perfect! I just changed my code to ^newline. Thanks so much.