Solved
Contributor
Posts: 70

# Number Extraction from Character Column in SAS EG

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

Accepted Solutions
Solution
‎03-27-2017 06:43 AM
Super Contributor
Posts: 340

## Re: Number Extraction from Character Column in SAS EG

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
_wertn
gst
123
1526
12356
;
run;``````

All Replies
Solution
‎03-27-2017 06:43 AM
Super Contributor
Posts: 340

## Re: Number Extraction from Character Column in SAS EG

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
_wertn
gst
123
1526
12356
;
run;``````
Contributor
Posts: 70

## Re: Number Extraction from Character Column in SAS EG

Thank you Gamotte
Super User
Posts: 10,237

## Re: Number Extraction from Character Column in SAS EG

``````if notdigit(substr(have,1,length(have))) ne 0 or length(have) < 5
then want = 0;
else want = 1;``````
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 70

Thanks Sir.
Super User
Posts: 10,778

## Re: Number Extraction from Character Column in SAS EG

```
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
_wertn
gst
123
1526
12356
;
run;

```
Contributor
Posts: 70

## Re: Number Extraction from Character Column in SAS EG

Thanks Ksharp
☑ This topic is solved.