https://communities.sas.com/t5/SAS-Programming/How-to-extract-a-string-up-till-last-numeric-component/m-p/919991#M362351 Let’s say I have an alphanumeric string of “abcdef123ghi”, how can I extract and get up till the last digit of the string “abcdef123”? I was trying to find the location of the last digit using find and reverse, and use substr to extract it but it doesn’t work. Thanks for your help in advance Tue, 12 Mar 2024 19:02:53 GMT Feyng819 2024-03-12T19:02:53Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-a-string-up-till-last-numeric-component/m-p/919991#M362351 Let’s say I have an alphanumeric string of “abcdef123ghi”, how can I extract and get up till the last digit of the string “abcdef123”? I was trying to find the location of the last digit using find and reverse, and use substr to extract it but it doesn’t work. Thanks for your help in advance Tue, 12 Mar 2024 19:02:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-a-string-up-till-last-numeric-component/m-p/919991#M362351 Feyng819 2024-03-12T19:02:53Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-a-string-up-till-last-numeric-component/m-p/919997#M362355 <P>Try SUBSTR with <A href="https://go.documentation.sas.com/doc/en/pgmsascdc/v_048/lefunctionsref/p0gq8bwobt4wjgn12km94wi66mxw.htm" target="_self">ANYDIGIT:</A></P> <PRE><CODE class=" language-sas">data _null_; string="abcdef123ghi"; want=substr(string,1,anydigit(string,-9999)); put string= want=; run;</CODE></PRE> <P><A href="https://go.documentation.sas.com/doc/en/pgmsascdc/v_048/lefunctionsref/p0gq8bwobt4wjgn12km94wi66mxw.htm" target="_self">https://go.documentation.sas.com/doc/en/pgmsascdc/v_048/lefunctionsref/p0gq8bwobt4wjgn12km94wi66mxw.htm</A>&nbsp;&nbsp;</P> Tue, 12 Mar 2024 19:22:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-a-string-up-till-last-numeric-component/m-p/919997#M362355 SASJedi 2024-03-12T19:22:29Z