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
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.
Hello,
Where do you copy your text from and where do you paste it ?
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
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.
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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.