clear
#delimit ;
set mem 50m;

global path ~;
*global path C:;
use $path\data\china\china1988\income\urbani.dta;

replace v201=0 if v201==.;
replace v202=0 if v202==.;
replace v203=0 if v203==.;
replace v204=0 if v204==.;
replace v206=0 if v206==.;
replace v208=0 if v208==.;
replace v209=0 if v209==.;
replace v213=0 if v213==.;
replace v214=0 if v214==.;
replace v215=0 if v215==.;
replace v216=0 if v216==.;
replace v217=0 if v217==.;
replace v221=0 if v221==.;
replace v221a=0 if v221a==.;

*creates personal income measures;
gen uy1p = (v201+v202+v203+v204+v206)*12+v208+v209;
gen uy2p = (v213+v214)*12+v215;   
replace v221=v221a if v221<v221a;
gen uy3p = v221*12-v221a*12;
gen uy4p =v216-v217;

label var uy1p "Cash income of the working members";
label var uy2p "Income of the retired members";
label var uy3p "Income of the non-working members";
label var uy4p "Income from private/individual enterprises";

saveold $path\data\china\china1988\income\uiincome.dta, replace;
                                       
clear;

use $path\data\china\china1988\income\uhincome.dta;

gen avgh = (uy5+uy6+uy7+uy8+uy9+uy10)/nhh;

keep ucode avgh nhh;

sort ucode;

saveold $path\data\china\china1988\income\uhi.dta, replace;

clear;

use $path\data\china\china1988\income\uiincome.dta;

sort ucode;

merge ucode using $path\data\china\china1988\income\uhi.dta;

drop _merge;

gen uy = avgh+uy1p+uy2p+uy3p+uy4p;

label var uy "Disposable Income";
rename v103 relation;
rename v104 gender;
rename v105 age;
rename v106 retire;
rename v107 student;
rename v108 income88;
rename v109 party;
rename v110 minority;
rename v111 educatio;
rename v112 employ ;
rename v113 ownsect;
rename v114 typeem;
rename v116 emsect;

label define relation1  1 "self" 2 "spouse" 3 "child" 4 "grandchild" 5 "parent" 6 "grandparent" 7 "other relative" 8 "not related" 9 "missing";
label define gender1   0 "male" 1 "female" 9 "missing";
label define student1   1 "yes" 2 "no" 9 "missing";
label define income881   1 "yes" 2 "no" 9 "missing";
label define educatio1   1 "college or above" 2 "professional school" 3 "upper middle school" 4 "lower middle school" 5 "primary school graduate" 6 "three years or more of primary school" 7 "one to three years of primary school" 8 "illiterate" 9 "missing";
label define party1   1 "yes" 2 "no" 9 "missing";
label define minority1   1 "yes" 2 "no" 9 "missing";
label define employ1   1 "working" 2 "disabled" 3 "retired" 4 "currently a student" 5 "homemaker" 6 "other" 9 "missing";
label define ownsect1     1 "state-owned. operated by center or province" 2 "local state-owned" 3 "co-operative" 4 "private or individually-owned" 5 "Sino-foreign joint venture" 6 "foreign-owned" 7 "farming under household responsibility system" 8 "other" 9 "not currently employed" 99 "missing";
label define emsect1   1 "agriculture" 2 "forestry" 3 "raising livestock" 4 "fishery" 5 "family sideline" 6 "industry" 7 "handicrafts" 8 "trade" 9 "construction" 10 "transport" 11 "catering Õservingfoodå" 12 "other services" 13 "post & telecommunications" 14 "finance, insurance" 15 "culture, education, health" 16 "party, government or social organizations" 99 "missing";
label define typeem1   1 "official of Party or government office or institution" 2 "technical worker" 3 "leading official of state or collective enterprise" 4 "ordinary cadre of Party or government office or institution" 5 "owner and manager of private or individual enterprise" 6 "township or village cadre" 7 "ordinary worker" 8 "temporary or short-term contract worker" 9 "farmer" 10 "worker in town or township enterprise" 11 "principal official of town or township-operated enterprise" 99 "missing";
label define retire1   1 "yes" 2 "no" 9 "missing";

saveold $path\data\china\china1988\income\uii.dta, replace;