https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67727#M19388 Just for clarification - given the examples you showed, I would say you are rounding down, not up.<BR /> <BR /> CEIL function would round "UP".<BR /> FLOOR function would round "DOWN".<BR /> <BR /> The SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> has technical papers (user community - SUGI, SGF) and SAS product documentation for reference -- links for example are provided below.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SUGI/SGF paper - Introduction to SAS Functions<BR /> <A href="http://www2.sas.com/proceedings/sugi24/Begtutor/p57-24.pdf" target="_blank">http://www2.sas.com/proceedings/sugi24/Begtutor/p57-24.pdf</A><BR /> <BR /> <BR /> SAS 9.2 DOC - CEIL Function:<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207949.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207949.htm</A><BR /> <BR /> FLOOR function:<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207955.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207955.htm</A> Mon, 05 Jan 2009 13:35:48 GMT sbb 2009-01-05T13:35:48Z https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67725#M19386 if I have number -0.36, I want to have -1 or<BR /> -1.2 I want to have -2<BR /> <BR /> how to round up it ?<BR /> thanks in advance. Mon, 05 Jan 2009 11:22:28 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67725#M19386 deleted_user 2009-01-05T11:22:28Z https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67726#M19387 Hi! <BR /> <BR /> Use function Floor.<BR /> <BR /> data test;<BR /> input num_a;<BR /> num_b=floor(num_a);<BR /> datalines;<BR /> -0.36<BR /> -1.2<BR /> 0.36<BR /> 1.2<BR /> ;<BR /> run;<BR /> <BR /> It gives results exactly the way you wanted: <BR /> num_a num_b<BR /> -0.36 -1<BR /> -1.2 -2<BR /> 0.36 0<BR /> 1.2 1 Mon, 05 Jan 2009 12:16:23 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67726#M19387 ieva 2009-01-05T12:16:23Z https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67727#M19388 Just for clarification - given the examples you showed, I would say you are rounding down, not up.<BR /> <BR /> CEIL function would round "UP".<BR /> FLOOR function would round "DOWN".<BR /> <BR /> The SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> has technical papers (user community - SUGI, SGF) and SAS product documentation for reference -- links for example are provided below.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SUGI/SGF paper - Introduction to SAS Functions<BR /> <A href="http://www2.sas.com/proceedings/sugi24/Begtutor/p57-24.pdf" target="_blank">http://www2.sas.com/proceedings/sugi24/Begtutor/p57-24.pdf</A><BR /> <BR /> <BR /> SAS 9.2 DOC - CEIL Function:<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207949.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207949.htm</A><BR /> <BR /> FLOOR function:<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207955.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000207955.htm</A> Mon, 05 Jan 2009 13:35:48 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-round-up-number/m-p/67727#M19388 sbb 2009-01-05T13:35:48Z