st: repeated measures

[Michael Eisenberg <meisenberg713@gmail.com>]

Colleagues,

I have what I hope will be simple question.

I have a database of men with lab tests over several years.  Included
in this is SSN (social security number) and DOB (date of birth).
Unfortunately, not all the men had this data recorded for every lab
test.

For example:

id       dob                 ssn                testdate      testa
1        3-1-1963       123-45-6789       6/1/2009      45
1                            123-45-6789       8/1/2009      90

2        6-1-1966       123-00-6000       6/1/2009      45

3                                                    6/1/2007      45
3                           123-45-6789       6/1/2008      55
3        7-1-1963                               6/1/2010      76

4                            123-45-6789       12/1/2009      45
4                            123-45-6789       12/15/2009     78



How can I have stata assign the known values for SSN or DOB to all of
the rows for a given subject?  If there happen to be typos in the
data, so that one subject has 2 different DOB, how will this be
handled by stata?

also, is there a simple way to remove the dashes from the SSN so that
I can destring this variable?

Thank you in advance.

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