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.
Use
yr = round(yr,.01);
to round up to the second fractional digit.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.