Dear SAS Community,
I have 3 character variables that I would like to concatenate, but prior to doing that, I want to sort them. My original dataset is id, v1, v2, v3. I would like to create the new variables concat_unsort and concat_sort below. I tried using the "smallest" function, but it tried to change my character variables into a numeric.
I'd appreciate your help.
Thanks,
Brent Fulton
UC Berkeley
data
id v1 v2 v3 concat_unsort concat_sort
1 aa bb cc aabbcc aabbcc
2 aa cc bb aaccbb aabbcc
3 01 02 03 010203 010203
4 01 03 02 010302 010203
sometimes v1...v3 may contain both letters and numbers e.g., a1
Call sortc()
Call sortc()
Thank you, Peter, that worked well.
-Brent
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.