Code:
sysuse auto egen price_q5 = xtile(price), n(5) egen weightmedian_priceq5 = median( weight ), by( price_q5) levelsof weightmedian_priceq5 gen weightmedian_binary = . replace weightmedian_binary = 0 if price_q5==1 & weight<2640 replace weightmedian_binary = 1 if price_q5==1 & weight>=2640 replace weightmedian_binary = 0 if price_q5==2 & weight<2650 replace weightmedian_binary = 1 if price_q5==2 & weight>=2650 replace weightmedian_binary = 0 if price_q5==3 & weight<2670 replace weightmedian_binary = 1 if price_q5==3 & weight>=2670 replace weightmedian_binary = 0 if price_q5==4 & weight<3280 replace weightmedian_binary = 1 if price_q5==4 & weight>=3280 replace weightmedian_binary = 0 if price_q5==5 & weight<3890 replace weightmedian_binary = 1 if price_q5==5 & weight>=3890
0 Response to Help looping with levelsof and egen...
Post a Comment