topic Re: string extraction in SAS Programming

string extraction

KrishnaChandra — Sat, 11 Oct 2014 17:29:20 GMT

hai all i have a doubt in string extraction.I can use several methods like substr(),index() to extarct 245 from whole string.But i couldn't get any result.Please help me

site

245-abcdefhg

Thanks

krishna

Re: string extraction

Reeza — Sat, 11 Oct 2014 17:46:08 GMT

Are all strings in that format? Do you need it as numeric or character?

Try scan

string245=scan(string, 1, "-");

Re: string extraction

KrishnaChandra — Sat, 11 Oct 2014 17:51:39 GMT

need to get it as numeric

Re: string extraction

KrishnaChandra — Sat, 11 Oct 2014 18:03:43 GMT

Hai Reeza No result found :smileyplain:

Re: string extraction

Reeza — Sat, 11 Oct 2014 18:31:09 GMT

Then you haven't provided enough information, works for me just fine, I've added the input to convert to numeric.

This also shows the compress method:

data have;

informat string $25.;

input string;

cards;

245-abcdefhg

;

run;

data want;

set have;

want=input(scan(string, 1, "-"), 8. );

want2=input(compress(string,, 'kd'), 8.);

type=vtype(want);

type2=vtype(want2);

put want;

put want2;

put type;

put type2;

run;

LOG:

1417 data want;

1418 set have;

1419 want=input(scan(string, 1, "-"), 8. );

1420 want2=input(compress(string,, 'kd'), 8.);

1421 type=vtype(want);

1422 type2=vtype(want2);

1423 put want;

1424 put want2;

1425 put type;

1426 put type2;

1427 run;

245

NOTE: There were 1 observations read from the data set WORK.HAVE.

NOTE: The data set WORK.WANT has 1 observations and 5 variables.

NOTE: DATA statement used (Total process time):

real time 0.05 seconds

cpu time 0.01 seconds

Re: string extraction

art297 — Sat, 11 Oct 2014 18:34:08 GMT

data have;

input site $25.;

site_number=input(scan(site, 1, "-"),8.);

cards;

245-abcdefhg

;

Re: string extraction

KrishnaChandra — Sat, 11 Oct 2014 20:35:51 GMT

Thanks Reeza

Re: string extraction

KrishnaChandra — Sat, 11 Oct 2014 20:36:37 GMT

thanks Arthur tabachneck