Hi All, I'm trying to create a process that exports data to a txt file with a trail record with some information which includes the check sum of a particular variable. The process works fine, but we are having some issues with decimal places. Sample code below: RETAIN CHKSUM;
CHKSUM = SUM(ROUND(CHKSUM,0.01),ROUND(&CHKSUM_VAR,0.01));
IF LAST THEN DO;
NOBS = _N_;
PUT CHKSUM;
END; The txt file is later on imported in Azure using spark and they have some controls where they sum one particular variable of the file and compare with the check sum value. This process works for some files but not for others, the import fails because the check sum is not matching with the sum of the variable in the file and the only explanation is the decimal precision in SAS. We tried several different ways of doing it and they all end up with a slightly different number in the check sum and issues with the import in Azure. I'm almost convinced that this can't be fixed given that SAS stores data in binary format which can cause some precision issues like this. Would be good to have different opinions on this as I think I've exhausted my ideas on how to fix this. PS: Sorry if I explained the problem badly.
... View more