topic Re: Substring/Scan from string in SAS Procedures

Substring/Scan from string

bob021 — Tue, 20 May 2014 13:16:49 GMT

Hi to all

My data:

data have;

input string $40.;

datalines;

33_we#fff23BOB_TS=234623623624756_TOO

BOB_TS=57335623566654756BO

60pBOB_TS=343467364563423TOp_#

WWBOB_TS=2346752665634cc90

9789BOB_TS=9872363566756Alll

ldldBOB_TS=2340235674025634efrwe

;

run;

I want to extract first 10 digits after string 'BOB_TS=' (example: have 60pBOB_TS=343467563423TOp_# want 3434675634 )

Ca somebody help me with this?

Thank you in advance

Bob

Re: Substring/Scan from string

slchen — Tue, 20 May 2014 13:38:55 GMT

data have;
input string $40.;
num=substr(string,index(string,'=')+1,10);
datalines;
33_we#fff23BOB_TS=234623623624756_TOO
BOB_TS=57335623566654756BO
60pBOB_TS=343467364563423TOp_#
WWBOB_TS=2346752665634cc90
9789BOB_TS=9872363566756Alll
ldldBOB_TS=2340235674025634efrwe
;
run;

Re: Substring/Scan from string

bob021 — Tue, 20 May 2014 13:46:09 GMT

Thank you very much slchen

Working like a charm

Bob

Re: Substring/Scan from string

Haikuo — Tue, 20 May 2014 13:48:01 GMT

Using PRX,

data have;

input string $40.;

digits=prxchange('s/(.+)((?<=BOB_TS=)\d{10}?)(.+)/$2/io', 1,string);

datalines;

33_we#fff23BOB_TS=234623623624756_TOO

BOB_TS=57335623566654756BO

60pBOB_TS=343467364563423TOp_#

WWBOB_TS=2346752665634cc90

9789BOB_TS=9872363566756Alll

ldldBOB_TS=2340235674025634efrwe

;

run;

Regards,

Haikuo

Re: Substring/Scan from string

Ksharp — Tue, 20 May 2014 13:50:07 GMT

Backward Match for Peal Regular Expression :

data have;

input string $40.;

re = prxparse('/((?<=BOB_TS=)\d{10})/io');

if prxmatch(re,string) then want= prxposn(re,1,string);

datalines;

33_we#fff23BOB_TS=234623623624756_TOO

BOB_TS=57335623566654756BO

60pBOB_TS=343467364563423TOp_#

WWBOB_TS=2346752665634cc90

9789BOB_TS=9872363566756Alll

ldldBOB_TS=2340235674025634efrwe

;

run;

Xia Keshan

Re: Substring/Scan from string

stat_sas — Tue, 20 May 2014 13:50:16 GMT

data want;

set have;

bob=substr(string,find(string,'BOB_TS=')+7,10);

run;