data med; set med; ****************** ELIXHAUSER ******************; elx_grp_1 = (diag in ('398','402','425','428')) | (diag_icd5 in: ('39891','40201','40211','40291','40401','40403','40411','40413','40491','40493', '4254','4255','4257','4258','4259','428')); label elx_grp_1 = 'Congestive Heart Failure'; elx_grp_2 = (diag in ('426','427')) | (diag_icd5 in: ('4260','42613','4267','4269','42610','42612','4270','4271','4272','4273', '4274','4276','4278','4279','7850','99601','99604','V450','V533')); label elx_grp_2 = 'Cardiac Arrhythmia'; elx_grp_3 = (diag in ('394','395','396','397','424','746')) | (diag_icd5 in: ('0932','394','395','396','397','424','7463','7464','7465','7466','V422','V433')); label elx_grp_3 = 'Valvular Disease'; elx_grp_4 = (diag in ('415','416','417')) | (diag_icd5 in: ('4150','4151','416','4170','4178','4179')); label elx_grp_4 = 'Pulmonary Circulation Disorders'; elx_grp_5 = (diag in ('440','441','443','447','557')) | (diag_icd5 in: ('0930','4373','440','441','4431','4432','4438','4439','4471','5571','5579','V434')); label elx_grp_5 = 'Peripheral Vascular Disorders'; elx_grp_6 = (diag = '401') | (diag_icd5 =: '401'); label elx_grp_6 = 'Hypertension Uncomplicated'; elx_grp_7 = (diag in ('402','403','404','405')) | (diag_icd5 in: ('402','403','404','405')); label elx_grp_7 = 'Hypertension Complicated'; elx_grp_8 = (diag in ('334','342','343','344')) | (diag_icd5 in: ('3341','342','343','3440','3441','3442','3443','3444','3445','3446','3449')); label elx_grp_8 = 'Paralysis'; elx_grp_9 = (diag in ('331','332','333','334','335','336','340','341','345','348')) | (diag_icd5 in: ('3319','3320','3321','3334','3335','33392','334','335','3362','340', '341','345','3481','3483','7803','7843')); label elx_grp_9 = 'Other Neurological Disorders'; elx_grp_10 = (diag in ('416','490','491','492','493','494','495', '496','500','501','502','503','504','505')) | (diag_icd5 in: ('4168','4169','490','491','492','493','494','495','496','500', '501','502','503','504','505','5064','5081','5088')); label elx_grp_10 = 'Chronic Pulmonary Disease'; elx_grp_11 = (diag='250') | (diag_icd5 in: ('2500','2501','2502','2503')); label elx_grp_11 = 'Diabetes Uncomplicated'; *** 3-digit codes overlap with # 11; elx_grp_12 = (diag_icd5 in: ('2504','2505','2506','2507','2508','2509')); label elx_grp_12 = 'Diabetes Complicated'; elx_grp_13 = (diag in ('240','243','244','246')) | (diag_icd5 in: ('2409','243','244','2461','2468')); label elx_grp_13 = 'Hypothyroidism'; elx_grp_14 = (diag in ('403','585','586','588','V56')) | (diag_icd5 in: ('40301','40311','40391','40402','40403','40412','40413','40492','40493','585', '586','5880','V420','V451','V56')); label elx_grp_14 = 'Renal Failure'; elx_grp_15 = (diag in ('070','456','570','571','572','573')) | (diag_icd5 in: ('07022','07023','07032','07033','07044','07054','0706','0709','4560','4561', '4562','570','571','5722','5723','5724','5728','5733','5734','5738','5739','V427')); label elx_grp_15 = 'Liver Disease'; elx_grp_16 = (diag in ('531','532','533','534')) | (diag_icd5 in: ('5317','5319','5327','5329','5337','5339','5347','5349')); label elx_grp_16 = 'Peptic Ulcer Disease excluding bleeding'; elx_grp_17 = (diag in ('042','043','044')) | (diag_icd5 in: ('042','043','044')); label elx_grp_17 = 'AIDS/HIV'; elx_grp_18 = (diag in ('200','201','202','203')) | (diag_icd5 in: ('200','201','202','2030','2386')); label elx_grp_18 = 'Lymphoma'; elx_grp_19 = (diag in ('196','197','198','199')) | (diag_icd5 in: ('196','197','198','199')); label elx_grp_19 = 'Metastatic Cancer'; elx_grp_20 = (diag in ('140','141','142','143','144','145','146','147','148','149', '150','151','152','153','154','155','156','157','158','159', '160','161','162','163','164','165','166','167','168','169', '170','171','172','174','175','176','177','178','179','180', '181','182','183','184','185','186','187','188','189','190', '191','192','193','194','195')) | (diag_icd5 in: ('140','141','142','143','144','145','146','147','148','149', '150','151','152','153','154','155','156','157','158','159', '160','161','162','163','164','165','166','167','168','169', '170','171','172','174','175','176','177','178','179','180', '181','182','183','184','185','186','187','188','189','190', '191','192','193','194','195')); label elx_grp_20 = 'Solid Tumour without Metastasis'; elx_grp_21 = (diag in ('446','701','710','711','714','719','720','725','728')) | (diag_icd5 in: ('446','7010','7100','7101','7102','7103','7104','7108','7109','7112', '714','7193','720','725','7285','72889','72930')); label elx_grp_21 = 'Rheumatoid Arthritis/Collagen'; elx_grp_22 = (diag in ('286','287')) | (diag_icd5 in: ('286','2871','2873','2874','2875')); label elx_grp_22 = 'Coagulopathy'; elx_grp_23 = (diag='278') | (diag_icd5 =: '2780'); label elx_grp_23 = 'Obesity'; elx_grp_24 = (diag in ('260','261','262','263')) | (diag_icd5 in: ('260','261','262','263','7832','7994')); label elx_grp_24 = 'Weight Loss'; elx_grp_25 = (diag='276') | (diag_icd5 in: ('2536','276')); label elx_grp_25 = 'Fluid and Electrolyte Disorders'; *** 3-digit codes overlap with # 27; elx_grp_26 = (diag_icd5 =: '2800'); label elx_grp_26 = 'Blood Loss Anemia'; elx_grp_27 = (diag in ('280','281')) | (diag_icd5 in: ('2801','2808','2809','281')); label elx_grp_27 = 'Deficiency Anemia'; elx_grp_28 = (diag in ('291','303','980')) | (diag_icd5 in: ('2652','2911','2912','2913','2915','2918','2919','3030','3039','3050', '3575','4255','5353','5710','5711','5712','5713','980','V113')); label elx_grp_28 = 'Alcohol Abuse'; elx_grp_29 = (diag in ('292','304','305')) | (diag_icd5 in: ('292','304','3052','3053','3054','3055','3056','3057','3058','3059','V6542')); label elx_grp_29 = 'Drug Abuse'; elx_grp_30 = (diag in ('293','295','297','298')) | (diag_icd5 in: ('2938','295','29604','29614','29644','29654','297','298')); label elx_grp_30 = 'Psychoses'; elx_grp_31 = (diag in ('296','300','309','311')) | (diag_icd5 in: ('2962','2963','2965','3004','309','311')); label elx_grp_31 = 'Depression'; run;