<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Excel :Reading Exponentials in SAS Procedures</title>
    <link>https://communities.sas.com/t5/SAS-Procedures/Excel-Reading-Exponentials/m-p/44869#M11831</link>
    <description>Hi I am having a numeric variable(accno) having 20 digits but when i am importing it in to sas it was showing exponentials how can i Resolve this.&lt;BR /&gt;
I have converted the variables in to Charrater by adding a character variable .But the (account no) is not getting correctly&lt;BR /&gt;
&lt;BR /&gt;
Ex: 19867839765432678098      out:1.90E98&lt;BR /&gt;
&lt;BR /&gt;
Pl let me know</description>
    <pubDate>Wed, 07 Jul 2010 05:34:27 GMT</pubDate>
    <dc:creator>R_Win</dc:creator>
    <dc:date>2010-07-07T05:34:27Z</dc:date>
    <item>
      <title>Excel :Reading Exponentials</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/Excel-Reading-Exponentials/m-p/44869#M11831</link>
      <description>Hi I am having a numeric variable(accno) having 20 digits but when i am importing it in to sas it was showing exponentials how can i Resolve this.&lt;BR /&gt;
I have converted the variables in to Charrater by adding a character variable .But the (account no) is not getting correctly&lt;BR /&gt;
&lt;BR /&gt;
Ex: 19867839765432678098      out:1.90E98&lt;BR /&gt;
&lt;BR /&gt;
Pl let me know</description>
      <pubDate>Wed, 07 Jul 2010 05:34:27 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/Excel-Reading-Exponentials/m-p/44869#M11831</guid>
      <dc:creator>R_Win</dc:creator>
      <dc:date>2010-07-07T05:34:27Z</dc:date>
    </item>
    <item>
      <title>Re: Excel :Reading Exponentials</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/Excel-Reading-Exponentials/m-p/44870#M11832</link>
      <description>Import the account number with informat $20.&lt;BR /&gt;
&lt;BR /&gt;
Never store an account number in a numeric variable.&lt;BR /&gt;
&lt;BR /&gt;
You can't store 20 digits in a numeric SAS variable with full precision - and you sure don't want to change account numbers when rounding happens &lt;span class="lia-unicode-emoji" title=":winking_face:"&gt;😉&lt;/span&gt;&lt;BR /&gt;
&lt;BR /&gt;
HTH&lt;BR /&gt;
Patrick</description>
      <pubDate>Wed, 07 Jul 2010 06:44:40 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/Excel-Reading-Exponentials/m-p/44870#M11832</guid>
      <dc:creator>Patrick</dc:creator>
      <dc:date>2010-07-07T06:44:40Z</dc:date>
    </item>
  </channel>
</rss>

