title: how to overcome missing values when importing date from excel to sas 9.4
body: <p>I am trying to import an excel sheet into sas9.4. Interestingly, I can import most of the data without any problem. But for the date, there are lots of random missing values (there is no missing date in my excel file). Can anyone tell me how to improve my code please.</p>
  
  <pre><code>proc import out= sheet 
      datafile = 'D:\Date.xlsx'
      dbms = excelcs  replace;
      sheet = "abc" ;
       SCANTEXT=YES;
       USEDATE=YES;
       SCANTIME=NO;
  run;
  </code></pre>
  
  <p>all date looks like this:21/06/2010, 22/06/2010.</p>