Dear All, Is there a one line command for the following "wanted" variable?
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input byte firm_number float(prob n)
1 .26130265 1
1 .25147092 2
1  .2452173 3
1  .2420091 4
2 .26272482 1
2 .26272482 2
2  .2372752 3
2  .2372752 4
3    .27035 1
3  .2537077 2
3 .24096736 3
3 .23497495 4
end
The purpose is obtain "wanted" variable as below
Code:
bys firm_number: gen temp = prob if _n == 2
bys firm_number: egen wanted = mean(temp)