regex101: PCRE (Legacy) Match Workspace

(?i)applies the following effective flags to the remainder of the pattern: gmi

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Group 1(data)

datathe literal text data (case insensitive)

\s+any whitespace character, repeated at least once

Group 2((\w+)(?=(\s*))(?:\4\w+)+)?

?repeats the group contents below at most once:

Group 3(\w+)

\w+any word character, repeated at least once

Positive Lookahead(?=(\s*))

Group 4(\s*)

\s*any whitespace character, repeated any number of times

Non-Capturing Group(?:\4\w+)+

+repeats the group contents below at least once:

\4the text saved by group 4

\w+any word character, repeated at least once

\s*any whitespace character, repeated any number of times

Group 5($((.|\n)*?)$;)?

?repeats the group contents below at most once:

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group 6((.|\n)*?)

Group 7(.|\n)*?

*?repeats the group contents below any number of times:

1st Alternative.

.any character (except for line terminators)

2nd Alternative\n

\na line-feed (newline) character (ASCII 10)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

(?i)(data)\s+((\w+)(?=(\s*))(?:\4\w+)+)?\s*(\(((.|\n)*?)\);)?

New

data foo (drop = DISCOUNT price RENAME = ( PROV_NM1= PROV_NM PROV_ST_NM1 = PROV_ST_NM) where = ( product = 'whizmo' and product < 10 )) bar( drop= DISCOUNT price rename= ( startDate = beginDate ) );

Data Data_asof&YrMon.;

data halfYear( drop= DISCOUNT price
 rename= ( startDate = beginDate ) where=(product = 'abc' and price > 10) );

data apply_adj_v2 non_adjusted incorrect_acct;

data apply_adj_v2;

DATA INPDTL1(RENAME=(PROV_NM1=PROV_NM PROV_ST_NM1=PROV_ST_NM));

DATA REIMB_MTHD_CLM2;