topic Re: Problems transforming character data to percentage in SAS Enterprise Guide

Problems transforming character data to percentage

fri0 — Tue, 14 Oct 2014 16:13:16 GMT

Hi, I have percentage data but in character format. I'm using this code to transform it:

data monic.fondorfdol;

set work.fondorfdol;

tir1=input(tir,percent5.5);

run;

But I don't get the exact number, for example, these are original values:

5.8077%

1.7514%

After the transformation, I get:

5.807

1.751

It's not necessary the percetange symbol, but I want to have all decimal numbers, is it possible?

Thanks!

Re: Problems transforming character data to percentage

art297 — Tue, 14 Oct 2014 16:23:31 GMT

data monic.fondorfdol;

set work.fondorfdol;

tir1=input(tir,percent.);

run;

Re: Problems transforming character data to percentage

fri0 — Tue, 14 Oct 2014 16:30:41 GMT

Thank you very much, I always thought that I have to specify the width of the value.

Re: Problems transforming character data to percentage

art297 — Tue, 14 Oct 2014 17:10:28 GMT

The number after the period in an informat isn't the number of decimal places. According to the documentation: the number specifies an optional decimal scaling factor in the numeric informats. SAS divides the input data by 10 to the power of d.