topic Re: How to separate charaters and numerics by using Data FLux in SAS Data Management

How to separate charaters and numerics by using Data FLux

sas_Forum — Thu, 02 Apr 2015 07:27:22 GMT

i am having data

string='erer4556l78poo9'

i want chat in one column and num in another column

string_Num=4556789

string_char='ererlpoo'

Re: How to separate charaters and numerics by using Data FLux

Ksharp — Thu, 02 Apr 2015 12:24:07 GMT

Can you make a function in DataFlux, I never used it before.

string_Num=compress(string,,'kd');

string_char=compress(string,,'d');

Re: How to separate charaters and numerics by using Data FLux

skillman — Thu, 02 Apr 2015 12:52:37 GMT

Here is a solution which will loop through the whole input string and pick the values that are numeric or characters and assign them to a temp variable until the end of the loop. Also see attached:

Pre-Processing Expression:

hidden string temp_string_num

real string_Num

hidden string temp_string_char

string string_char

hidden integer cnt

hidden integer i

string_Num = 0

temp_string_num = ''

temp_string_char = ''

string_char = ''

cnt = 0

i = 0

Expression:

cnt = len(`input_string`)

while i <= cnt

begin

if isnumber(mid(`input_string`, i, 1)) == true

temp_string_num = temp_string_num & mid(`input_string`, i, 1)

else

temp_string_char = temp_string_char & mid(`input_string`, i, 1)

i = i + 1

end

i = 0

string_num = temp_string_num

string_char = temp_string_char