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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 2683 views
  • 1 like
  • 3 in conversation