How to extract a string up till last numeric component?

[Feyng819]

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

[SASJedi]

Try SUBSTR with ANYDIGIT:

data _null_;
	string="abcdef123ghi";
	want=substr(string,1,anydigit(string,-9999));
	put string= want=;
run;

https://go.documentation.sas.com/doc/en/pgmsascdc/v_048/lefunctionsref/p0gq8bwobt4wjgn12km94wi66mxw....