topic Re: Extract only the first numeric value from string with mutliple numeric occurence in SAS Procedures

Extract only the first numeric value from string with mutliple numeric occurence

nicolaskan — Tue, 04 Sep 2018 03:59:24 GMT

Hi guys,

May i know if there are any simple way to extract first numeric digit in a string with mix of number and string?

Example:

Column: Text1

Value of Text1: "2 times in 1 week"

Expected Output: 2

I have tried to use the following script yet it combines two numeric value:

Output_value = COMPRESS(SCAN(Text1,1),"abcdefghijklmnopqrstuvwxyz`~*!@#$%^*()-_=+\|[]{};:',.<>?/ " , "i");

=> Output: 21 (i.e. I would like to extract 2 only)

May i know if anyone can help?

Thanks a lot.

Re: Extract only the first numeric value from string with mutliple numeric occurence

novinosrin — Tue, 04 Sep 2018 04:02:04 GMT

data want;

set have;

want=char(var,anydigit(var));

run;

Re: Extract only the first numeric value from string with mutliple numeric occurence

nicolaskan — Tue, 04 Sep 2018 04:04:48 GMT

Thanks for the quick reply.

however, it doesn't solve the case like

"10 times in 1 week"

=> it will output 1 instead of 10 in this case.

Any idea?

Re: Extract only the first numeric value from string with mutliple numeric occurence

novinosrin — Tue, 04 Sep 2018 04:08:12 GMT

sorry my fault. brb

Re: Extract only the first numeric value from string with mutliple numeric occurence

novinosrin — Tue, 04 Sep 2018 04:15:36 GMT

my sincere apologies for the lack of attention to detail

data w;
k='"10 times in 1 week"';
want=scan(compress(k,' ','kd'),1);
run;

Re: Extract only the first numeric value from string with mutliple numeric occurence

nicolaskan — Tue, 04 Sep 2018 05:02:30 GMT

Many thanks for the advice.

Some complicated situation as follows couldn't be solved.

Any advice?

"1-2 times in 1 week"

Expected Output:1

Using the above code: 12

Re: Extract only the first numeric value from string with mutliple numeric occurence

novinosrin — Tue, 04 Sep 2018 05:08:29 GMT

data w;
k='1-2 times in 1 week';
want=scan(compress(k,'  -','kd'),1);
run;

better is to apply regex though using prx functions

Re: Extract only the first numeric value from string with mutliple numeric occurence

novinosrin — Tue, 04 Sep 2018 05:24:01 GMT

data w;
k='1-2 times in 1 week';
want=scan(compress(k,' ','kdp'),1);
run;

Re: Extract only the first numeric value from string with mutliple numeric occurence

nicolaskan — Tue, 04 Sep 2018 05:59:38 GMT

Thanks a lot for the valuable advice.

It helps.