Numerical Digits between spaces

[raafat]

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

thanks in advance.

[error_prone]

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.

[RW9 · Accepted solution]

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!!!!