topic Re: Select a specific interval in string in SAS Programming

Select a specific interval in string

Sk1_SAS — Tue, 10 Sep 2019 20:22:51 GMT

Hi Team,

I would like to know, if is possible to select the word in a specific interval string.

Ex: Variable name: Comments
I need select the words between PROCESS ORIGIN and FACTS.

PROCESS ORIGIN sas communities FACTS

PROCESS ORIGIN Google Inc FACTS

PROCESS ORIGIN Google FACTS

Thx !!!

Re: Select a specific interval in string

Jagadishkatam — Tue, 10 Sep 2019 21:01:42 GMT

Please try

data want;
input string&$100.;
want=prxchange('s/(.*origin)(.*)(FACTS\s)/$2/i',-1,string);
cards;
PROCESS ORIGIN sas communities FACTS
PROCESS ORIGIN Google Inc FACTS
PROCESS ORIGIN Google FACTS
;

Re: Select a specific interval in string

Patrick — Wed, 11 Sep 2019 06:05:36 GMT

data want(drop=_:);
  input string&$100.;
  length want $80;
  retain _re;

  if _n_=1 then
    _re=prxparse('/\bprocess origin\b(.*)\bfacts\b/oi');

  if prxmatch(_re, trim(string)) then
    do;
      want=prxposn(_re, 1, string);
    end;

  cards;
PROCESS ORIGIN sas communities FACTS
PROCESS ORIGIN Google Inc FACTS
PROCESS ORIGIN Google FACTS
Process Original Mix by Wehbba facts
blah PROCESS ORIGIN Google Inc FACTS
blah PROCESS ORIGIN Google Inc xxFACTS
blah PROCESS ORIGIN Google Inc FACTSxx
;

Re: Select a specific interval in string

Sk1_SAS — Wed, 11 Sep 2019 13:40:53 GMT

Thank you!