Here is the code but the problem is that the computer crashed and what they took from my old and gave me on a disk has been placed on my new machine but for some reason it does not recogniz table final11 as a dataset. I can pull it up in SAS just fine and it looks like table. I cannot rerun the prior because this overall code takes 123GB and 5 days in all to run. thus the reason my computer crashed. Was just too much for it. Fan burned out and processor stopped. But because of the costs associated with running this overall code my manager prefers that I get what was on my C drive from old and go from there. I had all the final tables I needed with coding dropping the old due to size. Like I said the overall program is 123GB and my computer has only a 150GB hard drive. Cheap company that will not give programmers more space. Therefore our computers crash and we lose data. Anyway. Table final11 is fine and in there but it just does not understand that the table is a dataset. so I need to somehow make it understand that so I can run this code below. proc sql ; create table cardiac.final11b as (select distinct a.*, case when a.adj_hccc_cd ='07' or a.prov_mpin_pci=. then . else outpt_mpin_flg end as outpt_pci_mpin_flg, case when a.adj_hccc_cd ='07' or a.prov_mpin_pci=. then . else outpt_mpin_prov end as outpt_pci_prov_mpin, case when a.adj_hccc_cd ='07' or a.prov_mpin_pci=. then ' ' else outpt_tin_prov end as outpt_pci_prov_tin, case when BUS_LINE_DESC='MEDICARE' and prov_tin_mbr=1 THEN 1 END AS MEDICARE_prov_tin, CASE WHEN BUS_LINE_DESC='COMMERCIAL' and prov_tin_mbr=1 THEN 1 END AS COMMERCIAL_prov_tin, case when BUS_LINE_DESC='MEDICARE' and member=1 THEN 1 END AS MEDICARE_nat, CASE WHEN BUS_LINE_DESC='COMMERCIAL' and member=1 THEN 1 END AS COMMERCIAL_nat, case when BUS_LINE_DESC='MEDICARE' and prov_mpin_mbr=1 THEN 1 END AS MEDICARE_prov_mpin, CASE WHEN BUS_LINE_DESC='COMMERCIAL' and prov_mpin_mbr=1 THEN 1 END AS COMMERCIAL_prov_mpin, CASE WHEN BUS_LINE_DESC='COMMERCIAL' and unique_fac_mpin=1 THEN 1 END AS COMMERCIAL_fac_mpin, case when BUS_LINE_DESC='MEDICARE' and unique_fac_mpin=1 THEN 1 END AS MEDICARE_fac_mpin, CASE WHEN BUS_LINE_DESC='COMMERCIAL' and unique_fac_mpin=1 THEN 1 END AS COMMERCIAL_fac_tin, case when BUS_LINE_DESC='MEDICARE' and unique_fac_mpin=1 THEN 1 END AS MEDICARE_fac_tin from cardiac.final11 a left join (select distinct mbr_sys_id, fst_srvc_dt, prov_tin as outpt_tin_prov, prov_mpin as outpt_mpin_prov, case when prov_mpin>. then 1 end as outpt_mpin_flg from cardiac.final11 where adj_hccc_cd='07' and prov_mpin_pci=1)b on a.mbr_sys_id=b.mbr_sys_id and a.fst_srvc_dt=b.fst_srvc_dt); quit;
... View more