Hello, Below code extracts all the SAS datasets and the number of observations and variables in each dataset. %macro obsnvars(lib=); %if &lib= %then %let lib=WORK; %else %let lib=%upcase (&lib); proc sql; select memname,nobs,nvar from dictionary.tables where libname="&lib" and memtype="DATA" and memname not in ('_PRODSAVAIL'); quit; %mend obsnvars;
... View more