Statalist The Stata Listserver

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

Re: st: transpose a variable

From   "Ada Ma" <>
Subject   Re: st: transpose a variable
Date   Mon, 15 May 2006 10:31:40 +0100

You can use -reshape- as you say, but before you do it you need to
generate a variable which shows which record the obs correspond to
amongst all the obs you have for each person, something like the count
variable in here:

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

You said you don't care about the particular order of the request
variable so you can write:

bys identifier: gen count=_n
reshape wide request, i(identifier) j(count)

On 5/15/06, Eamonn O'Brien <Eamonn.O'> wrote:
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
ss12346    21 3 52     .
ss12347    14 8 71     MA2

*   For searches and help try:

Ada Ma
Research Fellow
Health Economics Research Unit
University of Aberdeen, UK.
Tel: +44 (0) 1224 553863
Fax: +44 (0) 1224 550926

*   For searches and help try:

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