I have a raw data file that needs to be read into a dataset. it looks like this: ----+----1----+----2----+----3----+----4----+----5 Harry Mary 123 Vermont Ave. Joe 3 Lisa 2 Felix Laura 6 Baltic Drive Karen 12 Thomas Felicia 424 Suffolk place Edward Bella 666 Vampire Lane Jeff 9 Jared 7 Tim 11 The variables are Father, Mother, Address followed by Child (if any) and Child Age. I need to create a dataset that will have one observation per child with repeating Father, Mother and Address information. If no children then Child and age value should be blank. Please Help .. Thanks Desired Result would look like this: Father Mother Address Child Age --------------------------------------------------- Harry Mary 123 Vermont Ave. Joe 3 Harry Mary 123 Vermont Ave. Lisa 2 Felix Laura 6 Baltic Drive Karen 12 Thomas Felicia 424 Suffolk place . Edward Bella 666 Vampire Lane Jeff 9 Edward Bella 666 Vampire Lane Jared 7 Edward Bella 666 Vampire Lane Tim 11
... View more