topic Re: How to force an integer to show decimal points in rounding in SAS Programming

How to force an integer to show decimal points in rounding

nessak — Thu, 29 Sep 2022 19:26:54 GMT

Hi all,

First time posting, so apologies if I'm not doing this correctly.

I need to create reports where all the numbers are rounded to two decimal points. The code I have works, except for when the observation is a whole number. For example, 2.4378 will round to 2.44 like I want it to, but a flat 5 just shows up as 5. I would like it to show as 5.00 but am having trouble figuring out how to do so.

Here is one example:

data raw_deltas;
	set &dat._p_;

	%do i=1 %to &t;
		t&i = round(t&i, 0.01);
	%end;

	%do i=2 %to &t;
		delta&i = round(delta&i, 0.01);
		delta_&i = round(delta_&i, 0.01);
	%end;
run;

Thanks in advance!

Re: How to force an integer to show decimal points in rounding

ballardw — Thu, 29 Sep 2022 19:34:17 GMT

Assign a format to the variable like F9.2 That will display the value as 9 characters including 2 decimals. Use a number larger than 9 if you need more positions. Generally any thing related to display of a single value can be resolved with a proper format.

Maybe

data raw_deltas;
	set &dat._p_;

	%do i=1 %to &t;
		t&i = round(t&i, 0.01);
	%end;

	%do i=2 %to &t;
		delta&i = round(delta&i, 0.01);
		delta_&i = round(delta_&i, 0.01);
	%end;
   format t1-t&t.  delta2-delta&t. delta_2-delta_&t. F9.2;
run;

Re: How to force an integer to show decimal points in rounding

nessak — Thu, 29 Sep 2022 19:41:49 GMT

thank you so much! that worked 🙂