Dear Forum users,
I am trying to sum up the investment size by investor ID using "collapse(sum) investment, by(ID)". But this function sums up the missing values as well, so I am getting zeros where it should be missing value in the total investment variable. I tried if function, but STATA doesn't allow it with collapse. Is there any idea on how I can solve this issue?
Kind regards,
Firangiz Aghayeva
I am trying to sum up the investment size by investor ID using "collapse(sum) investment, by(ID)". But this function sums up the missing values as well, so I am getting zeros where it should be missing value in the total investment variable. I tried if function, but STATA doesn't allow it with collapse. Is there any idea on how I can solve this issue?
Kind regards,
Firangiz Aghayeva
Comment