Hi:
I would imagine that some combination of SCAN, SUBSTR, ANYDIGIT, ANYALPHA, etc, etc functions would be useful. But, it seems to me that quite a bit about your data needs to be explained. For example, are all the addresses VERY regular:
1234 Sesame St.
98765 Chocolate Way
where the number ALWAYS comes first??? Or, could you have more irregular addresses:
North 1234 Grouch Lane
98765-A 34th St, South
For the "regular" data, getting the first chunk, if it's always the number is going to be a simple SCAN. But, for the "irregular" data, do you want to see the 1234 and then "North Grouch Lane" as one string or do you want to see 1234, then one string for the prefix "North" and a second variable for street name of "Grouch Lane".
What about 98765-A?? Seems like an apartment or a multi-unit building -- would you want the "-A" to be part of the "98765" (in which case, you have a field that cannot be just a number). Or, what about 34th -- a function would find the number 34, but the 34 is part of the street designation.
You originally said you wanted "SAS to recognize the number in the cell, and remove it to a new cell. Or simply create two new colums, one with characters, and one with numbers." It seems to me that without more information about the data and what to do in irregular situations, this is a hard one to help with beyond pointing you in the general direction of the character functions for parsing, splitting and extracting.
cynthia