> I have the following problem:
>
> I have data on individuals indexed by a unique identifier, SERNO. In
> addition to SERNO, I have a vector of variables Z which are
> measurements
> taken on each individual at time t. Lastly, I have a variable
> SERNO2 which,
> for each case, gives the value of SERNO for a matched case in
> the data set.
> What I wish to do is create a second vector of variables, X,
> which copy the
> values of Z for the case indexed by SERNO2 to each value of SERNO. Any
> suggestions?
>
> Patrick
>
I would use -merge-.
. foreach var of varlist <<Z>> {
. rename `var' X_`var'
. }
. drop serno2
. rename serno serno2
. sort serno2
. save xdata, replace
. use <<original dataset>>
. sort serno2
. merge serno2 using xdata
Basically, you create a copy of your data that renames the original
variables that you want to merge, and renames the serial number variable
to be the serial number of the matched comparison. Then when you merge
these data back into the original dataset, you are getting the X_
variables associated with the matched serial number. Hope this makes
sense....
Nick WInter
*
* 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/
