topic Re: Trending Report in SAS Programming

Trending Report

Son_Of_Krypton — Tue, 19 Jan 2021 11:08:33 GMT

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'

Re: Trending Report

Kurt_Bremser — Tue, 19 Jan 2021 11:34:34 GMT

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;