Re: Merging data files [message #30097 is a reply to message #30058] |
Mon, 23 September 2024 07:47 |
Bridgette-DHS
Messages: 3189 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
I have prepared a Stata program that constructs the AI file (attached here). The program also merges it with the PR, IR, and MR files. This file may be a little different from the AI file you are using, so I am suggesting a slightly different filename (without "FL"). You will want to save the program as a do file and change the paths. I constructed my own AI file just so I would understand it better.
The AI file includes some people who have died, and they will not be in the other files. It includes some people who survived but are no longer in the household, and they too will not be in the other files. It allows for more than one accident per person; there are 16 people with 2 accidents/injuries. There are females who are outside the age range for the IR file and for males who are outside the age range for the MR file. I expect that some ages in the AI file do not match exactly with ages in the other files. Those people who had 2 accidents or injuries are duplicated in the merge.
An analysis of risk factors must include cases in the PR, IR, and MR files who did NOT have an accident or injury in the reference period. These case cases that did not match with the people in the AI file. I suggest constructing some recodes--for example a yes/no binary variable for "had an accident" and a yes/no binary variable for "had an injury".
In the PR merge, household-level data can be attached to people who died or are no longer in the household; I did not do that.
I am not directly answering your question about the self-harm cases but there are several potential issues with the analysis of the AI file and they go beyond the scope of the users forum.
|
|
|