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


Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 11048 views
  • 3 likes
  • 4 in conversation