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!
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;
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;
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;
@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...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.