leannemcn13

using sashelp to delete column

Mar 10th, 2017
298
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. proc sql noprint;
  2.   select count (*) into : var_exist from sashelp.vcolumn where memname="AE" and name="AECAT";
  3. quit;
  4. %put &var_exist;
  5.  
  6. data var_drop;
  7.   set ae1;
  8.  
  9. if &var_exist = 0 then delete AECAT;
  10. run;
RAW Paste Data