title: Delete empty rows in SAS
body: <p>I have data set that contains empty cells. It looks like</p>
  
  <pre><code> Year    Volume    ID    
   2000    999       LSE
   2001    .         LSE
   .       555       LSE
   2008    .         NYSE
   2010    1099      NYSE
  </code></pre>
  
  <p>I need to delete the row that contains empty cells. The output should look like this</p>
  
  <pre><code> Year    Volume    ID    
   2000    999       LSE
   2000    1099      NYSE
  </code></pre>
  
  <p>I tried following code</p>
  
  <pre><code>data test;
  set data;
  if volume = " . " then delete;
  if year= " . " then delete;
  run;
  </code></pre>
  
  <p>But output file has 0 observations and SAS gives me</p>
  
  <pre><code>    NOTE: Character values have been converted to numeric values at the       
  places given by (Line):(Column).
  </code></pre>
  
  <p>Also I tried </p>
  
  <pre><code>options missing = ' ';
  data test;
  set data;
  if missing(cats(of _all_)) then delete;
  run;
  </code></pre>
  
  <p>But its not working as well. </p>
  
  <p>I just want to delete the rows with empty cells.
  Anyone can help me to solve this issue ? Thanks in advance !!!</p>