. clear
. input ///
> Country str10 Variable Year Value
Country Variable Year Value
1. 1 A 01 123
2. 1 A 02 456
3. 1 B 01 789
4. 1 B 02 012
5. 2 A 01 345
6. 2 A 02 678
7. 2 B 01 901
8. 2 B 02 234
9. end
.
. reshape wide Value,i(Country Year) j(Variable) str
(note: j = A B)
Data long -> wide
-----------------------------------------------------------------------------
Number of obs. 8 -> 4
Number of variables 4 -> 4
j variable (2 values) Variable -> (dropped)
xij variables:
Value -> ValueA ValueB
-----------------------------------------------------------------------------
. list
+----------------------------------+
| Country Year ValueA ValueB |
|----------------------------------|
1. | 1 1 123 789 |
2. | 1 2 456 12 |
3. | 2 1 345 901 |
4. | 2 2 678 234 |
+----------------------------------+