BookmarkSubscribeRSS Feed
JonnyDas
Fluorite | Level 6

Hi everybody! 

 

I'm not getting this:

I created a data set via a do-loop, data x, below. 

When I use a w.d format on the value that I 'see' in the output data(value), the value is rounded up(fvalue).

When I create a hard value for 0.245 and use the same w.d format, the value is rounded down(fvalue2).

Clearly, SAS does not see the raw value of 0.245 coming from the data as 0.245. 

Question is why?

 

Thanks for considering and I hope this is clear.

 

Jon

 

 

data x;

do i= .01 to .99 by .0001;

value = i;

output;

end;

run;

 

data y;

      set x;

      fvalue=value;

      fvalue2=0.2450;

      rawvalue=fvalue2;

      format fvalue fvalue2 8.2;

      drop i;

run;

 

                                    when is 0.245 not 0.245?                       

 

                    Obs    value      fvalue    rawvalue  fvalue2 

 

                      1      0.245        0.24       0.245          0.25

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

It's actually worse than you think.

Run this:

data x;
  do X= .244 to .245 by .0001;                     
    Y=round(X,0.0001);
    output;                         
  end;         
  format X Y 20.16;
run;

to obtain (on a PC):

 

X Y
0.2440000000000000 0.2440000000000000
0.2441000000000000 0.2441000000000000
0.2442000000000000 0.2442000000000000
0.2443000000000000 0.2443000000000000
0.2444000000000000 0.2444000000000000
0.2444999999999900 0.2445000000000000
0.2445999999999900 0.2446000000000000
0.2446999999999900 0.2447000000000000
0.2447999999999900 0.2448000000000000
0.2448999999999900 0.2449000000000000
0.2449999999999900 0.2450000000000000

Read about numeric precision to know more.

For example here or here.

 

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 658 views
  • 1 like
  • 2 in conversation