Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: transpose a variable


From   "Eamonn O'Brien" <Eamonn.O'Brien@icr.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: transpose a variable
Date   Mon, 15 May 2006 10:05:23 +0100

I have a data set that I would like to 'reshape' to a record per row.
All variables except one, the 'request' variable are on a single row per
identifier. The request variable can be any number of rows and contains
both string and numeric data, with the codes I am interested in
appearing in no particular order in the column.   I would like to
reshape this variable so it's on one row with the identifier. I have
explored -xpose- and -sxpose- and reshape but cannot achieve this.
(Their are more than 3 variables in the data set). 

identifier   dob             request
ss12345   10 04 68    MA4
                                  A2
                                  ST69979
                                  verygood
ss12346    21 3 52     .
ss12347    14 8 71     MA2

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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index