topic Check if first character in the string can be numeric, then convert them in SAS Programming

Check if first character in the string can be numeric, then convert them

vietlinh12hoa — Thu, 20 May 2021 08:46:26 GMT

I have 2 strings string 1 = '1st' and string 2 = 'Super'

I want to have new variable to check if the first character is numeric then convert to number, else empty, like:

new string 1 = 1

new string 2 = .

In Python it's super easy, not sure how to do that in this programming style.

FreelanceReinh — Thu, 20 May 2021 08:54:54 GMT

Try this:

data have;
input string $;
cards;
1st
Super
;

data want;
set have;
number=input(string, ?? 1.);
run;

vietlinh12hoa — Thu, 20 May 2021 08:58:00 GMT

Thanks a lot.