topic Re: Numerical Digits between spaces in SAS Enterprise Guide

Numerical Digits between spaces

raafat — Wed, 06 Dec 2017 07:47:13 GMT

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.

Re: Numerical Digits between spaces

error_prone — Wed, 06 Dec 2017 09:15:23 GMT

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.

Re: Numerical Digits between spaces

RW9 — Wed, 06 Dec 2017 09:19:54 GMT

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