Hello everyone
I need to delete the firms that does not have data for three years consecutively. please teach me how to do it
for example
firm1 has data for five years but as follows (2005 2007 2008 2010 2012). i dont want this firm i want to delete it from my sample . hope you get my point
thanks in advance
Related Posts with how to delete specific observations
Adding extra years to an existing date variableDear Statalist, I have a date variable created the following way: Code: gen PartDat_gli = . repl…
Drop if ALL specified variables fulfill a certain conditionDear statalist, is there a way to write the following command Code: drop if intention1==9 & i…
Vuong test for hedonic price model - RegressionHi all, I am trying to estimate a hedonic price model. The first step used is estimating the Box Cox…
Calculation of mean for each industry quarter using egen, any quicker way!!Dear Statalist members, My dataset is something like this Code: * Example generated by -dataex-.…
combining datasets with different formats of a variable and ts valuesI have a dataset that includes information on naic codes, years, the quarter of those years in the f…
Subscribe to:
Post Comments (Atom)
0 Response to how to delete specific observations
Post a Comment