Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Brendan Halpin <brendan.halpin@ul.ie> |
| To | Yasir Zuberi <yasirzuberi2@hotmail.com> |
| Subject | Re: st: BHPS analysts |
| Date | Fri, 28 Mar 2014 23:33:58 +0000 |
You are not providing enough information, but I will guess at what is going on: > I'm trying to use the BHPS data with stata and merge key variables which > I'm interested in. The problem I have is adding a time variable "year" > by using "gen year= xxx". When I add this variable to each wave and then > attempt to merge by sort PID. Stata only picks up one year "2008". I guess you are merging waves into a single wide data set (using -merge-). If in the individual wave data sets you define the year (gen year=2008, gen year=2009, etc) when you merge them the variable year will have the first non-missing value. If you want a single variable, year, with different values for each wave, you need a "long" data format, which you get with -append-, not merge. Alternatively you need wave specific wave variables, e.g. gen ayear = 1991, gen byear=1992 etc. Then when you -merge- there are multiple year variables with distinct values. Brendan -- Brendan Halpin, Head, Department of Sociology, University of Limerick, Ireland Tel: w +353-61-213147 f +353-61-202569 h +353-61-338562; Room F1-002 x 3147 mailto:brendan.halpin@ul.ie ULSociology on Facebook: http://on.fb.me/fjIK9t http://teaching.sociology.ul.ie/bhalpin/wordpress twitter:@ULSociology * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/