## limit all numberic variables with 2 decimals

Solved
Super Contributor
Posts: 328

# limit all numberic variables with 2 decimals

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.

Accepted Solutions
Solution
‎04-26-2016 12:30 PM
Super User
Posts: 23,661

## Re: limit all numberic variables with 2 decimals

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.

All Replies
Solution
‎04-26-2016 12:30 PM
Super User
Posts: 23,661

## Re: limit all numberic variables with 2 decimals

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.

Posts: 3,852

## Re: limit all numberic variables with 2 decimals

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

Super Contributor
Posts: 328

## Re: limit all numberic variables with 2 decimals

yes, the W in W.2
Posts: 3,852

## Re: limit all numberic variables with 2 decimals

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.

Super Contributor
Posts: 328

## Re: limit all numberic variables with 2 decimals

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

Super User
Posts: 9,599

## Re: limit all numberic variables with 2 decimals

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.

Super Contributor
Posts: 328

## Re: limit all numberic variables with 2 decimals

actually I meant formatting, just for display
🔒 This topic is solved and locked.