topic Re: Select codes that starts with two letters in SAS Programming

Select codes that starts with two letters

Chris_LK_87 — Wed, 17 Nov 2021 18:25:50 GMT

Hello,

My dataset looks like this:

data have;
length id $10 dcode $48;
input id$ dcode$ &;
datalines;
1 MCB10 PCF01 AAA30
2 AC003 PL000 TAC25
3 QC000 CAB50 FCE10
4 MA100 CA500 DE100
;
run;

I would like to flag (1 or 0) every row if they have a code that starts with two letters.

data want;
length id $10 dcode $48;
input id$ dcode$ & $let_flag;
datalines;
1 MCB10 PCF01 AAA30 0
2 AC003 PL000 TAC25 1
3 QC000 CAB50 FCE10 1
4 MA100 CA500 DE100 1
;
run;

Thanks!

Re: Select codes that starts with two letters

PeterClemmensen — Wed, 17 Nov 2021 18:54:05 GMT

So, you have multiple codes in your Dcode Variable, right?

Do all of them have to start with exactly 2 letters or at least 2 letters?

Why is let_flag = 0 in the first obs?

Re: Select codes that starts with two letters

ballardw — Wed, 17 Nov 2021 18:59:01 GMT

"I would like to flag (1 or 0) every row if they have a code that starts with two letters."

Define "a code". As I look at your data you apparently have 3 values stuck into a single variable. In a very large number of cases this is very poor data structuring so I can't tell if you want the "starts with two letters" to mean the long value with multiple spaces as a single code or each of the pieces separated by spaces to be a code.

Exactly 2? Of ALL the groups or just any one?

Re: Select codes that starts with two letters

Chris_LK_87 — Wed, 17 Nov 2021 19:24:56 GMT

Yes, the codes are stored in one variable. The codes always contain five digits, they can start with two letters or three letters. I would like to select the codes that starts with two letters.

Re: Select codes that starts with two letters

Chris_LK_87 — Wed, 17 Nov 2021 19:32:35 GMT

If we for example think that each code is stored in separate variables, example:

dcode1 dcode2 dcode3 dcode4 dcode5 etc. Then I could use an array.

Re: Select codes that starts with two letters

Chris_LK_87 — Wed, 17 Nov 2021 19:34:34 GMT

They should start with exatcly two letters. The first obs has let_flag=0 because neither of the codes in the first row starts exactly two letters.

Re: Select codes that starts with two letters

Chris_LK_87 — Wed, 17 Nov 2021 19:35:48 GMT

Comment to post. It should be start with exactly two letters.

Re: Select codes that starts with two letters

ChrisHemedinger — Wed, 17 Nov 2021 20:17:06 GMT

If I'm understanding you, you want flag=1 if any of the codes on the record start with exactly 2 letters (followed by numeric digits). This regular expression checks for that match (and whether it occurs at the start of a record or after a space).

data have; length id $10 dcode $48; input id$ dcode$ &; datalines; 1 MCB10 PCF01 AAA30 2 AC003 PL000 TAC25 3 QC000 CAB50 FCE10 4 MA100 CA500 DE100 ; run; data want; set have; flag = (prxmatch('/(^|\s)[A-Z][A-Z][0-9]/',dcode)>0); run;

Re: Select codes that starts with two letters

ChrisNZ — Thu, 18 Nov 2021 08:28:12 GMT

FLAG= (prxmatch('/[A-Z][A-Z][^A-Z]/',DCODE)=1);