Contract panel workfile
Posted: Mon Mar 30, 2015 11:23 am
Hi,
I'm using eviews8. I have a dated panel workfile with >500 cross sections (stocks) and 7 variables/series. I want to drop those stocks (that is the entire cross-sections) for which any of the 7 variables doesn't have at least one observation. So if for a specific stock there are all variables available except one - let's say the variable "dividend", that has only NA's - I want to completely remove this stock/cross section from the workfile. I couldn't figure out how to program this task. Thank you in advance for your help!
I'm using eviews8. I have a dated panel workfile with >500 cross sections (stocks) and 7 variables/series. I want to drop those stocks (that is the entire cross-sections) for which any of the 7 variables doesn't have at least one observation. So if for a specific stock there are all variables available except one - let's say the variable "dividend", that has only NA's - I want to completely remove this stock/cross section from the workfile. I couldn't figure out how to program this task. Thank you in advance for your help!