title: How to delete the row with missing character values using SAS
body: <p>I have a data set like this:</p>
  
  <pre><code>id     type       time
  70657  23E  Nov  4 2002 12:00AM
  61651  12R  
  11603  DQ2  
  45819       Jul 23 2013 12:00AM
         732  Mar  4 2011 12:00AM
  22810  231
  </code></pre>
  
  <p>I want to do two things with missing values. 
  The first thing is how to remove the rows if the values of the variable time is " ".</p>
  
  <p>desired output1</p>
  
  <pre><code>id     type       time
  70657  23E  Nov  4 2002 12:00AM 
  45819       Jul 23 2013 12:00AM
         732  Mar  4 2011 12:00AM
  </code></pre>
  
  <p>The second thing is to remove the rows if there is any missing values.</p>
  
  <p>desired output2</p>
  
  <pre><code>id     type       time
  70657  23E  Nov  4 2002 12:00AM
  </code></pre>
  
  <p>SAS code:</p>
  
  <pre><code>data character;
    length id type time $ 24;
    input id $ 1-5 type $ 8-10 time $ 13-31;
  cards;
  70657  23E  Nov  4 2002 12:00AM
  61651  12R  
  11603  DQ2  
  45819       Jul 23 2013 12:00AM
         732  Mar  4 2011 12:00AM
  22810  231
  ;
  run;
  </code></pre>