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: one data management question
From
Grace Jessie <[email protected]>
To
<[email protected]>
Subject
st: one data management question
Date
Sat, 5 Mar 2011 13:10:13 +0000
Dear statalists,
I have a data like the following with only one variable---var.
+-------+
| var |
|-------|
1. | areaA |
2. | 1 |
3. | hot |
4. | 3 |
5. | 4 |
|-------|
6. | 2 |
7. | cold |
8. | 4 |
9. | areaB |
10. | 1 |
|-------|
11. | warm |
12. | 6 |
13. | 2 |
14. | rainy |
+-------+
There are some areas and some big portfolios within each area in the data. The number of observations for each porfolio varies and the max is 4. If the observation number for each portfolio equals 4, the 4 observations represent id weather x y,respectively and orderly.If the number is less than 4, such as 3, it says the last observation for y is missing.The indicative string is "hot cold warm rainy" which is used to distinguish each portfolio. Each portfolio begins from the observation one before "hot cold warm rainy" and ends one before another portfolio begins.For example, there are two porfolios in areaA. One is "1 hot 3 4", and the other is "2 code 4".
Now I want to change the data to another one available for regression as follows.
+-----------------------------+
| area id weather x y |
|-----------------------------|
1. | A 1 hot 3 4 |
2. | A 2 cold 4 |
3. | B 1 warm 6 |
4. | B 2 rainy |
+-----------------------------+
How to realize it?
Thank you!
Grace
*
* 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/