Number Extraction from Character Column in SAS EG

[sivastat08]

Hi , wherever the Number(lessthen five count),Characters and Special Character are availabel then that should be return as "0" and only numbers count greaterthen or equal to 5 then that should return as "1 in sas EG.Kindly help.

have	Length	want
123456	6	1
1234567	7	1
12345678	8	1
123456789	9	1
110ask-	7	0
_wertn	6	0
gst	3	0
123	3	0
1526	4	0
12356	5	1

Thanks,

Siva

[gamotte · Accepted solution]

Hello,

data have;
	input x $9.;
	drop toNum;

	toNum=input(x, ? 9.);

	if toNum>9999 and strip(put(toNum,9.))=strip(x) then y=1;
	else y=0;

	cards;
123456
1234567
12345678
123456789
110ask-
_wertn
gst
123
1526
12356
;
run;

[sivastat08]

Thank you Gamotte

[Kurt_Bremser]

if notdigit(substr(have,1,length(have))) ne 0 or length(have) < 5
then want = 0;
else want = 1;

[sivastat08]

Thanks Sir.

[Ksharp]

data have;
	input x $9.;
length=length(x);
if length ge 5 and notdigit(strip(x))=0 then flag=1;
 else flag=0;
	cards;
123456
1234567
12345678
123456789
110ask-
_wertn
gst
123
1526
12356
;
run;

[sivastat08]

Thanks Ksharp