Concatenate First and Last name

[Tihannah]

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?

[Jagadishkatam]

try the catx function as below

catx(' , ', first,last);

[Tihannah]

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

[Jagadishkatam]

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.

[Tihannah]

I'm in SAS VA?

[Astounding · Accepted solution]

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

[Tihannah]

That totally worked! Thank you!!

[AnnaBrown]

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