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

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

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