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