PROC SQL; CREATE TABLE lib.a AS SELECT a.team, a.id, COUNT(DISTINCT(a.id)) AS Num_Pt, /*Patients*/ COUNT(DISTINCT(case when a.note not is missing then a.id else 0 end)) AS RCPRL_Num_Pt, /*???*/ b.Rfrl_TotalNumPt, d.totalvisit/calculated Num_pt as Avg_visit_pp format=10.2, d.totaltxn/Calculated Num_pt as Avg_txn_pp format=10.2, d.TotalPymt/Calculated Num_pt as Avg_Cost_pp format=10.2, sum(c.pt_age)/Calculated Num_pt as Avg_Pt_Age format=8.2, sum(c.Pt_Num_Days)/Calculated Num_pt as Avg_Num_SE_Days_pp format=8.2, d.totalpymt/count(distinct a.txn_date) as Avg_Cost_pd format=8.2, /*???*/ sum(input(a.unit, 8.))/Calculated Num_pt as Avg_Num_unit_pp format=8.2, d.totalpymt/sum(input(a.unit, 8.)) as Avg_Cost_penc format=8.2, /*???*/ b.cust_0_14, b.cust_15_24, b.cust_25_44, b.cust_45_64, b.cust_65plus FROM lib.a as a left join lib.b as b on (a.id = b.id) left join lib.c as c on (a.id = c.id) left join lib.d as d on (a.id = d.id) GROUP BY a.team b.id; QUIT; This is the code. All data sets have been sorted... but it'll still say sort execution failed.
... View more
