title: date function problems in sas
body: <p>I have a sas data set which has date field which is in the format "04JAN2012" and using format, I am converting it to "2012-01-04" in a separate data step.
  The problem arises when I am using a simple where statement in proc SQL which is using a 'where' condition like---- select * from temp where temp.active_date > '2012-01-01'</p>
  
  <p>The error message at this point is "Expression using equals (>) has components that are of different data types."</p>
  
  <p>Please help !</p>