SAS import is truncating/rounding numeric values from .csv file.

[ADouglas]

Hello SASers,

I am using proc import to import a .csv file created by excel. The file has a set of numeric variables. The values of all the variables are either 0 or 1.08695652173913. 

But, SAS is changing the value of 1.08695652173913 to the value of  1.086956522.  

Why does this happen, and what can I do to get SAS to import the exact values from the .csv file?

This is a big issue because I am summing over a large number of numeric variables, and it is resulting in a 1 point difference for each observation. 

Thanks

[SASKiwi]

How do you know SAS is actually truncating/rounding? It could just be displaying a certain number of digits by default but internally storing with full precision. Try formatting the variable as say BEST16. to confirm.

[Kurt_Bremser · Accepted solution]

Looks like the default BEST12. display format.