Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: wide to long form


From   David Kantor <kantor.d@att.net>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: wide to long form
Date   Sat, 05 Dec 2009 10:10:42 -0500

Without going into much detail, it seems that you want -reshape- followed by -fillin-.
Possibly there are other operations needed as well.

HTH
--David

At 05:02 PM 12/4/2009, Shehzad Ali wrote:
Hi listers,

I would really appreciate some help with data structuring.

I want to change my data structure from wide to long form. The data comes from a discrete choice experiment. Each individual is given 6 choice sets. Each choice set has two options, A or B. Individual is asked to choose between A and B for each choice set. The data currently looks like this:

id choice_set1 choice_set2 choice_set3 choice_set4 choice_set5 choice_set6 1 A B A A B B 2 B B A B A B

I want the data to look like this:

id    choice_set    alternative    chosen (yes/no)
1            1                A                    1
1            1                B                    0
1            2                A                    0
1            2                B                    1
1            3                A                    1
1            3                B                    0
..
..
2            1                A                    0
2            1                B                    1
2            2                A                    0
2            2                B                    1
...
...

Any help would be greatly appreciated.
Many thanks,
Shehzad

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



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