Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Reshape
From
Elena Quercioli <[email protected]>
To
[email protected]
Subject
st: Reshape
Date
Wed, 15 Sep 2010 10:56:14 +0200
I have a dataset with multiple identifiers(id2 and id). Here is an
example of it:
+----------------------------------------------------------------------------
| id year x county vars varlabel id2 |
|---------------------------------------------------------------------------|
1. | 1 1979 790 1 suic suic 1 |
2. | 1 1980 4.823 1 suic suic 2 |
3. | 1 1981 2.560 1 suic suic 3 |
4. | 1 1982 1.890 1 suic suic 4 |
5. | 1 1983 1.137 1 suic suic 5 |
6. | 1 1984 2.540 1 suic suic 6 |
7. | 1 1985 3.205 1 suic suic 7 |
8. | 1 1986 5.770 1 suic suic 8 |
9. | 1 1987 4.748 1 suic suic 9 |
10. | 1 1988 5.467 1 suic suic 10 |
11. | 1 1989 7.141 1 suic suic 11 |
12. | 1 1990 3.053 1 suic suic 12 |
13. | 1 1991 8.661 1 suic suic 13 |
14. | 1 1992 3.342 1 suic suic 14 |
15. | 1 1993 826 1 suic suic 15 |
16. | 1 1994 3.934 1 suic suic 16 |
17. | 1 1995 4.784 1 suic suic 17 |
18. | 1 1996 7.504 1 suic suic 18 |
19. | 1 1997 2.447 1 suic suic 19 |
20. | 1 1998 4.397 1 suic suic 20 |
21. | 1 1999 4.915 1 suic suic 21 |
22. | 1 2000 6.089 1 suic suic 22 |
23. | 1 2001 6.756 1 suic suic 23 |
24. | 1 2002 5.557 1 suic suic 24 |
25. | 1 2003 6.346 1 suic suic 25 |
26. | 1 2004 2.588 1 suic suic 26 |
27. | 1 2005 7.878 1 suic suic 27 |
28. | 1 2006 4.150 1 suic suic 28 |
|----------------------------------------------------------------------------|
29. | 2 1979 120 1 west west 1 |
30. | 2 1980 120 1 west west 2 |
31. | 2 1981 121 1 west west 3 |
32. | 2 1982 122 1 west west 4 |
33. | 2 1983 121 1 west west 5 |
34. | 2 1984 120 1 west west 6 |
35. | 2 1985 120 1 west west 7 |
I want to reshape the variable x wide. I typed the command
reshape wide x, i(id2) j(varlabel)
but there are 5 distinct values for j = 1,2,3,4,5 associated with each
value of id2 in my dataset. How do I proceed to have this dataset
reshaped with x being wide and the j variables unstacked. My final
dataset should look like this
ID | Year| Suic|West|Central|Pop!Mount|
1 1979 .... ... ... ... ...
. .
. .
. .
1 2006
2 1979
.
.
.
2 2006
... ... .... .... ... ... ...
28 1979 Suic| West|Central|Pop|Mount
Thank you for all the help you can give me on this. Elena
*
* 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/