topic Re: Create Line Feed in SAS Programming

Create Line Feed

Satish_Parida — Fri, 05 Oct 2018 13:24:19 GMT

Hi Experts,

I am trying to substitute line feed to my character variable, in place of a pattern. I have used following attempts.

translate(TRIM(Itemdata_Value),'0a'x,'XXXXXXXXX');
1. Issue: It is creating both line feed and carriage return for some reason. i.e 2 line breaks, where I want one.
prxchange("s/XXXXXXXXX/\n/", -1, Itemdata_Value);
1. It simply replaced XXXXXXXX with text /n, not new line

Please help.

Ref:

https://communities.sas.com/t5/SAS-Procedures/SAS-new-line-symbol-character-code/td-p/27843

Re: Create Line Feed

RW9 — Fri, 05 Oct 2018 13:28:16 GMT

Use:

itemdata_value=tranwrd(itemdata_value,"XXXXXXXX",'0a'x);

Re: Create Line Feed

Satish_Parida — Fri, 05 Oct 2018 13:33:45 GMT

This worked,Thank you, but it is very strange the translate did not work and /n character did not resolve to new line.
If any one can clarify in this thread, then it may help someone in future.

Re: Create Line Feed

RW9 — Fri, 05 Oct 2018 13:37:12 GMT

Translate replaces characters from the list with equivalent characters from the replace list, not the whole word. Tranwrd is the tool for replacing a whole text string with something else. Per the manual:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000215153.htm

The prx is simply replacing the text string with the text string /n as you say, and that is correct. The /n means newline in some file formats,much like ^{newline} can be used in rtf code. Therefore the code is working, but your output renderer (rtf, pdf etc.) is either not setup to use the /n syntax, or its not valid for that renderer.