st: RE: Exported FLAT file and multiple records

[Nick Cox <n.j.cox@durham.ac.uk>]

Sounds like a -reshape-. 

. help reshape 

Nick 
n.j.cox@durham.ac.uk 

Ulises Huerta Munoz

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?

*
*   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/