topic Re: regex from R to SAS in SAS Programming

regex from R to SAS

metallon — Thu, 21 Jan 2016 10:05:19 GMT

Hi,

I have to migrate some old R code to sas and found the following:

datarow$varibale[grep(".*a.*",datarow$Original),] <- "new column"

I dont quite get what its doing, guessing it takes everything that starts with .a and put it in a new varialbe Iwonder if someone can help me translating it into sas.

thanks

Re: regex from R to SAS

data_null__ — Thu, 21 Jan 2016 13:30:16 GMT

I think it matches any string that contains an "a". At least that's what my limited testing shows.

4043  data _null_;
4044     input line $20.;
4045     if _n_ eq 1 then rx=prxparse("/.*a.*/");
4046     retain rx;
4047     match = prxmatch(rx,strip(line));
4048     put (_all_)(=);
4049     cards;

line=hello rx=1 match=0
line=helloah rx=1 match=1
line=zzz rx=1 match=0
line=  rx=1 match=0
line=ahhello rx=1 match=1
line=678ab rx=1 match=1
line=a rx=1 match=1
line=ta rx=1 match=1
line=u rx=1 match=0