Hi Team,
Looking to satisfy the below condition and get an output accordingly. Please see below.
data data.my_data;
input my_number;
datalines;
80.000000001
1000.01
879.987
70.987656
13.097360083
;
Run;
New my_number1 column should be satisfying the below conditions:
1. my_number1 should be rounded to 2 decimal places
2. my_number1 should be rounded to 2nd decimal if the my_number has any non zero value in the 3rd to 9th decimal places. Example: If my_number is 80.000000001, round up to 80.01
3. If my_number is greater than 999.99 then my_number1 is set to 999.99
Please show us what you have tried so far.
Not sure what type of rounding that is. Does below return the desired result? If not then please provide the desired result based on your sample data. What should happen if there is a non-zero value on the 10th or later decimal?
data have;
input my_number;
datalines;
80.000000001
1000.01
879.987
70.987656
13.097360083
.
;
data want;
set have;
format my_number derived_num 16.9;
if not missing(my_number) then
derived_num=min(999.99,ceilz(my_number*100)/100);
run;
proc print data=want;
run;
Hi @Patrick , this is great. Thank you very much for this. Will try and incorporate this into my code.
Would it be possible to round the "derived_num" column to 2 decimal places?
Example: if I use the round function on column "derived_num" to give me 2 decimal places after the decimal point, then Obs 5 would be 13.1, is it possible to get 13.10?
There is no difference between 13.1 and 13.10. They are the same number.
If you want the value to always be displayed using 2 decimal places then attach a format that 2 for the number of decimal places.
format derived_num 8.2 ;
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 16. 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: