topic Re: Converting decimal values to character? in SAS Programming

Converting decimal values to character?

Saravanan — Wed, 30 Jan 2013 13:58:57 GMT

Hi,

I`m trying to convert decimal values to character. But i can not preserve the decimal values.

For example, 0.0078 shows up as 0.

Is there anyway i can preserve the exact decimal places after converting to character?

Thanks,

Saravanan

Re: Converting decimal values to character?

data_null__ — Wed, 30 Jan 2013 14:02:52 GMT

You should supply a bit more information about what you did that did not work, what you have and what you want, that sort of thing.

Re: Converting decimal values to character?

AncaTilea — Wed, 30 Jan 2013 14:14:24 GMT

This would be one way:

data temp;

length y $10;

x = 0.03456;

y = put(x, 10.4);*I arbitrarily selected 4 decimal...which means 10.4 format allows for 10 characters, from which 4 are the decimal part;

run;

Good luck!

Anca.

Re: Converting decimal values to character?

Saravanan — Wed, 30 Jan 2013 14:26:54 GMT

Hi,

This is the dataset. A is numeric.

0.1245

0.0045

0.0235

I need to convert this numeric variable to character. 'A' should be a character in my output.My output should be

0.1245

0.0045

0.0235

I tried A1=put(A,$6);

Thanks,

Saravanan

Re: Converting decimal values to character?

data_null__ — Wed, 30 Jan 2013 14:34:56 GMT

You need to use the proper format in the PUT function see post from Anca tilea.

Re: Converting decimal values to character?

Saravanan — Wed, 30 Jan 2013 18:11:44 GMT

Thank you so much. It works fine.

Saravanan

Re: Converting decimal values to character?

Saravanan — Wed, 30 Jan 2013 18:12:10 GMT

Thank you for your assiatance. Much appreciated.

saravanan

Re: Converting decimal values to character?

AncaTilea — Wed, 30 Jan 2013 18:25:54 GMT

You are welcome.

Please mark the thread as answered so users don't try to come up with more answers.

Thanks.