topic Re: The character is followed by 7 digits in New SAS User

The character is followed by 7 digits

J_J_J — Tue, 05 Apr 2022 07:15:27 GMT

I try to find results that correspond to the rule: The character is on the 11th place and is followed by 7 digits, ex. 1234567891A1234567

Could you help me please?

Re: The character is followed by 7 digits

Kurt_Bremser — Tue, 05 Apr 2022 07:22:32 GMT

Are the positions fixed?

Do you want to search for specific characters/numbers, or just for the pattern?

Re: The character is followed by 7 digits

J_J_J — Tue, 05 Apr 2022 07:26:07 GMT

11th position is fixed and I search for specific character, it's always A, but numbers can vary.

Re: The character is followed by 7 digits

Kurt_Bremser — Tue, 05 Apr 2022 07:32:16 GMT

Simple, "brute force" approach:

data have;
input string $20.;
datalines;
1234567891A1234567
XXXXXXXXXXX9999999
1234567891A95X1234
;

data want;
set have;
if substr(string,11,1) = "A" and notdigit(substr(string,12,7)) = 0;
run;

Re: The character is followed by 7 digits

J_J_J — Tue, 05 Apr 2022 07:48:48 GMT

Thank you so much, Kurt_Bremser!