Hi,
I am trying to combine parent data information to their children file.
1. I have one dta file for Children information and another for their parents who are in the separate data file. The children data set contains unique identifier for their parents ID as well which I can use who is the childs mother or father. What I want to do is to match some details such as Father and Mothers employment details, education level to their children database. Is there any efficient way to do this.
2. If I have combined the two Children and Adult dataset into one dta file, can I then do what I want to do above or I will have to do it separately as I mention in (1).
3. What if I have organised the children data into a panel dataset and now want to add this information about parents. Any efficient way to do from here then?
Looking for ideas.
Thank You.
Hi Kushneel,
Here's a link to a book about database management. It contains several discussions about data relationships and crafting a relational database. It may be of some benefit.
http://iips.icci.edu.iq/images/exam/databases-ramaz.pdf
Have a great day!
--Adrian
Hi Kushneel,
Here's a link to a book about database management. It contains several discussions about data relationships and crafting a relational database. It may be of some benefit.
http://iips.icci.edu.iq/images/exam/databases-ramaz.pdf
Have a great day!
--Adrian
It you have unique identifiers in both datasets it is possible to merge them in STATA in order to analyze what kind of parents particular children have. Consult the help file of the command -merge- to find out how to perform it.
Dear Kushneel,
actually your data basis is made of two "tables": the parents" and the children's. Most of the statistical software (SPSS, Stata or Sphinx for example) are able to deal with that kind of relational database.
Anyway, you probably have to perform your analyses on one or another table, because the "statistical units" are different if you are interested in parents or children.
For example, if you want to know what is the average number of children per family, you will analyse the families' table, while if you want to know the average age of children, you analyse the children's table.
I enclose a document about it, it is in French but maybe you are able to understand...
http://www.suristat.org/document/documentArticle/cus.pdf
Kind regards.
SG
- Badges
- Science topic
- Similar topics
- Statistics
- Survey