title: SAS - Excel Import DateTime not retaining enough significant digits
body: <p>As the title states, I'm having issues importing datetimes from Excel to SAS. The issue seems to be with seconds:</p>
  
  <p>here's sample data from excel:</p>
  
  <p>My DateTime:</p>
  
  <p><a href="https://i.stack.imgur.com/xmB7P.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xmB7P.png" alt="enter image description here"></a></p>
  
  <p>Here's the raw excel numbers:</p>
  
  <p><a href="https://i.stack.imgur.com/K6aGj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K6aGj.png" alt="enter image description here"></a></p>
  
  <p>Edit2:</p>
  
  <pre><code>43417.58657407
  43417.58656250
  </code></pre>
  
  <p>When I'm import these into SAS, this is how SAS is displaying them:</p>
  
  <pre><code>13NOV2018:14:04:39
  13NOV2018:14:04:39
  </code></pre>
  
  <p>and the numeric values:</p>
  
  <pre><code>1857737079
  1857737079
  </code></pre>
  
  <p>I'm trying to figure out how to get SAS to read the seconds correctly. I'm using proc import and here's my code:</p>
  
  <pre><code>proc import
  out = MyDSOutput
  datafile= MyDSInput
  dbms     = EXCEL replace;
  sheet    = "page";
  getnames = yes;
  mixed    = yes;
  scantext = yes;
  usedate  = no;
  scantime = yes;
  textsize = 32767;
  ;
  run;
  </code></pre>
  
  <p>EDIT: I should have added that converting this to a CSV really isn't an option because I have numeric IDs that are  >15 digits and excel will convert anything >15 digits to 0s.</p>
  
  <p>EDIT2: Added an expanded version of the raw excel numbers</p>