Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Michael Eisenberg <meisenberg713@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | st: repeated measures |
Date | Mon, 23 May 2011 08:51:52 -0500 |
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/