Hi All,

I am working with a smaller dataset of approximately 500 observations in Stata 15.1. I am interested in the relationship between parent's and child's education and am stuck on what should be a relatively simpler part of the analysis. In this dataset, children are identified by a combination of the parent's id (numerical) and the child's id (which is the #of children each parent has, from 0-7). I would like to determine how many kids have parents who graduated from college and while I already created a new categorical variable for parent's education, I can't figure out how to connect that information to each of the parent's kids. If anyone could suggest a way of identifying which parents the kids belong to, I can figure out the rest. Any suggestions are greatly appreciated!!!

tab child_id
child_id Freq. Percen tCum.
1 212 50.84 50.84
2 117 28.06 78.90
3 50 11.99 90.89
4 23 5.52 96.40
5 10 2.40 98.80
6 3 0.72 99.52
7 2 0.48 100.00
Total 417 100.00


Parent's ID is reported as 1, 2, 3, 4, 5......

Paternal Education is reported as Elementary, Jr. High, H.S. Diploma, College, and More than College