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?
Can you do this in two steps? First concatenate ', ' and then concatenate first_name to the result?
I'm in "new calculated item" field and it keeps telling me that "catx" is an unknown function?
Can you do this in two steps? First concatenate ', ' and then concatenate first_name to the result?
That totally worked! Thank you!!
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 Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Save $200 when you sign up by March 14!
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.