** SAS Formats and Programming Code for amenable hospitalizations ; ** FORMATS ; ** ICD-9-CM Codes for Amenable conditions. These were last modified in September 1994; there may be changes that affect these codes since that time. ; VALUE $AMEN '001 '-'0039', '005 '-'0099' = '1:Enteritis + diarrhoeal' '090 '-'0979' = '2:Syphilis' '010 '-'0189','137 '-'1379' = '3:Tuberculosis' '004 '-'0049','320 '-'3229', '381 '-'3839','391 '-'3919', '680 '-'6869', '711 '-'7119', '730 '-'7309' = '4:Oth. infect.' '180 '-'1809' = '5:Cervical Cancer' '201 '-'2019' = '6:Hodgkin Disease' /** age 5-34 ***/ '240 '-'2429' = '7:Goitre' '250 '-'2509' = '8:Diabetes mellitus' /** age <50 ***/ '260 '-'2699' = '9:Nutritional deficit' '345 '-'3459' = '10:Epilepsy' '390 '-'3909', '392 '-'3989' = '11:Rheumatic fever' '401 '-'4059' = '12:Hypertension' '460 '-'4669' = '13:Respiratory infect.' /** age < 50 ***/ '487 '-'4879' = '14:Influenza' /** age < 50 ***/ '480 '-'4869' = '15:Pneumonia' /** age < 50 ***/ '490 '-'4929', '496 '-'4969' = '16:Bronchitis & Emphysema' '493 '-'4939' = '17:Asthma' /** age < 50 ***/ '531 '-'5349' = '18:Peptic Ulcer' '574 '-'5769' = '19:Gallbladder' /** Appendicitis is commented out (not used) when applied to Hospitalizations **/ '540 '-'5439' = '20:Appendicitis' '550 '-'5539', '560 '-'5609' = '21:Intestinal obst.' /** Pregnacny compl. is commented out (not used) when applied to hospitalizations **/ '630 '-'6769' = '22:Pregnancy compl.' '760 '-'7799' = '23:Perinatal mortality' OTHER="OTHERS" VALUE AMENL 1="Amenable" 2="Not Amenable" 99="ALL CAUSES" ** SAS CODE ; ** Use SAS code similar to the following to create a variable (AMENH) which flags primary diagnoses as Amenable or not. ; ** Please note your dataset must have an AGE variable. The example below uses a variable named AGE. ; DIAG = SUBSTR(DIAGN01,1,4) ; * abstract the 1st 4 characters of 1st diag*; AMENH= PUT(DIAG,$amen.) ; ** flag amenable / non causes **; IF (AMENH= '6:Hodgkin Disease') & (0 <= AGE <="4" | AGE> 34) THEN AMENH= 'OTHERS' ; ELSE IF (AMENH='8:Diabetes mellitus') & (AGE >=50) THEN AMENH='OTHERS' ; ELSE IF (AMENH='13:Respiratory infect.') & (AGE >=50) THEN AMENH= 'OTHERS' ; ELSE IF (AMENH='14:Influenza') & (AGE >= 50) THEN AMENH= 'OTHERS' ; ELSE IF (AMENH='15:Pneumonia') & (AGE >= 50) THEN AMENH= 'OTHERS' ; ELSE IF (AMENH='17:Asthma') & (AGE >= 50 ) THEN AMENH= 'OTHERS' ; *** The following IF - statement defines two groupings of deaths: *** amen = 2 -> hosp. NOT amenable to medical treatment and *** amen = 1 -> hosp. Amenable to medical treatment. ******************************************************************; IF AMENH= 'OTHERS' THEN amen = 2 ; ELSE amen = 1 ; *** Amenable causes ***;