proc sql;
create table vda_mnr as
select a.*,
b.poa1,
b.poa2,
b.poa3,
b.poa4,
b.poa5,
b.poa6,
b.poa7,
b.poa8,
b.poa9,
b.poa10,
b.poa11,
b.poa12,
b.poa13,
b.poa14,
b.poa15,
b.poa16,
b.poa17,
b.poa18,
b.poa19,
b.poa20,
c.clm_aud_nbr
from sep.current_mnr_vardays a
left join sep.ova_clmshdr_inp b
on a.case_id=b.case_id
left join sep.ip_confinement c
on b.membersystemid=c.mbr_sys_id and
b.adm_dt=c.fst_srvc_dt
where a.Low_Perdiems not in ('Y') and
a.Med_Prime not in ('Y') and
a.MH_BH_Flag in ('N') and
a.Admits=1;
quit; The file is getting damaged and i'm not able to move to further process, tried to split the above piece of code into 3 parts and ran but again same issue, and 50% of sas workspace is available can anyone suggest how to proceed with this piece of code
... View more
