Good evening everyone.

I need urgent help for two problems:

1) as someone has just reported, I found values for import from Brazil to Brazil or from China to China and so on, for other type of country. Is there any problem with the dataset? What happens?

2) I have noted that when there's a missing value, UNcomtrade drops the entire "row" of the dataset. For example: if there's not trade values for Italy and Canada, I don't find a row in the dataset which indicates the missing value. This is a huge problem for me that I've to have a dataset with 50x50 values for 11 years. I can't correct by my hands the entire dataset! Is there a way to avoid dropping by UNComtrade of missing-values rows?

 Thank you very much. Have a nice evening.

 Andrea Colombo 

1) Yes it is possible to import from itself (it's called re-imports). For further info, see: See http://comtrade.un.org/kb/article.aspx?id=10038 or go find International Merchandise Trade Statistics Concepts & Definitions Rev.2 http://comtrade.un.org/kb/article.aspx?id=10173

2) UN Comtrade does not provide option to keep the missing values. What you can do:

-  Use Microsoft Access or similar database program to join result table with master table (contain all countries). The join will reveal missing values