topic Re: Drop zeros after rounding in SAS Programming

Drop zeros after rounding

luvscandy27 — Wed, 29 Nov 2023 16:56:26 GMT

I am having a hard time finding out how to drop the zeros after round. For example, i have data like 842855. After using the round function, the

data is like this 843000. however, I would like the data to show 843.

Re: Drop zeros after rounding

PaigeMiller — Wed, 29 Nov 2023 17:27:25 GMT

Divide by 1000?

Picture format?

Re: Drop zeros after rounding

A_Kh — Wed, 29 Nov 2023 17:28:21 GMT

I don't think 843 would be meaningful expression for 842855 after rounding. However, if you really need 3 digits number then you could divide the value (843000) by 1000, or whatever number of zeros at the end of your actual value.

data have;
a=842855;
want= round(a,1000)/1000;
proc print; run;

Re: Drop zeros after rounding

PaigeMiller — Wed, 29 Nov 2023 17:35:47 GMT

@A_Kh wrote:

I don't think 843 would be meaningful expression for 842855 after rounding.

At least where I work, we sometimes express dollar amounts as an integer representing thousands of dollars.