https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65017#M18512 There are a variety of function that tests for numeric/char that could be used together with SUBSTR.<BR /> <BR /> /Linus Mon, 17 Aug 2009 10:26:26 GMT LinusH 2009-08-17T10:26:26Z https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65016#M18511 data pno;<BR /> input policyno;<BR /> cards;<BR /> AS789,A745,WE425<BR /> QW45,CV956,PO789<BR /> A75,P45632,WE452<BR /> run;<BR /> <BR /> <BR /> I want the policy no having twocaharater and three numeric obs.<BR /> <BR /> output<BR /> <BR /> AS789,WE425<BR /> CV956,PO789<BR /> WE452 Mon, 17 Aug 2009 07:21:23 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65016#M18511 R_Win 2009-08-17T07:21:23Z https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65017#M18512 There are a variety of function that tests for numeric/char that could be used together with SUBSTR.<BR /> <BR /> /Linus Mon, 17 Aug 2009 10:26:26 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65017#M18512 LinusH 2009-08-17T10:26:26Z https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65018#M18513 But how can we do this by substr as the obs are at different positions. Mon, 24 Aug 2009 05:29:42 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65018#M18513 sas_ 2009-08-24T05:29:42Z https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65019#M18514 You can use the scan function to put each policy in their own column/observation.<BR /> /Linus Mon, 24 Aug 2009 06:49:07 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Char-and-Num/m-p/65019#M18514 LinusH 2009-08-24T06:49:07Z