st: Exported FLAT file and multiple records

[Ulises Huerta Munoz <ulises.huerta.munoz@gmail.com>]

Hello everyone,

This is my first post.

I am using Stata 12 and data from the Demographic Health Survey.
To assign mother characteristics to children I have done a 1:m merge using
the children's file as the base file. Since this is an exported  "FLAT" file,
multiple or repeating records are placed one after the other on the record
with each occurrence of every such variable having its own name. So for
example, a woman with three children whose height we are interested in shows as:


     v001 v002 v003 child#1height child#2height child #3height
1.     X      Y      Z             98                  72             126


to regress the height of children and use characteristics of the mom
as predictors, I
need each children to have the characteristics of the mom such as

     v001 v002 v003 child height
1.     X      Y      Z             98
2.     X      Y      Z             72
3.     X      Y      Z             126

Is there a command that will allow me to do this?

Thanks

uh





child#2height child #3height
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/