topic Re: Unexpected output when converting numeric column to character in SAS Programming

Unexpected output when converting numeric column to character

Saurabh_Rana — Wed, 09 Dec 2020 09:43:28 GMT

I have a numeric column like this-

Col A

100%

100%

0%

0%

100%

0%

I am trying to convert it into character format for which I am using the following code -

put(t1."Col A"n, 10.)

From which I am getting this output -

Col A

1

1

0

0

1

0

Why am I getting this output?

Kurt_Bremser — Wed, 09 Dec 2020 09:51:17 GMT

The PERCENT. format multiplies the value by 100 before displaying it. The raw value of 100 % is always 1.

Saurabh_Rana — Wed, 09 Dec 2020 09:59:14 GMT

What can I do to avoid such behavior?

Kurt_Bremser — Wed, 09 Dec 2020 10:02:33 GMT

What string do you expect from a value like this:

data have;
input col_a;
format col_a percent6.;
datalines;
1
;

Ksharp — Wed, 09 Dec 2020 12:45:25 GMT

data want;
set t1;
want=vvalue("Col A"n);
run;