Deleting dataset with no observations in macro

[Kurt_Bremser]

You need to perform the delete in the loop.

%macro apaga;
%do i =1 %to 9;
  proc sql noprint;
  select nobs into :nobs
  from dictionary.tables
  where libname = "WORK" and memname = "X&i.";
  quit;
  %if &nobs. = 0
  %then %do;
    proc delete data=work.x&i.;
    run;
  %end;
%end;
%mend;

[Angela53]

Thanks, Kurt. Your correction works perfectly!

[Angela53]

Thanks, it works perfectly!