Reg:Char and Num

[R_Win]

data pno;
input policyno;
cards;
AS789,A745,WE425
QW45,CV956,PO789
A75,P45632,WE452
run;


I want the policy no having twocaharater and three numeric obs.

output

AS789,WE425
CV956,PO789
WE452

[LinusH]

There are a variety of function that tests for numeric/char that could be used together with SUBSTR.

/Linus

[sas_]

But how can we do this by substr as the obs are at different positions.

[LinusH]

You can use the scan function to put each policy in their own column/observation.
/Linus