https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780231#M248588 <P>I would suggest using the FINDC function to check if there are any alphabetic characters in the field. e.g.:</P> <PRE><CODE class=" language-sas">error_flag=findc(testvar,,'A')&gt;0;</CODE></PRE> Mon, 15 Nov 2021 13:41:57 GMT s_lassen 2021-11-15T13:41:57Z https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780229#M248587 <P>I have a dataset that needs cleaning.<BR />I have a field with A,B,C,D..... intermingled with 1,2,3,4....</P><P>Example: IA1234576BBX</P><P>These are invalid rows for the data, as only 1,2,3,4.... should be the value.</P><P>What is the best function to delete these rows.</P><P>Best would be to flag them so I can set a flag identifying them as invalid.</P><P>SAS EG 7.1.5</P><P>TIA Jay</P> Mon, 15 Nov 2021 13:27:40 GMT https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780229#M248587 JayS 2021-11-15T13:27:40Z https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780231#M248588 <P>I would suggest using the FINDC function to check if there are any alphabetic characters in the field. e.g.:</P> <PRE><CODE class=" language-sas">error_flag=findc(testvar,,'A')&gt;0;</CODE></PRE> Mon, 15 Nov 2021 13:41:57 GMT https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780231#M248588 s_lassen 2021-11-15T13:41:57Z https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780235#M248591 <P>Thank you, nice to have that error_flag for future processing...</P><P>Thanks again... J</P> Mon, 15 Nov 2021 14:14:25 GMT https://communities.sas.com/t5/SAS-Programming/Delete-Obs-With-A-B-C-In-AlphaNumeric-Field/m-p/780235#M248591 JayS 2021-11-15T14:14:25Z