topic Re: add decimal to character (number) string in SAS Programming

add decimal to character (number) string

Xiaoyi — Thu, 09 Jul 2020 18:59:42 GMT

I want to convert a numeric variable (var1) to character (var2) and add "." in to the string like the following. How could I do it? I know how to convert the numeric to character use PUT, but I failed to put the "." into the converted string. Thank you for helping in advance!

Joy

ID var1 var2

111 745510 745.510

112 742100 742.100

113 745510 745.510

114 745510 745.510

Re: add decimal to character (number) string

ballardw — Thu, 09 Jul 2020 19:03:52 GMT

@Xiaoyi wrote:

I want to convert a numeric variable (var1) to character (var2) and add "." in to the string like the following. How could I do it? I know how to convert the numeric to character use PUT, but I failed to put the "." into the converted string. Thank you for helping in advance!

Joy

ID var1 var2

111  745510   745.510

112  742100 742.100

113  745510 745.510

114  745510 745.510

It might help to show the code you attempted.

The values you show makes me think that a divide by 1000 should have been involved.

Re: add decimal to character (number) string

Reeza — Thu, 09 Jul 2020 19:16:11 GMT

If VAR1 is a character variable try INPUT()

INPUT(var1, 8.3);

If VAR1 is a numeric variable then divide by 1000 and format using 8.3.

new_var = var1/1000;
format new_var 8.3;

Re: add decimal to character (number) string

PGStats — Thu, 09 Jul 2020 19:32:23 GMT

If you want to represent the number with your local conventions, you can use a National Language format such as NLNUM7.0. For example:

 71         options LOCALE=German_Germany;
 72         data _null_;
 73            x=123456;
 74            put x nlnum7.0;
 75         run;
 
 123.456