title: SAS date conversion from text.
body: <p>Hi I have a date conversion problem in SAS, 
  I imported an excel file which has the following dates., </p>
  
  <pre><code>2012-01-09
  2011-01-31
  2010-06-28
  2005-06-10
  2012-09-19
  2012-09-19
  2007-06-12
  2012-09-20
  2004-11-01
  2007-03-27
  2008-06-23
  2006-04-20
  2012-09-20
  2010-07-14
  </code></pre>
  
  <p>after I imported the dates have changed like this</p>
  
  <pre><code>40917
  40574
  40357
  38513
  41171
  41171
  39245
  41172
  38292
  39168
  39622
  38827
  41172
  40373
  </code></pre>
  
  <p>I have used the input function to convert the dates but it gives a strange result., 
  the code I used., </p>
  
  <pre><code>want_date=input(have_date, anydtdte12.);
  informat want_date date9.; format have_date date9.;run;
  </code></pre>
  
  <p>I get very stange and out of the World dates., any idea how can I convert these? </p>