BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tihannah
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

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

View solution in original post

7 REPLIES 7
Jagadishkatam
Amethyst | Level 16
try the catx function as below

catx(' , ', first,last);
Thanks,
Jag
Tihannah
Obsidian | Level 7

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

Jagadishkatam
Amethyst | Level 16
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.
Thanks,
Jag
Tihannah
Obsidian | Level 7
I'm in SAS VA?
Astounding
PROC Star

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

Tihannah
Obsidian | Level 7

That totally worked! Thank you!!

AnnaBrown
Community Manager

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

SAS Innovate 2025: Call for Content

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!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 11750 views
  • 3 likes
  • 4 in conversation