morinia
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.