topic Re: Regular Expression Python to SAS in SAS Programming

Regular Expression Python to SAS

Reeza — Mon, 18 Jun 2018 21:54:05 GMT

I'm converting some code from Python to SAS and stuck at one point - regular expressions. Can someone confirm my assumption is correct please?

I think this line:

df['VALUE'] = df['VALUE'].replace(r'([a-z,A-Z])\w+',0)

Basically removes all character values and replaces it with 0?

Is this interpretation correct?

I can't run the program on the file otherwise I'd test it by running each program and comparing the results.

Re: Regular Expression Python to SAS

ChrisNZ — Mon, 18 Jun 2018 22:53:58 GMT

My python is basic, but as far as I know the syntax is:

NEW_STR=re.replace(REGEX, REPLACEMENT , OLD_STR)

1. You need the re. call (what's the value of df['VALUE'] ?) for the RegEx parser to be used

2. You need 3 parameters

3. I don't see how numbers are allowed

Regardless, the regular expression here matches:

- one lower case letter or comma or upper case letter

- followed by word characters (this includes digits and underscore)

Re: Regular Expression Python to SAS

tomcmacdonald — Mon, 18 Jun 2018 23:01:45 GMT

Are these pandas dataframes? If so I would do it like this:

import re


...


df['VAL'] = df['VAL'].apply(lambda x: re.sub('[A-Z]+', '0', x, flags=re.I))

Re: Regular Expression Python to SAS

Reeza — Tue, 19 Jun 2018 00:28:17 GMT

It is panda's but I'm going in the opposite direction, from Pandas/Python to SAS code. The data is too big to be handled well in python.

Re: Regular Expression Python to SAS

Patrick — Tue, 19 Jun 2018 04:00:31 GMT

@Reeza

If I read this RegEx correctly then it needs at least two characters to match; the first character needs to be a letter, the 2nd to n can be alphanumeric or an underscore.

data sample;
  infile datalines truncover;
  input source $char10.;
  format target $char10.;
  target=prxchange('s/[a-z,A-Z]\w+/0/i',1,source);
  datalines;
Abc9xy
a
a9
   _a
   a_
   _a_
123_a
  123_ab
123a_
 a123a_
 X_123a_
 X_123a_ bb
123_abc de
;
run;

Re: Regular Expression Python to SAS

ChrisNZ — Tue, 19 Jun 2018 04:04:23 GMT

@Patrick

> If I read this RegEx correctly then it needs at least two characters to match; the first character needs to be a letter, the 2nd to n can be alphanumeric or an underscore.

You mean:

If I read this RegEx correctly then it needs at least two characters to match; the first character needs to be a letter or a comma, the 2nd one can be alphanumeric or an underscore.

Re: Regular Expression Python to SAS

Patrick — Tue, 19 Jun 2018 04:06:22 GMT

@ChrisNZ

True, missed the comma.