BookmarkSubscribeRSS Feed
Prasanna1452
Calcite | Level 5


Hi all,

I am validating PAN number ( 5 char 4 digits 1 char).

I used PRXMATCH('/[a-zA-Z]{5}\d{4}[a-zA-Z]/',PAN ).

But whenever I close the job and open again I get this 

PRXMATCH('/[Missing Token]{5}\d{4}[Missing Token]/',PAN ).

Please help me how to resolve this.

Also I tried this. This also not working.

PRXMATCH('/\w{5}\d{4}\w/',PAN).

4 REPLIES 4
Ksharp
Super User

PRXMATCH('/[a-zA-Z]{5,5}\d{4,4}[a-zA-Z]/',PAN ).   ?

Prasanna1452
Calcite | Level 5

Hi Thanks for the reply.

The expression

PRXMATCH('/[a-zA-Z]{5}\d{4}[a-zA-Z]/',PAN )

is working fine for me, but When I close the job and open the expression becomes like this.

PRXMATCH('/[Missing Token]{5}\d{4}[Missing Token]/',PAN ).

Prasanna1452
Calcite | Level 5

I fixed the problem.

amirhafizin
Calcite | Level 5
Can You Please Share how you fixed the problem

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2321 views
  • 1 like
  • 3 in conversation