## Numerical Digits between spaces

Solved
Occasional Contributor
Posts: 12

# Numerical Digits between spaces

[ Edited ]

Hi Guys . I am only interested in the underlined digits. I have tried with the compress and substr but no luck.

Example of data;

P2Pb 430 041017
P2P 10538 030517 DIBS
P2P 496 01092017
P2P 2594 01112016

Accepted Solutions
Solution
‎12-06-2017 10:34 AM
Super User
Posts: 9,441

## Re: Numerical Digits between spaces

[ Edited ]
```data want;
set have;
want=input(scan(thedata,2," "),best.);
run;```

Note I assume your data is called have and the variable is thedata.

Post test data in the form of a datastep in the post using a code window, we cannot guess!!!!

All Replies
Regular Contributor
Posts: 204

## Re: Numerical Digits between spaces

Please post the code you tried, so that it is easier to suggest corrections. You can use the scan-function to get the second part of the string, then use the input-function to convert the extract to a number.

Solution
‎12-06-2017 10:34 AM
Super User
Posts: 9,441

## Re: Numerical Digits between spaces

[ Edited ]
```data want;
set have;
want=input(scan(thedata,2," "),best.);
run;```

Note I assume your data is called have and the variable is thedata.

Post test data in the form of a datastep in the post using a code window, we cannot guess!!!!

☑ This topic is solved.