I am working with WRDS data, dates in one coluumn, companies in another and returns in another. I want to drop a company if the return in the last month (December 2018 being the last) is missing and if the returns in 25 of the previous 60 months are also missing . Would appreciate if someone could help with the code for doing so. Thank You.
Related Posts with Data Count & Delete
Data describing reading time and index about gun-controlI am trying to see how long a reading time my respondents had on a certain question, compared to if …
Generate new Variable and based on that cumulate by monthHi, I do have a question regarding a dataset. I try to cumulate my "usd" by month for each country.…
Data restructuringI have a dataset of patients who had repeat treatments. Unfortunately instead of having a unique pat…
Unrealistic R squared in LSDV modelHello everybody, Situation: I use Stata 14.2. I want to investigate the effects of mobile phone pen…
How to run independence test on 3 categorical variables on Stata?I'm working on descriptive analysis and wish to compare 3 categorical variables: Sex (man / woman) …
Subscribe to:
Post Comments (Atom)
0 Response to Data Count & Delete
Post a Comment