What's the best way to convert from numeric to character?
What's the best way to convert from character to numeric?
Rename, convert, drop:
data have;
input num char $;
cards;
3 3
;
run;
data want;
set have (rename=(num=_num char=_char));
char = input(_char,best.);
num = put(_num,best12.);
drop _num _char;
run;
Rename, convert, drop:
data have;
input num char $;
cards;
3 3
;
run;
data want;
set have (rename=(num=_num char=_char));
char = input(_char,best.);
num = put(_num,best12.);
drop _num _char;
run;
Perfect. Thanks Kurt.
numeric to character: Put Function
character to numeric: Input Function
Do a simple Google search or search this forum for example. Literally thousands out there.
Thanks a lot.
INPUT() Function to convert character to numeric and PUT() function to convert numeric to character. You need to apply the appropriate format.
Data test;
Char_to_Num=INPUT('12345',8.);
Num_to_Char=PUT(12345,8.);
run;
Thanks.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.