topic Re: extract value after a set number of specific symbols sas in SAS Procedures

extract value after a set number of specific symbols sas

Louis_DB — Wed, 23 Mar 2022 11:44:01 GMT

Hey,

I'm trying to see if there is a specific value (in this case the letter "Y") after a set number of specific symbols (in this case in between the last 11 and 12 "|"s).

I tried to save the value in a new column and then doing an if statement, but the issue is that I do not know how to print the letter just before the last 11 |'s.

e.g.

data have;
input params $70.;
cards;
|bla|||||5||bla|bla||||||bla||||bla|||||||Y|||||||||||
|bla|||||10||bla|bla||||||bla||||bla|||||||Y|baa||||||||||
|bla|||||10||bla|bla||||||bla||||bla||||||||baa||||||||||
;

data want;
set have;
Want = substr(params, length(params)-11,1);
run;

In this example i wanted it to print:

1: Y

2: Y

3: nothing

and not

1: Y

2: a

3: a

Re: extract value after a set number of specific symbols sas

Ksharp — Wed, 23 Mar 2022 12:18:23 GMT

data have;
input params $70.;
cards;
|bla|||||5||bla|bla||||||bla||||bla|||||||Y|||||||||||
|bla|||||10||bla|bla||||||bla||||bla|||||||Y|baa||||||||||
|bla|||||10||bla|bla||||||bla||||bla||||||||baa||||||||||
;

data want;
set have;
call scan(params,-12,p,l,'|','mq');
want=substrn(params,p,l);
drop p l;
run;

Re: extract value after a set number of specific symbols sas

yabwon — Wed, 23 Mar 2022 12:46:56 GMT

Wouldn't just "backward" scan() be good?

data want;
  set have;
  want = scan(params,-12,"|","M");
run;

Bart

Re: extract value after a set number of specific symbols sas

Ksharp — Wed, 23 Mar 2022 12:53:56 GMT

Sure. In this case, both are same . But yours could save one line code .

Re: extract value after a set number of specific symbols sas

Tom — Wed, 23 Mar 2022 13:26:14 GMT

SCAN() is better in this case since the request was just for the value between the delimiters, not the rest of the string.

Re: extract value after a set number of specific symbols sas

Ksharp — Thu, 24 Mar 2022 11:35:39 GMT

Tom,
SCAN() and CALL SCAN() are the same function and rountine .
This could save one line code, if it was what you are thinking , Whatever .