numbers format in import file

ramonsi2 — Fri, 12 Nov 2021 02:11:23 GMT

*Format number

How Can import a file whit 19 Digit number format field.

Ex: 7086754897126543865

Re: numbers format in import file

Tom — Fri, 12 Nov 2021 02:36:18 GMT

@ramonsi2 wrote:
*Format number

How Can import a file whit 19 Digit number format field.

Ex: 7086754897126543865

What do you mean by "IMPORT"?

If the value is in a text file then do not "import' it. Instead READ it from the text file with a data step.

If you have a 19 digit string in a text file then read it as a character variable. If you try to read it as a number you will "lose" some of the digits. SAS stores numbers as 64-bit binary floating point values. You cannot represent 19 digits exactly without some possible values being rounded to a multiple of two because there are not enough bits used for representing the value (the rest of the bits are used to store the magnitude (power of 2).

Re: numbers format in import file

Kurt_Bremser — Fri, 12 Nov 2021 06:32:41 GMT

If this is not a number used in calculations, read it as character.

topic Re: numbers format in import file in SAS Enterprise Guide

numbers format in import file

Re: numbers format in import file

Re: numbers format in import file