Converting decimal values to character?

Reply
Contributor
Posts: 60

Converting decimal values to character?


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

Respected Advisor
Posts: 3,799

Re: Converting decimal values to character?

Posted in reply to Saravanan

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.

Contributor
Posts: 60

Re: Converting decimal values to character?

Posted in reply to data_null__

Hi,

This is the dataset.  A is numeric.

A

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

A

0.1245

0.0045

0.0235

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

Thanks,

Saravanan

Respected Advisor
Posts: 3,799

Re: Converting decimal values to character?

Posted in reply to Saravanan

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

Contributor
Posts: 60

Re: Converting decimal values to character?

Posted in reply to data_null__

Thank you for your assiatance. Much appreciated.

saravanan

Super Contributor
Posts: 543

Re: Converting decimal values to character?

Posted in reply to Saravanan

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.

Contributor
Posts: 60

Re: Converting decimal values to character?

Posted in reply to AncaTilea

Thank you so much. It works fine.

Saravanan

Super Contributor
Posts: 543

Re: Converting decimal values to character?

Posted in reply to Saravanan

You are welcome.

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

Thanks.

Ask a Question
Discussion stats
  • 7 replies
  • 10055 views
  • 0 likes
  • 3 in conversation