Help using Base SAS procedures

how to round up number ?

Reply
N/A
Posts: 0

how to round up number ?

if I have number -0.36, I want to have -1 or
-1.2 I want to have -2

how to round up it ?
thanks in advance.
Frequent Contributor
Posts: 82

Re: how to round up number ?

Hi!

Use function Floor.

data test;
input num_a;
num_b=floor(num_a);
datalines;
-0.36
-1.2
0.36
1.2
;
run;

It gives results exactly the way you wanted:
num_a num_b
-0.36 -1
-1.2 -2
0.36 0
1.2 1
Super Contributor
Super Contributor
Posts: 3,174

Re: how to round up number ?

Just for clarification - given the examples you showed, I would say you are rounding down, not up.

CEIL function would round "UP".
FLOOR function would round "DOWN".

The SAS support website http://support.sas.com/ has technical papers (user community - SUGI, SGF) and SAS product documentation for reference -- links for example are provided below.

Scott Barry
SBBWorks, Inc.

SUGI/SGF paper - Introduction to SAS Functions
http://www2.sas.com/proceedings/sugi24/Begtutor/p57-24.pdf


SAS 9.2 DOC - CEIL Function:
http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207949.htm

FLOOR function:
http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207955.htm
Ask a Question
Discussion stats
  • 2 replies
  • 206 views
  • 0 likes
  • 3 in conversation