Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Martin Weiss" <martin.weiss1@gmx.de> |
To | statalist@hsphsun2.harvard.edu |
Subject | RE: st: Dataset Editing |
Date | Mon, 20 Sep 2010 17:06:08 +0200 |
<> Looks like -reshape- to me. HTH Martin -original message- Subject: st: Dataset Editing From: drreg@earthlink.net Date: 20-09-2010 16:33 Below is a partial dataset. I would like to modify it so that x1 and x2 are on one line with their associated date. That is: date x1 x2 01jan2009 .2 .2 07jan2009 .09 .07 etc. I have been trying to do this using replace, but sometimes x1 is missing and sometimes x2 is missing. So I come (on bended knee) to the LIST for assistance. Any suggestions would be greatly appreciated. date x1 x2 01jan2009 . .2 01jan2009 .2 . 07jan2009 .09 . 07jan2009 . .07 13jan2009 . .2 13jan2009 .19 . 19jan2009 . .17 19jan2009 .18 . 25jan2009 .14 . 25jan2009 . .15 31jan2009 .21 . 31jan2009 . .21 Thanks. reg jordan * * 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/ * * 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/