limit all numberic variables with 2 decimals

[fengyuwuzu]

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.

[Reeza · Accepted solution]

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. 

[data_null__]

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.?

[fengyuwuzu]

yes, the W in W.2

[data_null__]

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.

[fengyuwuzu]

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

[RW9]

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.

[fengyuwuzu]

actually I meant formatting, just for display