Get list of all tables with it's count from a specific library in one table

[Son_Of_Krypton]

Hi i want to take list of all the tables with it's observations count and distinct primary_key count from all the tables. from a specific library in another table

All the tables has common primary_key. like Agreement_Key.

How do i do that.?

[Kurt_Bremser]

I guess I already gave you the answer in your previous thread, but here is:

data
  myfold.class1
  myfold.class2
;
set sashelp.class;
run;

proc sql noprint;
select
  catx(".",libname,memname) into :dsnames separated by " "
  from dictionary.tables
  where libname = "MYFOLD"
;
quit;

data all / view=all;
length dsname dname $41;
set &dsnames indsname=dname;
dsname = dname;
run;

proc sql;
create table want as
  select
  dsname,
  count(*) as count,
  count(distinct sex) as d_count
  from all
  group by dsname
;
quit;