Example 3: Rounding and truncating
Example 3 shows the use of the Round function. In this example we want to convert pounds to kilograms and inches to centimeters. Further, we want to round kilograms to the nearest whole number and round centimeters to the nearest tenth.
Data HTWT;
Input Weight Height;
KWeight = Weight/2.2;
CHeight = Height*2.54;
KWeight2 = Round(Weight/2.2, 1); * Rounded values;
CHeight2 = Round(Height*2.54, .1);
KWeight3 = Int(Weight/2.2); * Truncated to integer;
CHeight3 = Int(Height*2.54);
Datalines;
180 70
125 63
100 61
Proc Print data=HTWT noobs;
Run;
Which produces:
Weight Height KWeight CHeight KWeight2 CHeight2 KWeight3 CHeight3
180 70 81.8182 177.80 82 177.8 81 177
125 63 56.8182 160.02 57 160.0 56 160
100 61 45.4545 154.94 45 154.9 45 154
The syntax of the round function is:
ROUND function (data step expressions)
|
Rounding rounds up or down, depending upon the fractional portion.
Truncating drops off the fractional portion and keeps only the integer portion.