topic Re: Can we round all the numeric variables to one length (format) at once? in SAS Programming

Can we round all the numeric variables to one length (format) at once?

SASuserlot — Sat, 11 Dec 2021 17:12:52 GMT

I have the different numeric variable with different number of digits after the decimal. Is it possible to convert them to same number of digits after decimal in one attempt by ROUNDING the digits, instead of applying the format each variable separately. Thank you

data orci;
 input effect$ a b c d e f;
 cards;
 points 1.05 1.055 1.0554 1.05545 1.055454 1.055455
;
run;

Re: Can we round all the numeric variables to one length (format) at once?

PaigeMiller — Sat, 11 Dec 2021 17:39:07 GMT

@SASuserlot wrote:

Is it possible to convert them to same number of digits after decimal in one attempt by ROUNDING the digits, instead of applying the format each variable separately.

You could round the values one variable at a time, I don't see how that's any better than formatting each variable separately. And it really isn't that hard to format each variable in one line of code.

format a--f 10.2;

In fact, in my opinion, rounding the values is a poor decision, if there are additional calculations that will be performed on this data.

Which brings up the question ... why do you ask? What is the reason for either rounding them all or formatting them all?

Re: Can we round all the numeric variables to one length (format) at once?

SASuserlot — Sat, 11 Dec 2021 17:41:49 GMT

Thank you so much. Yes agree with you, in case if any additional calculations. In my case, these numbers at the end of all the calculations . Thanks again.

Re: Can we round all the numeric variables to one length (format) at once?

ballardw — Sun, 12 Dec 2021 04:01:11 GMT

ALL numeric variables use the list word _numeric_.

Format _numeric_ f8.1

Actual round isn't much harder:

data new;
   set old;
   array _nn (*) _numeric_;
   do i=1 to dim (_nn);
      _nn[i] = round(_nn[i], 0.1);
   end;
   drop i;
run;

make sure to pick an array name that doesn't duplicate that of an existing variable.