Dear statalisters,
I have a dataset that has records that may be duplicates by two variables , below I show you a small set of observations to make my question
clear.
when observations have the same firmid and fyear, I want to keep the records that have non-missing csale values. I all records that share the same firmid and fyear have missing csale, I want to keep at least 1 record.
I thought of using tag, but not sure if tag can be organized by csale value.
Thanks,
Rochelle
I have a dataset that has records that may be duplicates by two variables , below I show you a small set of observations to make my question
clear.
Code:
clear input int(firmid fyear) byte csale 1000 1980 19 1000 1980 . 1001 1980 2 end
I thought of using tag, but not sure if tag can be organized by csale value.
Thanks,
Rochelle
Comment