topic Re: Extracting Number From the Left Side From String in SAS Data Management

Extracting Number From the Left Side From String

Cyclist — Tue, 14 Jun 2016 07:38:29 GMT

I have a column "House number" which besides numbers contains also something like this "32/2/1" or "Top 211".

The column is defined as TEXT.

My question is: how can I extract only first number from the string such as ""32/2/1"?

(the expression needs to correctly extract the number when only a number stands in the field such as "32").

Ksharp — Tue, 14 Jun 2016 08:11:31 GMT

data _null_;
input x $20.;
want=scan(x,1,,'kd');
put x= want=;
cards;
32/2/1 
Top 211
;
run;

Cyclist — Tue, 14 Jun 2016 08:13:35 GMT

Since I am new to SAS, can you tell me how to use your expression and how to integrate it into my data job?

Ksharp — Tue, 14 Jun 2016 08:56:40 GMT

Are you using DI , BI , EG ? Create a new program and run this code .

Cyclist — Tue, 14 Jun 2016 09:42:26 GMT

I am using Data Management Studio 2.7.