Dear all,

 

I handle a panel dataset consisting of 1577 companies, 5 years and 20 variables. I would like to know how restrict the dataset excluding missing values (ex. If one company have a missing value for one year it should be excluded by all other years). After doing this operation, I would like to compute the mean, the median and the sum for each variable. Could you please write down the right script for these actions?

 

Thank you very much,

Best Regards

Giulia

 

Giulia Taveggia

 

Researcher, Country Analysis and Forecasts Unit

 

CSIL Centre for Industrial Studies

Corso Monforte 15 - 20122 Milano - Italy Tel +39 02780497- Fax +39 02 780703