topic Split variable into multiple columns in New SAS User

Split variable into multiple columns

SASPhile — Thu, 26 Sep 2019 23:28:16 GMT

How to split raw_variable into multiple variables of lengths 20 and not to break a word.

i.e in below example "acerbic soluable dio" is not the way to split it. dioxide;zinc goes to other variable and so on.

raw_variable
acerbic soluable dioxide;zinc titanium

Raw_var1 Raw_Var2 Raw_var3
acerbic soluable dioxide;zinc titanium

Thanks for the help!

Patrick — Fri, 27 Sep 2019 02:08:57 GMT

It would be simpler to split up your string into single words. One could then still concatenate the words back into strings of up to 20 characters.

If re-concatenating words: Do you really need the semicolon in Raw_Var2 or could we just add a blank here?

What should happen if a single word has more than 20 characters?

SASPhile — Fri, 27 Sep 2019 14:02:57 GMT

In fact the delimiters are semi-colons. So they are required.

acerbic;soluable;carbon dioxide