topic Re: How to truncate to 10 decimal places without rounding in sas? in New SAS User

How to truncate to 10 decimal places without rounding in sas?

amber7391 — Wed, 25 Sep 2019 19:35:16 GMT

Hi genius SAS people.

Can anyone help me with some truncate problem. I really appreciate it!

I have a dataset-->have as the following.

have
id	probability
1	1.23
1	2.345
1	1
1	0.222
2	1
2	2
3	1.6678
4	0.8987
5	1.2345
5	0.4566
5	1.44888

Now, I want to multiply the probabilities and group by id. Also, I need to truncate the decimal places to 10 decimal places without rounding.

The following is how I want my result look like. Also, I would like to apply the truncate function to the whole column.

id	probability	want
1	1.232.3451*0.222	0.6403257
2	1*2	2
3	1.6678	1.6678
4	0.8987	0.8987
5	1.23450.45661.44888	0.816694101576	<--	0.8166941015

Re: How to truncate to 10 decimal places without rounding in sas?

Tom — Wed, 25 Sep 2019 19:38:45 GMT

int(value*10**10)/10**10

Re: How to truncate to 10 decimal places without rounding in sas?

Ksharp — Thu, 26 Sep 2019 12:18:31 GMT

proc format ;
picture fmt
 low-hight='9.0000000000';
run;
data x;
input x;
format x fmt20.10;
cards;
0.6403257	 	 
2	 	 
1.6678	 	 
0.8987	 	 
0.816694101576
;