cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
weijiawang
‎10-07-2020
  • 4 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Sort a string that includes both character and numeric code

by Fluorite | Level 6 in SAS Programming
‎09-14-2020 11:49 AM
‎09-14-2020 11:49 AM
Hi, Tom   Currently, all my values are combination of 'one alphabet'+'4 digits'. The above code is working, except that SAS is equalling 'J9000' and 'J9070': sometimes I get results J9000,j9070. Other times, I get results J9070,J9000.   So, I believe the problem is in "CALL SORTC": it is not correctly sorting the 4 digits.  Do you have a possible solution?   Thanks ... View more

Re: Sort a string that includes both character and numeric code

by Fluorite | Level 6 in SAS Programming
‎09-14-2020 09:23 AM
‎09-14-2020 09:23 AM
Sorry that I was not clear about the sorting requirement. But here it is.   Using "X1234", I meant that I need to sort on this order: first on alphabet, then on numeric after the alphabet. For example: J0000 should come first, then J0001, then J0002....then Q0001, Q0002....then T0001, T0002.   So, I am not sure if transpose the table will help?   Thank you so much for your help!!! ... View more

Re: Sort a string that includes both character and numeric code

by Fluorite | Level 6 in SAS Programming
‎09-14-2020 09:22 AM
‎09-14-2020 09:22 AM
Using "X1234", I meant that I need to sort on this order: first on alphabet, then on numeric after the alphabet. For example: J0000 should come first, then J0001, then J0002....then Q0001, Q0002....then T0001, T0002.   Thank you so much for your help!!! ... View more

Sort a string that includes both character and numeric code

by Fluorite | Level 6 in SAS Programming
‎09-10-2020 01:55 PM
‎09-10-2020 01:55 PM
Hi, I have a dataset like this: id regimen 1 J0000, J0001, J2000 2 J0000, J0001, J2000, J1345 3 J2000, J1345, Q1111 4 J2000, Q1111, J1345, Q1112   How can I sort each line, base on alphabet and numeric order? The result be like: 1 J0000, J0001, J2000 2 J0000, J0001, J1345, J2000 3 J1345, J2000, Q1111 4 J1345, J2000, Q1111, Q1112   I have a code like this: DATA XX; SET XX; LENGTH newname $100; ARRAY t(100) $ _TEMPORARY_; CALL MISSING(OF t(*)); DO _N_=1 to LENGTH(STRIP(regimen)); t(_N_)=CHAR(regimen,_N_); END; CALL SORTC(of t(*)); newname=CATS(of t(*)); RUN; But above code will combine by line all character and numeric together, while I still need the code to be ordered by X1234.   Thanks smart people!!! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-07-2020 03:00 PM
Likes given to
View All
Quick links