In [previous post] …
Follow-up tip:
From: Abraham D. Flaxman
Sent: Wednesday, December 30, 2015 5:16 PM
Subject: RE: VA Data Update
Cool, it looks like you are making progress. I do again encourage to do this work incrementally. So make a mapping that just gets the age and sex into the right columns and run that through, and then add in a few questions at a time to make sure things keep changing in a way that makes sense (i.e. when you add the column on chest pain to your mapping, the number of heart attack deaths should increase…).
You had a question about injury coding in your spreadsheet. Here is the coding:
1. Road traffic crash/ injury
2. Fall
3. Drowning
4. Poisoning
5. Bite or sting by venomous animal
6. Burn/Fire
7. Violence (suicide, homicide, abuse)
11. Other injury, specify (__________)
8. Refused to answer
9. Don’t know
If multiple injury causes were endorsed, you may record them as a space-separated list, i.e “2 3” for a fall that resulted in drowning.
–Abie
Healthy Algorithms 