Dear Statalist,
I am a new user of Stata and I use it for my master thesis. I have created a dataset of European firms for the years 2006-2015. The number of observations is 3.136.622, but not every firm reported every year. My goal is to keep only the firms that reported their financials for the whole 10-year period and drop everything else. An idea I had was to create a dummy and then sum the total of the dummies for every company, and then say "drop if dummy<10" but cannot get it right. I upload a screenshot with the dataset. Could you help me with the coding? Any working solution is welcome.
Thank you in advance!
Array
Related Posts with Selecting only 10 consecutive years in a dataset
Setting up variables for a Venn DiagramHi- trying to set up variables for a Venn Diagram; essentially I need a count across three categorie…
Merging multiple panel data filesHello all, I have individual panel data and two state-level panels I seek to merge together. I have…
Panel data- setting id using group variableI am beginner in panel data. Please pardon if its a basic question. If I have 100 countries for whic…
Medical student who needs help?Hi there, I know very little about STATA but I wanted to know how I could create new variables usin…
Movestay questionHi there, I am using movestay to examine the impact of innovation (Innovation) on capital structure…
Subscribe to:
Post Comments (Atom)
0 Response to Selecting only 10 consecutive years in a dataset
Post a Comment