want only 2 decimals

[Smitha9]

Hi,

I have a dataset:

a 243.199965

b 345

c 123

I want the decimal only 2:

a 243.19

b 345.00

c 123.56

can anyone help me in this. thanks in advance

[Kurt_Bremser]

Multiply by 100, use the FLOOR function, and divide by 100. Then apply a format with 2 decimals.

[Cynthia_sas]

Hi:
There is a difference between the internally stored number and displaying a number on a report. You don't explain whether this is for a report or whether you want to change the number of decimal places in the stored data. Consider this:

You can use the round function to change the internally stored value for a variable (as I do with the creation of the NEWVAR variable). But if you only care about the display for reporting, then you might want to allow the number to have full decimal places when stored.

Cynthia