04-03-2015 06:02 AM
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
04-03-2015 06:44 AM
You are running out of precision. SAS "only" has a mantissa of 52 bytes.
2**52 = 4503599627370496
04-03-2015 07:03 AM
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);
04-03-2015 07:05 AM
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?