topic Re: text of variable wrapping to next line - any reason in SAS Programming

text of variable wrapping to next line - any reason

vraj1 — Thu, 22 Mar 2018 14:11:25 GMT

I have a variable and the text of it looks fine if i look

Randomisation:Parallel or cross-over?

But if i copy that variable and paste it wraps to next line and not sure the reason and it only happens to 1 value of the variable

Randomisation:
Parallel or cross-over?

Tried reducing length but no use. any clue why it happens

Re: text of variable wrapping to next line - any reason

gamotte — Thu, 22 Mar 2018 14:24:31 GMT

Hello,

Where do you copy your text from and where do you paste it ?

Re: text of variable wrapping to next line - any reason

vraj1 — Thu, 22 Mar 2018 14:25:54 GMT

It is imported from excel and it was done "Alt tab" to make it to next line and this is causing problem

data WORK.TEST;
  infile datalines dsd truncover;
  input _NAME_:$8. _LABEL_:$40. COL1:$1024. COL2:$1024.;
datalines4;
F1,F1,Trial,ID
F2,F2,,Trial name
F3,F3,,Sources
F4,F4,,Primary publication
F5,F5,,Trial number
F6,F6,Trial design,Objective
F7,F7,,Randomisation:
Parallel or cross-over?
F8,F8,,Setting

Re: text of variable wrapping to next line - any reason

gamotte — Thu, 22 Mar 2018 14:37:05 GMT

Do you mean that "Alt-enter" was used in excel to introduce a line break in the cell value ?

If so, it is normal that the pasted text contains a line break.

Your question does not seem to concern SAS language or software.

Re: text of variable wrapping to next line - any reason

vraj1 — Thu, 22 Mar 2018 14:40:32 GMT

My concern is i was trying it to make it strip but cannot do it, used compress and strip.

What needs to be done to strip it?

Re: text of variable wrapping to next line - any reason

gamotte — Thu, 22 Mar 2018 14:58:26 GMT

Use compress with the hex code for linefeed.

coll=compress(coll,'0A'x);