Exercises

1. Define "survival" vtrack
2. Extract survival time for patients with pancreatic cancer
3. Extract BMI for all patients between the ages 60 and 70
4. Extract BMI and age for all patients between the ages 60 and 70
5. Extract median Hemoglobin (lab.103) for all females between ages 20 to 30
6. Extract median Hemoglobin(lab.103) for all males between ages 60 to 70
7. Extract patient age and gender at the onset of diabetes – first time they were diagnosed with icd 9 code 250
8. Extract patients genders.
9. Extract patients ages at some diagnosis (the first time the were diagnosed).
10. Extract patients lab test (lab.102) 30 days before a diagnosis (diagnosis.410) together with patients age.
11. Extract patients age at time of diagnosis of heart disease (diagnosis.411) that did not have diabetes (diagnosis.250)
12. Sample a lab test of all the patients between 50 and 60
13. Extract BMI (marker.BMI) for all patients between the ages 60 and 70
14. Extract BMI and age for all patients between the ages 60 and 70
15. Extract median Hemoglobin(lab.103) for all females between ages 20 to 30
16. Extract median Hemoglobin(lab.103) for all males between ages 60 to 70
17. Extract patient age and gender at the onset of diabetes – first time they were diagnosed with icd 9 code 250