/* One-to-one match merge exmple */
clear
input byte (number odd)
1 1
2 3
3 5
4 7
5 9
end
label variable odd "Odd Numbers"

list
save odd, replace

clear 
input byte(number even)
5 10
6 12
7 14
8 16
end
label variable even "Even Numbers"

list
save even, replace

merge using odd
list

erase odd.dta
erase even.dta


/* One to one match-merge example */
clear
input byte (hhid sex educ)
2 0 12
1 1 15
3 0  9
end
list
save ind_data, replace


clear
input byte hhid faminc96   faminc97   faminc98
3 75000 76000 77000
1 40000 40500 41000
2 45000 45400 45800
end
list
save hh_data, replace

use ind_data, clear
list
use hh_data, clear
list

use ind_data, clear
merge 1:1 hhid using hh_data
list


/* Many to 1 match-merge example */
clear
input byte (hhid sex educ)
2 0 12
1 1 15
1 0 14
3 0  9
end
list
save ind_data, replace


clear
input byte hhid faminc96   faminc97   faminc98
3 75000 76000 77000
1 40000 40500 41000
2 45000 45400 45800
end
list
save hh_data, replace

use ind_data, clear
list
use hh_data, clear
list

use ind_data, clear
merge m:1 hhid using hh_data
list


/* Many to 1 match-merge */
clear
input byte (hhid sex educ)
2 0 12
1 1 15
3 0  9
end
list
save ind_data, replace


clear
input byte hhid faminc96 faminc97 faminc98
3 75000 76000 77000
1 40000 40500 41000
2 45000 45400 45800
4 35000 37400 42100
end
list
save hh_data, replace

use ind_data, clear
list
use hh_data, clear
list

use ind_data, clear
merge m:1 hhid using hh_data
list


/* Match-merge example #4 */
clear
input byte (hhid sex educ)
2 0 12
1 1 15
3 0  9
5 0 10
end
list
save ind_data, replace


clear
input byte hhid faminc96 faminc97 faminc98
3 75000 76000 77000
1 40000 40500 41000
2 45000 45400 45800
4 35000 37400 42100
end
list
save hh_data, replace

use ind_data, clear
list
use hh_data, clear
list

use ind_data, clear
merge 1:1 hhid using hh_data
sort hhid
list