A DATA step should satisfy your rqmt here - after inputting SAS CHARACTER variables to start with an INPUT Statement, then using various SAS functions like ANYALPHA / ANYDIGIT to test your strings, followed by the INPUT function to convert, as required, from character to numeric. Lastly, consider the use of KEEP / DROP to only capture the SAS variables you require for the SAS output file/member/table.
Below are a few examples of Google search arguments you can make use of, for searching the SAS support
http://support.sas.com/ website, which has much (free!) information including SAS-hosted DOC and supplemental technical / conference papers on this type of learning - topic.
Scott Barry
SBBWorks, Inc.
Suggested Google advanced search arguments, this topic / post:
intro data step programming site:sas.com
intro input function site:sas.com
intro anyalpha anydigit function site:sas.com