User:Zysun

--2008

CREATE TABLE Q2014_SHR_997781_01pp_herang_1_2008 SELECT distinct pat_id FROM  IMS201312.CLAIMS WHERE from_dt BETWEEN '2008-01-01' AND '2008-12-31' AND   (       A.diag_admit = '2776' OR 	   A.diag1 = '2776' OR	   A.diag2 = '2776' OR	   A.diag3 = '2776' OR	   A.diag4 = '2776' OR	   A.diag5 = '2776' OR	   A.diag6 = '2776' OR	   A.diag7 = '2776' OR	   A.diag8 = '2776' OR	   A.diag9 = '2776' OR	   A.diag10 = '2776' OR	   A.diag11 = '2776' );

SELECT '1_2008' AS STEP, COUNT(distinct pat_id) FROM Q2014_SHR_997781_01pp_herang_1_2008; --

---Hereditary Angioedema AND Firazyr---

--2008

CREATE TABLE Q2014_SHR_997781_01pp_herang_2_2008 SELECT distinct A.pat_id FROM  IMS201312.CLAIMS A, Q2014_SHR_997781_01pp_herang_1_2008 B WHERE  A.pat_id=B.pat_id AND   A.from_dt BETWEEN '2008-01-01' AND '2008-12-31' AND   A.NDC IN ('54092070202', '54092070203');

SELECT '2_2008' AS STEP, COUNT(distinct pat_id) FROM Q2014_SHR_997781_01pp_herang_2_2008; --

---Hereditary Angioedema AND Cinryze---

--2008

CREATE TABLE Q2014_SHR_997781_01pp_herang_3_2008 SELECT distinct A.pat_id FROM  IMS201312.CLAIMS A, Q2014_SHR_997781_01pp_herang_1_2008 B WHERE  A.pat_id=B.pat_id AND   A.from_dt BETWEEN '2008-01-01' AND '2008-12-31' AND   A.NDC = '42227008105';

SELECT '3_2008' AS STEP, COUNT(distinct pat_id) FROM Q2014_SHR_997781_01pp_herang_3_2008; --

---Hereditary Angioedema AND Firazyr AND Cinryze---

--2008

CREATE TABLE Q2014_SHR_997781_01pp_herang_4_2008 SELECT distinct A.pat_id FROM  IMS201312.CLAIMS A, Q2014_SHR_997781_01pp_herang_2_2008 B WHERE  A.pat_id=B.pat_id AND   A.from_dt BETWEEN '2008-01-01' AND '2008-12-31' AND   A.NDC = '42227008105';

SELECT '4_2008' AS STEP, COUNT(distinct pat_id) FROM Q2014_SHR_997781_01pp_herang_4_2008; --