topic Re: wrap text in text string in ODS and Base Reporting

wrap text in text string

jenim514 — Wed, 16 May 2018 20:05:51 GMT

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!

Re: wrap text in text string

novinosrin — Wed, 16 May 2018 20:14:01 GMT

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

Re: wrap text in text string

Reeza — Wed, 16 May 2018 20:22:08 GMT

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!

Re: wrap text in text string

jenim514 — Wed, 16 May 2018 20:24:40 GMT

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

Re: wrap text in text string

jenim514 — Wed, 16 May 2018 20:40:09 GMT

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!