Thanks a lot - it works perfect!
Simon
-----Urspr�ngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Maarten
Buis
Gesendet: Mittwoch, 25. April 2007 12:16
An: [email protected]
Betreff: st: RE: data management
--- Simon Oertel wrote:
> I have a dataset with the following structure:
>
> ID TimeA
> 1 10
> 1 10
> 1 12
> 2 8
> 2 8
<snip>
> And I would like to format the dataset into the following structure:
>
> ID Time1 Time2 Time3 Time4
> 1 10 10 12
> 2 8 8
<snip>
What about this:
*------------- begin example --------------
drop _all
input ID TimeA
1 10
1 10
1 12
2 8
2 8
3 19
3 21
3 86
3 7
4 10
5 18
6 56
6 56
end
bys ID: gen time = _n
reshape wide TimeA, i(ID) j(time)
list, clean
*------------- end example -------------
(For more on how to use examples I sent to the Statalist, see:
http://home.fsw.vu.nl/m.buis/stata/exampleFAQ.html )
Hope this helps,
Maarten
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
*
* 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/
*
* 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/
