Proc sql,
create table test1 as
select m1,f,1,l1,np1
from table k.claimtable a
inner join k.tab2 b,
ON(a.m1=b.m1)
where a.pc in ('1234') a.ser_date between '01jan2022'd and 31aug2022'd order by a.ser_date ; Proc sql,
create table test1 as
select m1,f,1,l1,np1
from table k.claimtable a
inner join k.tab3 b,
ON(a.m1=b.m1)
where a.pc in ('99999') a.ser_date between '01jan2022'd and 31aug2022'd order by a.ser_date ; we are joining proc sql's with two different tables (tab2,tab3) with 1 claims table to extract data for those procedure codes.
... View more