Format problem

fabdu92 — Fri, 24 Mar 2017 12:18:19 GMT

Hi,

I have a table t1 with two dates d1 and d2. I need to have the year difference in decimals (2decimals).

I do:

format yr 15.2;
yr= INTCK('month',d1, d2)/12;

Following this, I join with another table t2 on the number of years (with two decimals).

But it can't match except when the year t1 has decimals like

*.00

*.25

*.50

*.75

It doesn't want to match when it is decimals like

*.08

*.17

*.33

*.42

*.58

*.67

*.83

*.92

The common points of all is they are rounded to the second decimal calculations (*.33 is in fact *.33333333... whereas for table t2 it is truely *.33)

Do you know what I have to do in order to match them?

Thanks for answer.

Re: Format problem

Kurt_Bremser — Fri, 24 Mar 2017 12:38:27 GMT

Use

yr = round(yr,.01);

to round up to the second fractional digit.

topic Re: Format problem in SAS Programming

Format problem

Re: Format problem