The character is followed by 7 digits

[J_J_J]

Hi

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?

[Kurt_Bremser]

Are the positions fixed?

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

[J_J_J]

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

[Kurt_Bremser · Accepted solution]

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;

[J_J_J]

Thank you so much, Kurt_Bremser!