topic Last decimal truncated in SAS Procedures

Last decimal truncated

Lorenzom — Fri, 03 Apr 2015 10:02:40 GMT

Dear all,

I am going crazy with this problem.

I want to generate a number starting from a date and a string like 2456701

I want to obtain a decimal number like xxxxxx,2456701 where xxxx is the difference between a date and a threshold

length threshold date_formatted site_factor 8.;

threshold = put(input('01JAN2000:00:00:00.000', DATETIME22.3),8.);

date_formatted = put(vardate, 8.) ;
site_factor = date_formatted - treshold;

site = site_factor + pno*0.0000001;

the pno is 2456701 but I obtain a number like 234534.245670

Any help will be very appreciated. 🐵

Thank you

Kurt_Bremser — Fri, 03 Apr 2015 10:44:50 GMT

You are running out of precision. SAS "only" has a mantissa of 52 bytes.

2**52 = 4503599627370496

data_null__ — Fri, 03 Apr 2015 11:03:01 GMT

Your code that use PUT function and then takes different of the two character values makes no sense to me.

I don't think you can have the accuracy you seek with 8 byte floating point numeric for SITE. You can make it character.

Perhaps using something like this, after you fix the calculation of SITE.

length site $20; maybe

site = catx(',',site_factor,pno);

Tom — Fri, 03 Apr 2015 11:05:28 GMT

Why are trying to subtract the two character variables you created with the PUT() function call?

Also there are about 480 million seconds between the beginning of the century and now.

Perhaps you can use minutes or days instead to get a smaller number?