Link to home
Start Free TrialLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

Finding all records where column ends in an alphabetic character

Experts,

I have an input Excel worksheet that I am reading into SAS.  The challenge I am facing is I am trying to select all records that the ID column ends in an alphabetic character,

The problem is the column is 13 characters but the input data is variable in length so I cannot check the 13th position because the data is variable in length.

Does anyone know how to do this in SAS?
ASKER CERTIFIED SOLUTION
Avatar of Aloysius Low
Aloysius Low
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial