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

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

ADouglas — Thu, 12 Dec 2019 19:03:41 GMT

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

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

SASKiwi — Thu, 12 Dec 2019 19:34:08 GMT

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.

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

Kurt_Bremser — Thu, 12 Dec 2019 20:20:12 GMT

Looks like the default BEST12. display format.