Re: st: Merging data into a format to be able to use Event History

["Anders Alexandersson" <andersalex@gmail.com>]

Anthony Nyberg <ajnyberg@wisc.edu> wrote:
> I have been unable to figure-out how to combine a number of different
> data sets (7) of which 5 have dates for time varying covariates.  I can
> append all of the data sets together, but then I have struggled with how
> to fill-in, in the correct order, the appropriate values. All values,
> including dates, are numerical.
>
> Is there a good method for merging these data into one format (see the
> "desired" table below)? [...]
A basic merging solution is to "always use 1-to-1 match merges". That
is, use the -reshape- "two-step" procedure: Reshape your long datasets
to wide format. Then merge the wide datasets. Then reshape again, this
time the merged wide dataset to your desired long format. You may find
this -reshape- FAQ useful:
http://www.stata.com/support/faqs/data/reshape3.html

Anders Alexandersson
andersalex@gmail.com
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/