Strip from decimal to right from a numeric field

[carmendee]

In need to round down to the nearest whole number or simply strip everything to the right of the decimal in a numeric field.  Example:

have	need
1.2	1
0.1	0
10	10

[mohamed_zaki · Accepted solution]

Use the FLOOR function to round down to the next integer.

data a;
  input have;
  need=floor(have);
datalines;
1.2
0.1
10
123.456
34
5.1111
7.68
10.98
-3.1
-19.0
-4.8
;

proc print;
run;

[advoss]

Remember that the floor function gives you the next lower number, so 3.1 yields 3 and -3.1 yields -4.  The int function will give you 3 and -3 respectively.  So, choose the one that meets your specific needs.