topic Re: CATX NEW LINE in SAS Programming

INSERT NEW LINE IN RTF

saslove — Mon, 21 Jan 2019 22:46:41 GMT

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!!!

Re: CATX NEW LINE

ChrisNZ — Mon, 21 Jan 2019 20:33:59 GMT

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.

Re: CATX NEW LINE

Tom — Mon, 21 Jan 2019 20:35:32 GMT

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

Re: CATX NEW LINE

novinosrin — Mon, 21 Jan 2019 20:37:49 GMT


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;

Re: CATX NEW LINE

saslove — Mon, 21 Jan 2019 20:45:21 GMT

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

Re: CATX NEW LINE

saslove — Mon, 21 Jan 2019 20:51:10 GMT

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.

Re: CATX NEW LINE

saslove — Mon, 21 Jan 2019 21:18:20 GMT

I need to use it in an ODS RTF destination.

Re: CATX NEW LINE

ChrisNZ — Mon, 21 Jan 2019 21:19:24 GMT

For example:

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

Re: CATX NEW LINE

ChrisNZ — Mon, 21 Jan 2019 21:36:49 GMT

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

See here.

Re: CATX NEW LINE

Cynthia_sas — Mon, 21 Jan 2019 22:42:45 GMT

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

Re: INSERT NEW LINE IN RTF

saslove — Mon, 21 Jan 2019 22:51:56 GMT

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);

Re: INSERT NEW LINE IN RTF

Cynthia_sas — Mon, 21 Jan 2019 23:13:43 GMT

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

Re: INSERT NEW LINE IN RTF

saslove — Mon, 21 Jan 2019 23:19:03 GMT

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

Re: CATX NEW LINE

ChrisNZ — Thu, 24 Jan 2019 02:39:47 GMT

@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.