Hi  I need to count in the data by patient ID where N=4  patientID fREQ STAT FLAG 1 4 N 4 1 4 MIN 1 1 4 MAX 1 1 4 MEAN 1 2 12 N 12 2 12 MIN 1 2 12 MAX 1 2 12 MEAN 1 3 4 N 4 3 4 MIN 1 3 4 MAX 1 3 4 MEAN 1 ... View more

Hi I would like to know how to count continuously enrolled patients form the claims data. My data looks like this my enrollment duration is 3 years in the data and follow up time 6 months before index date and 1 2months after index date Patient ID INDEX DATE START DATE END DATE TYPE ENROLLEMNT DATE 1 3/3/2015 9/4/2014 3/2/2016 B 2014/01 1 3/3/2015 9/4/2014 3/2/2016 B 2014/02 1 3/3/2015 9/4/2014 3/2/2016 B 2014/03 2 8/16/2014 2/17/2014 8/16/2015 B 2014/01 2 8/16/2014 2/17/2014 8/16/2015 B 2014/02 2 8/16/2014 2/17/2014 8/16/2015 B 2014/03 2 8/16/2014 2/17/2014 8/16/2015 B 2014/04 2 8/16/2014 2/17/2014 8/16/2015 B 2014/05 ... View more

Hi everyone I need to get type 2 diabetes patients from claims data by using ICD 9 AND 10 Codes. when I ran the following code I got Type 1 diabetes patients as well because ICD9 codes of type 2 and 1 start with 250.  data Array; set MED; array d(9)$ MEDICAL_PRIMARY_DIAGNOSIS_CODE MEDICAL_DIAGNOSIS_CODE_2-MEDICAL_DIAGNOSIS_CODE_9; do i=1 to 9; DM=0; DM1=0; DM2=0; if substr (d(i),1,3) = 'E11' then DM1=1; if substr (d(i),1,3) = '250' then DM2=1; if DM1=1 or DM2=1 then DM=1; else DM=0; end; drop i; run;   For type 1 diabetes I have these icd 9 codes to delete but i incorporate it into the above array code it gave 0 observations.   if substr (d(i),1,5) IN ('25001', '25003', '25011', '24013', '25021','25023', '25031', '25033', '25041', '25043', '25051','25053', '25061', '25063', '25071','25073','25081','25083','25091','25093') THEN DM=1; if DM=1 then delete;    Please guide ... View more

Hi everyone I need to identify the patient of type2 Diabetes from claims medical condition file I am using the following code but it gave me unexpected numbers. Please let me know am I using All icd 9 and 10 codes of diabetes in the code correctly? DATA Array; SET MED; ARRAY cc (*) MEDICAL_PRIMARY_DIAGNOSIS_CODE MEDICAL_DIAGNOSIS_CODE_2-MEDICAL_DIAGNOSIS_CODE_9; DIABETESc =0; DO i=1 TO 10; IF cc (i) in ('E11.9' 'E11.8' 'E11.9' 'E11.69' 'E11.51' 'E11.21' 'E11.620''E11.621') or ('E11.00' <= cc(i) <= 'E11.65') then DIABETESc=1; If DIABETESc=. then DIABETESc=0; END; RUN; PROC SORT DATA= array2; BY Patient_ID DESCENDING DIABETESc; RUN; DATA ARRAY3; SET array2; BY Patient_ID; IF FIRST.Patient_ID; RUN; /*REMOVE THE MISSING VALUE FROM THE DATA*/ DATA ARRAY4; SET ARRAY3; IF DIABETESc=. THEN DELETE; RUN; /*COUNT ONLY diabetes PATIENTS*/ DATA ARRAY5; SET ARRAY4; IF DIABETESc=1; RUN; /*NUMBERS OF DIABETES PATIENTS*/ PROC FREQ DATA= ARRAY5; TABLES DIABETESc; RUN; ... View more

Hi everyone I wanted to get type 2 diabetes patients from claims data? DATA Array2; SET MED; ARRAY cc (10) $ MEDICAL_PRIMARY_DIAGNOSIS_CODE MEDICAL_DIAGNOSIS_CODE_2-MEDICAL_DIAGNOSIS_CODE_9; DIABETESc=0; DO i=1 TO 10; IF cc (i) in ('250') then DIABETESc=1; IF cc (i) in ('E11.9' 'E11.8' 'E11.9' 'E11.69' 'E11.51' 'E11.21' 'E11.620' 'E11.621' 'E11.00-E11.65') then DIABETESc=1; END; If DIABETESc=. then DIABETESc=0; RUN; PROC SORT DATA=array2; BY Patient_ID DESCENDING DIABETESc; RUN; DATA ARRAY3; SET array2; BY Patient_ID; IF FIRST.Patient_ID; RUN; /*REMOVE THE MISSING VALUE FROM THE DATA*/ DATA ARRAY4; SET ARRAY3; IF DIABETESc=. THEN DELETE; RUN; /*COUNT ONLY diabetes PATIENTS*/ DATA ARRAY5; SET ARRAY4; IF DIABETESc=1; RUN; /*NUMBERS OF DIABETES PATIENTS*/ PROC FREQ DATA=ARRAY5; TABLES DIABETESc; RUN; The problem is it gave me unexpected number of diabetes patients  ... View more