I have a little knowledge of SAS but I have no idea about the structure of claims data .I want to select participants for a cohort study based on the following criteria from three data sets:
o Received a dementia diagnosis (ICD-9-CM: 290.0x - 290.4x, 294.1x, 331.0x, 331.1x, 331.2x, 331.82, and 331.9x in any position) during 2001-2005. The date when the patient first received a dementia diagnosis is defined as the index date. o ≥ age 65 on the index date o ≥12 months enrollment prior to the index date
files: File name 1: Inpatient_claims2001.csv - Inpatient_claims2005.csv
Data fields: patID admission_date discharge_date (e.g. 9/27/2002) Primary_diagnosis diagnosis_code1 – diagnosis_code6
File name 2: outpatient_claims2001.csv - outpatient_claims2005.csv
Data fields: patID service_date (e.g. 3/27/2002) diagnosis_code1 diagnosis_code2
File name 3 : enrollment_file2001.csv - enrollment_file2005.csv
Data fields: patID date_of_birth (e.g. 10/18/1945)
enroll_mon1 – enroll_mon12
(values: 0 or 1 with 0=not enrolled and 1=enrolled for the month)
If anyone have an experience in claims data please help me on how can I approach and code in SAS to get the requested results
Thanks, Ankur.