Character to Numeric conversion issues

Accepted Solution Solved
Reply
Highlighted
Contributor
Posts: 54
Accepted Solution

Character to Numeric conversion issues

What's the best way to convert from numeric to character?

What's the best way to convert from character to numeric?


Accepted Solutions
Solution
a week ago
Super User
Posts: 10,280

Re: Character to Numeric conversion issues

Posted in reply to JohnSAScom

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;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Solution
a week ago
Super User
Posts: 10,280

Re: Character to Numeric conversion issues

Posted in reply to JohnSAScom

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;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 54

Re: Character to Numeric conversion issues

Posted in reply to KurtBremser

Perfect.  Thanks Kurt.

PROC Star
Posts: 1,283

Re: Character to Numeric conversion issues

Posted in reply to JohnSAScom

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.

Contributor
Posts: 54

Re: Character to Numeric conversion issues

Thanks a lot.

Valued Guide
Posts: 597

Re: Character to Numeric conversion issues

Posted in reply to JohnSAScom

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,
Suryakiran
Contributor
Posts: 54

Re: Character to Numeric conversion issues

Posted in reply to SuryaKiran

Thanks.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 64 views
  • 0 likes
  • 4 in conversation