Thanks A lot Peter. I have used the above mentioned syntax '%str( ) out= ' and '%str( ) nodupkey; by _all_; run;' .Also The Code is running and generating Outputs.But output data sets are limited to 50 only. Here is my code: data _null_; set sashelp.vtable (where=(libname="MAPSSAS")); call execute(cats('proc sort data=MAPSSAS.',memname,'%str() out=out_',memname,'%str() nodupkey; by _all_; run;')); run; by using this code proc print data=sashelp.vtable(where=(libname='PAIGE' and memtype='DATA'));
id memname;
var nobs nvar;
run; i am getting output of memname ,Nobs and Nvar, Also i need No of distinct rows for each data sets.will you please help me out. memname nobs nvar Ndistinct AFGHANI2 29 4 AFGHANIS 2644 6 AFRICA 52824 8 AFRICA2 61 10 ALGERIA 1617 6 ALGERIA2 9 4 ANDORRA 203 6 ANDORRA2 1 4 ANOMALY 12 10 ANTARCT2 5 10 ANTARCTI 18071 8 ARGENTI2 24 9 ARGENTIN 3852 6
... View more
