Last decimal truncated

[Lorenzom]

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

L.

[Kurt_Bremser]

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

2**52 = 4503599627370496

[data_null__]

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]

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?