wrap text in text string

[jenim514]

Hi all,

I need advise for how to wrap a text string to a new line before parenthesis:

Variable value looks like this with varying lengths but same value/parenthesis format: 

450 mg (450 mg TDD)

want output to look like this in output:

450 mg

(450 mg TDD)

I remember it is something like ~n but not sure how to use it?

Thanks!

[novinosrin]

data want;
k='450 mg (450 mg TDD)';
var=substr(k,1,index(k,'(')-1);
output;
var=substr(k,index(k,'('));
output;
run;

are you read a raw data or dataset? the above works if you are reading a dataset 

[jenim514]

@novinosrin I'm sorry I need to clarify more 🙂

I don't need two separate observations but rather I need  same line that will wrap to a new line in a report.  

So maybe how can I add the ~n before the '(' ?

k='450 mg ~n (450 mg TDD)';

[Reeza]

Is this for a report? I believe the method varies slightly depending on the output destination, you usually use ODS ESCAPECHAR and then SPLIT as well specified within PROC REPORT statement.

---

@jenim514 wrote:

Hi all,

I need advise for how to wrap a text string to a new line before parenthesis:

Variable value looks like this with varying lengths but same value/parenthesis format: 

450 mg (450 mg TDD)

want output to look like this in output:

450 mg

(450 mg TDD)

I remember it is something like ~n but not sure how to use it?

Thanks!

---

[jenim514]

Ok, I figured it out by just breaking the var into two variables, then inserting the escapechar

trt1= scan(trt01p,1,'(');
if trt01p ^='Placebo' then trt2=substr(trt01p,index(trt01p,'('));
newtrt= catx ('~n',trt1, trt2);

Thanks all!