I have a dataframe with many firm-year observations and many variables. 

Not all firms have information for all the years.

I want another dataframe with only those firms that have information all
years.

This is, I want a balanced panel data, but with the maximum number of years.

In my reprocucible example I want to keep firms 1,2 and 3 (period 2000 to
2004). 

 

I need your help to create a code for this.

 

Thank you very much,

 

Cecília Carmo

(Universidade de Aveiro)

 

 

#My reproducible example:

firm<-sort(rep(1:3,5),decreasing=F)

year<-rep(2000:2004,3)

X<-rnorm(15)

data1<-data.frame(firm,year,X)

data1

 

firm<-sort(rep(4:6,3),decreasing=F)

year<-rep(2001:2003,3)

X<-rnorm(9)

data2<-data.frame(firm,year,X)

data2

 

finaldata<-rbind(data1,data2)

finaldata


	[[alternative HTML version deleted]]

