Extracting the variable names in a SAS code

Yiang — Mon, 15 Jan 2024 03:45:02 GMT

I have been given a set of sas scripts (40 odd scripts) written in SAS without documentation of the inter-relationships between the .SAS files.

I am not trying to reverse engineer it but just trying to understand the derivation of certain variables of interest only.

if P26v = 1 then mb1 = 1;
else if P26u IN(5,8,9) or M26v = 5 then md6 = 5;
else mb1 = D26v;

if P26Q = 1 or P26W = 1 or P26P = 1 then md8 = 1;
else if M26A = 5 or M26F = 7 or P26P = 3 then md8 = 2;
else if P26Q = 8 or D26W = 8 or D26R = 8 then md8 = 8;

i would like to extract out the lines

> else if P26u IN(5,8,9) or M26v = 5 then md6 = 5;

> else if M26A = 5 or M26F = 7 or P26P = 3 then md8 = 2;

may i know is there a script where i can run such that i can specify regular expression '/\bM\w+/' and the lines that contains a variable starting with M followed by some numberic can be extracted ?

I used chatgrp for help but it is not working out for me. I only manage to get the script to iterate all the .SAS files but the part to look for variable of specific pattern is just not working out for me. I wish to seek some advice how can i go about it please.

Thank you

Re: Extracting the variable names in a SAS code

Patrick — Mon, 15 Jan 2024 04:56:39 GMT

It wouldn't be hard to write such a script.

What I would do: Download and open all these 40 .sas files with Notepad++ and do the search there (Notepad++ also allows for RegEx searches). I used to use Atom in the past for such impact analysis - but it has unfortunately been discontinued.

topic Re: Extracting the variable names in a SAS code in SAS Programming

Extracting the variable names in a SAS code

Re: Extracting the variable names in a SAS code