Trending Report

[Son_Of_Krypton]

Hi Have number of tables in work library and want to combined result of below query in a one table 

SELECT count(distinct Client_Key)
FROM work.Table_C
WHERE Memberstatus='Existing'

SELECT count(distinct Client_Key)
FROM work.Table_2019_07_jul
WHERE Memberstatus='Existing'

SELECT count(distinct client_key)
FROM work.Table_2019_06_jun
WHERE Memberstatus='Existing'

SELECT count(distinct Client_Key)
FROM work.Table_2019_05_may
WHERE Memberstatus='Existing'

[Kurt_Bremser]

proc sql;
create table all as
  select count(distinct Client_Key) as count
  from work.Table_C
  where Memberstatus='Existing'
union all
  select count(distinct Client_Key) as count
  from work.Table_2019_07_jul
  where Memberstatus='Existing'
union all
  select count(distinct client_key) as count
  from work.Table_2019_06_jun
  where Memberstatus='Existing'
union all
  select count(distinct Client_Key) as count
  from work.Table_2019_05_may
  where Memberstatus='Existing'
;
quit;