combining 2 variables into 1

[Esra KKocag]

Hi,
I have a pooled data set cover 2 rounds of a survey. I have income variable in both waves but in different names. I am trying to combine and see them in one variable.

. ta hinctnt essround

Household' |
s total |
net |
income, |
all | ESS round
sources | 2 | Total
-----------+-----------+----------
J | 381 | 381
R | 479 | 479
C | 380 | 380
M | 259 | 259
F | 90 | 90
S | 26 | 26
K | 5 | 5
P | 15 | 15
D | 12 | 12
H | 8 | 8
U | 2 | 2
N | 5 | 5
-----------+-----------+----------
Total | 1,662 | 1,662


ta hinctnta essround

Household's |
total net |
income, all | ESS round
sources | 4 | Total
----------------+-----------+----------
J - 1st decile | 492 | 492
R - 2nd decile | 172 | 172
C - 3rd decile | 385 | 385
M - 4th decile | 250 | 250
F - 5th decile | 294 | 294
S - 6th decile | 190 | 190
K - 7th decile | 143 | 143
P - 8th decile | 78 | 78
D - 9th decile | 63 | 63
H - 10th decile | 65 | 65
----------------+-----------+----------
Total | 2,132 | 2,132


Thanx in advance!

[William Lisowski]

Welcome to Statalist.

You have accidentally posted your topic in Statalist's Mata Forum, which is used for discussions of Stata's Mata language. Your question will see a much larger audience if you post it in Statalist's General Forum

[Esra KKocag]

sorry about that. I will move it there.

thanx