Hello Amelia users

I have tried to use the amelia package, and I got the following error. I am dealing with a macro panel dataset for 126 countries and 16 years. I want to impute using the entire dataset, the values of time to export, time to import (measured in hours), and cost of exports and imports in USD.

The proportion of missingness is quite large around 45 and 65 % for the variables. For that purpose, I use the option empri, read Amelia manual on page 31.

am = amelia(final_datos1, m = 5, intercs = TRUE, empri = .01*nrow(final_datos1), cs = "country", ts = "year")

After running this, it gives me the error
Warning message:
In amcheck(x = x, m = m, idvars = numopts$idvars, priors = priors,  :
  The variable year is perfectly collinear with another variable in the data.

It seems to me that this is due to the fact that for the combination of country and year, there are missing values for all variables

Any help is appreciated

--

Member, Editorial Committee, The Economic and Labour Relations Review (a SAGE journal)

http://elr.sagepub.com/

Member, Editorial Committee, African Journal of Economic and Management Studies

http://emeraldgrouppublishing.com/products/journals/editorial_team.htm?id=ajems

https://www.researchgate.net/profile/Antonio_Andres (Research Gate profile)