title: How do I delete multiple column variables in SAS which just state "Null" but are not blank?
body: <p>How do I delete multiple column variables in SAS which just state "Null" but are not blank? I have created the following table;</p>
  
  <pre><code>DATA test;
  INPUT name$ favourite_food$ occupation$ favourite_sport$;
  CARDS;
  John Null Nurse Null 
  Michelle Null Lawyer Null
  Peter Null Teacher Null 
  Kai Null Doctor Null 
  run;
  </code></pre>
  
  <p>Since the columns with Null values are not blank I am unsure of how to delete those columns. I do not need them for my analysis.</p>
  
  <p>Also I know I can use the drop command to drop columns. However when I have around 90 variables is there a more effecient way to drop multiple "Null" variables</p>