topic Re: Concatenate First and Last name in SAS Visual Analytics

Concatenate First and Last name

Tihannah — Wed, 05 Apr 2017 15:50:21 GMT

Hi,

Am just trying to concatenate first and last name in the following format:

Doe, Jane

Simple concatenate keeps giving me DoeJane. How do I insert the comma and space?

Re: Concatenate First and Last name

Jagadishkatam — Wed, 05 Apr 2017 15:57:23 GMT

try the catx function as below

catx(' , ', first,last);

Re: Concatenate First and Last name

Tihannah — Wed, 05 Apr 2017 15:57:59 GMT

I'm in "new calculated item" field and it keeps telling me that "catx" is an unknown function?

Re: Concatenate First and Last name

Jagadishkatam — Wed, 05 Apr 2017 16:02:32 GMT

ok Sorry, this is a base sas function I mentioned. I am not familiar with BI, however somebody with BI would respond and provide the solution.

Re: Concatenate First and Last name

Tihannah — Wed, 05 Apr 2017 16:03:50 GMT

I'm in SAS VA?

Re: Concatenate First and Last name

Astounding — Wed, 05 Apr 2017 16:41:14 GMT

Can you do this in two steps? First concatenate ', ' and then concatenate first_name to the result?

Re: Concatenate First and Last name

Tihannah — Wed, 05 Apr 2017 16:45:49 GMT

That totally worked! Thank you!!

Re: Concatenate First and Last name

AnnaBrown — Fri, 07 Apr 2017 14:05:05 GMT

I'm glad you found the solution, Tihannah! If one of the replies was the exact solution to your problem, can you "Accept it as a solution"? Or if one was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!
Anna