topic Re: limit all numberic variables with 2 decimals in SAS Programming

limit all numberic variables with 2 decimals

fengyuwuzu — Tue, 26 Apr 2016 14:07:11 GMT

Is there a way to change all the numeric variables in a data set to 2 decimals, without defining one by one? They have difference lengths, but I hope they all have max 2 decimals

thanks.

Re: limit all numberic variables with 2 decimals

Reeza — Tue, 26 Apr 2016 14:27:56 GMT

Format _numeric_ 8.2;

The keyword is _numeric_ which applies to all numeric variables. But be careful, dates and ID variables can be numeric as well.

Re: limit all numberic variables with 2 decimals

data_null__ — Tue, 26 Apr 2016 14:37:20 GMT

What do you mean they "they have different lengths"? Are you talking about the W in W.D as in 10 and 8 in 10.2, 8.2 etc.?

Re: limit all numberic variables with 2 decimals

RW9 — Tue, 26 Apr 2016 14:45:19 GMT

By Change, do you mean just format the output to look like it has 2 decimal places, or change the underlying value to have only two decimal places, then you would need the round() function.

Re: limit all numberic variables with 2 decimals

fengyuwuzu — Tue, 26 Apr 2016 14:56:44 GMT

actually I meant formatting, just for display

Re: limit all numberic variables with 2 decimals

fengyuwuzu — Tue, 26 Apr 2016 14:57:17 GMT

yes, the W in W.2

Re: limit all numberic variables with 2 decimals

data_null__ — Tue, 26 Apr 2016 16:17:43 GMT

Sample data with working program to read and format as it is now would be helpful. Plus an example data set of the result you desire.

@Reeza suggested the easy solution just format all the variable with W.2 where W is big enough for all values.

You're still a bit light on the details.

Re: limit all numberic variables with 2 decimals

fengyuwuzu — Tue, 26 Apr 2016 16:30:16 GMT

Thank you. I agree with you. I just need to choose a large enough W.