topic Re: Rounding up or down based on conditions >X.5 or <=X.5 in SAS Programming

Rounding up or down based on conditions >X.5 or <=X.5

kmardinian — Thu, 30 May 2019 20:05:51 GMT

Hi, If I would like to round up or down for a specific variable in a dataset under these two conditions, what would be the best/easiest way to do this in SAS?

For decimal value outcomes < X.5, round down to the nearest integer

For decimal value outcomes ≥ X.5, round up to the nearest integer

I've seen it done as a do loop, but that seems overly complicated.

Any help is much appreciated, thank you!

Re: Rounding up or down based on conditions >X.5 or <=X.5

PeterClemmensen — Thu, 30 May 2019 20:10:48 GMT

This is exactly what the Round Function does?

data have;
   do x=1 to 10;
      y=x*rand('uniform');
      output;
   end;
run;

data want;
   set have;
   z=round(y);
run;

Re: Rounding up or down based on conditions >X.5 or <=X.5

ballardw — Thu, 30 May 2019 22:08:18 GMT

And for extra added fun you can actually round to the nearest multiple of a given number. The default is 1 if not supplied.

data have;
   do x=1 to 10;
      z= rand('uniform');
      y1= round(x*z,1);
      y2= round(x*z,2);
      y3= round(x*z,.7);
      y4= round(x*z,2.5);
      output;
   end;
run;

Re: Rounding up or down based on conditions >X.5 or <=X.5

PaigeMiller — Thu, 30 May 2019 22:18:50 GMT

@kmardinian wrote:

For decimal value outcomes < X.5, round down to the nearest integer

For decimal value outcomes ≥ X.5, round up to the nearest integer

This is different than the title of this thread, and if you really mean the title of this thread, then the answer given is not correct. Just saying...