Dear All,
Please help in below.
Values Character Numeric
ABC123 ABC 123
12AB45 AB 1245
12345A A 12345
A12D52 AD 1252
123456 123456
Can you please guide on how can i extract numeric and character in different ?
Data have;
set want;
character=compress(values,,ka);
numeric=compress(values,,kd);
run;
Here is a solution:
data have;
input values$;
cards;
ABC123
12AB45
12345A
A12D52
123456
;
data want;
set have;
NUMERIC = prxchange("s/[^0-9]//",-1,values);
CHARACTERS = prxchange("s/[^A-Z]//",-1,values);
NUMBERS = input(prxchange("s/[^0-9]//",-1,values),8.);
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.