topic Re: Help with text file import in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197503#M49353 <HTML><HEAD></HEAD><BODY><P>read it as character?</P><P>You can only store about 16 digits using the IEEE format for 8 byte floating point numbers that SAS uses for numbers.</P></BODY></HTML> Tue, 07 Jul 2015 19:47:13 GMT Tom 2015-07-07T19:47:13Z Help with text file import https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197502#M49352 <HTML><HEAD></HEAD><BODY><P>I am importing a text file into a SAS dataset which will then be loaded into a Teradata table. The issue I am having is with one of the fields in the text file. Below is a sample of the data from that field. My question is what would be the best format for reading in this data? I tried best32. but that didn't work.</P><P></P><P>field3</P><P>3185367700.7657785</P><P>4.3712247081415856E-2</P><P>-4.449917808054182E-3</P><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Tue, 07 Jul 2015 19:21:23 GMT https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197502#M49352 Jacko 2015-07-07T19:21:23Z Re: Help with text file import https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197503#M49353 <HTML><HEAD></HEAD><BODY><P>read it as character?</P><P>You can only store about 16 digits using the IEEE format for 8 byte floating point numbers that SAS uses for numbers.</P></BODY></HTML> Tue, 07 Jul 2015 19:47:13 GMT https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197503#M49353 Tom 2015-07-07T19:47:13Z Re: Help with text file import https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197504#M49354 <HTML><HEAD></HEAD><BODY><P>I don't know about Teradata, but don't use SAS if you need more than IEEE floating point precision (about 15 digits). Then why would you need that much precision?</P><P></P><P>PG</P></BODY></HTML> Tue, 07 Jul 2015 19:52:43 GMT https://communities.sas.com/t5/SAS-Procedures/Help-with-text-file-import/m-p/197504#M49354 PGStats 2015-07-07T19:52:43Z