I know how to perform :
Code:
egen v5 = sum(var4), by(var1)
var1 | var4 | v5 |
1 | 301 | 4323 |
1 | 4022 | 4323 |
2 | 301 | 623 |
2 | 322 | 623 |
3 | 4001 | 8023 |
3 | 4022 | 8023 |
4 | 4001 | 4323 |
4 | 322 | 4323 |
5 | 4001 | 8023 |
5 | 4022 | 8023 |
For example, I would like to generate this v6 but the divide() function does not exist on STATA
Code:
egen v6 = divide(var4), by(var1)
var1 | var4 | v6 |
1 | 301 | 0.07483839 |
1 | 4022 | 0.07483839 |
2 | 301 | 0.93478261 |
2 | 322 | 0.93478261 |
3 | 4001 | 0.99477872 |
3 | 4022 | 0.99477872 |
4 | 4001 | 12.4254658 |
4 | 322 | 12.4254658 |
5 | 4001 | 0.99477872 |
5 | 4022 | 0.99477872 |
Axel
0 Response to egen newvar = divide(existingvar), by(existingvar2)
Post a Comment