10-23-2011 01:11 AM
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.
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
Need further help from the community? Please ask a new question.