How to concatenate two text columns into a single column?

jonesj22 — Wed, 15 Jan 2020 21:32:59 GMT

Hello,

I am trying to run some text analytics in SAS Enterprise Miner. I have a dataset with about a dozen different text variables that I would like to analyze, as well as target variable. I would like to concatenate all individual text variables into one single variable and then run that through a parsing node, and so on. I have tried doing this in Enterprise Guide but there's some sort of character limit that is cutting off my string when I concatenate them all together. So, I thought I'd export my dataset into Miner then concatenate them there, but am unsure how to do that. I thought the right move was to use the merge node, but I clearly haven't figured it out yet since no new concatenated variable with all my strings is being exported from the node.

Essentially, I am trying to turn this:

Target var_1 var_2 var_3

1 "text1 " "text2 " "text3 "

0 "text4 " "text5 " "text6 "

0 "text7 " "text8 " "text9 "

into this:

Target all_text

1 "text1 text2 text3 "

0 "text4 text5 text6 "

0 "text7 text8 text9 "

Can anyone help me achieve this? Thank you!

Re: How to concatenate two text columns into a single column?

Reeza — Wed, 15 Jan 2020 21:39:24 GMT

SHould work fine in EG just make sure to set the length of hte variable ahead of time.

data want;
set have;
length new_col $2000.;

new_col = catx(" ", of var_1-var_3);

run;

Re: How to concatenate two text columns into a single column?

jonesj22 — Fri, 17 Jan 2020 15:03:59 GMT

Yep, this did the trick. Cheers!

topic Re: How to concatenate two text columns into a single column? in SAS Data Science

How to concatenate two text columns into a single column?

Re: How to concatenate two text columns into a single column?

Re: How to concatenate two text columns into a single column?