topic want only 2 decimals in New SAS User

want only 2 decimals

Smitha9 — Tue, 24 Aug 2021 20:41:24 GMT

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

Re: want only 2 decimals

Kurt_Bremser — Tue, 24 Aug 2021 20:51:46 GMT

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

Re: want only 2 decimals

Cynthia_sas — Tue, 24 Aug 2021 21:00:03 GMT

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