topic How to get the various pattern of of string in SAS Enterprise Guide

How to get the various pattern of of string

alepage — Tue, 09 Apr 2024 14:44:26 GMT

Hello,

Information into SAS dataset may not be entered with the same format, specially for policy number.

In the same dataset we could have those policy numbers

M49999999

P4M49999999

123-4567

123A4567

So is there a way to get the various policy number parttern such as;

Cnnnnnnnn

Cncnnnnnnnn

nnnsnnnm

Nnncnnnn

Where n is numeric, c character and s is a special character such as –

Re: How to get the various pattern of of string

yabwon — Tue, 09 Apr 2024 14:52:38 GMT

Maybe something like this:

data have;
    input column $20.;
    datalines;
M49999999
P4M49999999
123-4567
123A4567
;
run;
data want;
set have;
from='ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890 -)(*&^%$#@!{}[]:;.,/?\|';
to  ='CCCCCCCCCCCCCCCCCCCCCCCCCCNNNNNNNNNNSSSSSSSSSSSSSSSSSSSSSSSS';
pattern=translate(upcase(column),to,from);
drop from to;
run;

Re: How to get the various pattern of of string

Tom — Tue, 09 Apr 2024 15:20:31 GMT

I don't know what it means to "get" a policy number pattern.

Re: How to get the various pattern of of string

alepage — Tue, 09 Apr 2024 15:44:38 GMT

Original as solution. I have never though about this approach