Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Formatting Data (collapse/transpose)


From   "kelly johnson" <[email protected]>
To   [email protected]
Subject   st: Formatting Data (collapse/transpose)
Date   Sun, 24 Jul 2005 18:38:27 -0400

Hi,

Suppose I had data like this:

Date Var1 Var2

1/1/05 a 12
1/1/05 b 11
1/1/05 c 19
1/1/05 d 9
1/2/05 a 10
1/2/05 b 14
1/2/05 c 21
1/2/05 d 12
...

1/30/05 a 12
1/30/05 b 1
1/30/05 c 19
1/30/05 d 31

How can I transform the data set so it looks like this:

Date a b c d
1/1/05 12 11 19 9
1/2/05 10 14 21 12
...
1/30/05 12 1 19 31


Thank you!

kj

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

*
* 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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index