- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What is the logic behind the PUT function to convert a numeric variable to character variiable?
consider two examples;
data temp;
value = 0.5500;
value1 = put(value, 16.1);
run;
the above code correctly prints the value of value1 as 0.6 in the output dataset.
But in some scenarios, the value1 in the output dataset is being printed as 0.5(gets truncated instead of rounding). I couldnt identify where the issue is. could someone please help?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I will take a guess: numeric precision.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
thank you Arthur. How we can resolve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The W.D format does not always round correctly. The "classic" example to me is -0.0 below. To solve it, round the value to the desired precision before using PUT function.
a=.55;
put a=hex16.;
do x = .33+.2199999999999995,-1e-16;
y = put(x,16.1);
z = put(round(x,.1),16.1);
put x=hex16. x= y= z=;
end;
run;
a=3FE199999999999A
x=3FE1999999999995 x=0.55 y=0.5 z=0.6
x=BC9CD2B297D889BC x=-1E-16 y=-0.0 z=0.0
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
How does x resolve in your code? You've used comma between the values so I'm not sure how it calculates.
x = .33+.2199999999999995,-1e-16;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
It is iterative DO specifications connected by COMMA.
specification
denotes an expression or a series of expressions in this form
in this case with only the START values specified similar to DO I=1,10,20; each comma specifies a separate specification.
START STOP and BY can all be expressions as in this case add two numeric constants .33+.219999 comma then another expression (a numeric constant) -1E-16
The DO iterates 2 times.