Thank you everyone for the input. However, I ended up doing things a bit differently...I was able to get the entire thing into one PROC SQL. It looks something like this... proc sql; create table Referrals as select a.REFERRAL_ID, a.ENTRY_DATE, a.START_DATE, a.SERV_DATE, s.NAME AS RFL_STATUS label='RFL_STATUS', r.NAME AS RFL_TYPE label='RFL_TYPE', q1.PROV_NAME as PCP_NAME label='PCP_NAME', q.PROV_NAME as REFERRING_PROV label='REFERRING_PROV', q2.PROV_NAME as REFERRED_TO_PROV label='REFERRED_TO_PROV', p.VENDOR_NAME AS REFERRED_TO_VENDOR label='REFERRED_TO_VENDOR', a.PAT_ID, t.PAT_NAME, i.PROC_CODE as PROC_CODE_1 label='PROC_CODE_1', i.PROC_NAME as PROC_NAME_1 label='PROC_NAME_1', j.PROC_CODE as PROC_CODE_2 label='PROC_CODE_2', j.PROC_NAME as PROC_NAME_2 label='PROC_NAME_2', k.PROC_CODE as PROC_CODE_3 label='PROC_CODE_3', k.PROC_NAME as PROC_NAME_3 label='PROC_NAME_3', l.PROC_CODE as PROC_CODE_4 label='PROC_CODE_4', l.PROC_NAME as PROC_NAME_4 label='PROC_NAME_4', m.PROC_CODE as PROC_CODE_5 label='PROC_CODE_5', m.PROC_NAME as PROC_NAME_5 label='PROC_NAME_5', n.PROC_CODE as PROC_CODE_6 label='PROC_CODE_6', n.PROC_NAME as PROC_NAME_6 label='PROC_NAME_6', o.PROC_CODE as PROC_CODE_7 label='PROC_CODE_7', o.PROC_NAME as PROC_NAME_7 label='PROC_NAME_7' from (select * from database.referral where datepart(START_DATE) >= '01-JUL-2015'd and datepart(START_DATE) <= '30-JUL-2015'd and RFL_STATUS_C ne 4) a left join (select * from database.referral_px where line = 1) b on a.REFERRAL_ID = b.REFERRAL_ID left join (select * from database.referral_px where line = 2) c on a.REFERRAL_ID = c.REFERRAL_ID left join (select * from database.referral_px where line = 3) d on a.REFERRAL_ID = d.REFERRAL_ID left join (select * from database.referral_px where line = 4) e on a.REFERRAL_ID = e.REFERRAL_ID left join (select * from database.referral_px where line = 5) f on a.REFERRAL_ID = f.REFERRAL_ID left join (select * from database.referral_px where line = 6) g on a.REFERRAL_ID = g.REFERRAL_ID left join (select * from database.referral_px where line = 7) h on a.REFERRAL_ID = h.REFERRAL_ID left join database.cl_eap i on b.PX_ID = i.PROC_ID left join database.cl_eap j on c.PX_ID = j.PROC_ID left join database.cl_eap k on d.PX_ID = k.PROC_ID left join database.cl_eap l on e.PX_ID = l.PROC_ID left join database.cl_eap m on f.PX_ID = m.PROC_ID left join database.cl_eap n on g.PX_ID = n.PROC_ID left join database.cl_eap o on h.PX_ID = o.PROC_ID left join database.cl_VENDOR p on a.VENDOR_ID = p.VENDOR_ID left join database.cl_SER q on a.REFERRING_PROV_ID = q.PROV_ID left join database.cl_SER q1 on a.PCP_PROV_ID = q1.PROV_ID left join database.cl_SER q2 on a.REFERRAL_PROV_ID = q2.PROV_ID left join database.ZC_RFL_TYPE r on a.RFL_TYPE_C = r.RFL_TYPE_C left join database.ZC_RFL_STATUS s on a.RFL_STATUS_C = s.RFL_STATUS_C left join database.PATIENT t on a.PAT_ID = t.PAT_ID; quit; There were obviously QUITE a few tables that I needed to add in to get all of my fields. The code works perfectly and produces exactly what I need. Though, I'm still going to try some of the above methods!
... View more
