<p>I want to run a panel VARX and some of my variables are bilateral trade and between countries in sub-Saharan Africa and China as well as FDI. Unfortunately the data I could find from official Chinese records only begin in 1992 and 2003 for trade and FDI respectively. </p>

<p>I am aware that there is data available at COMTRADE and UNCTAD. However, the data from UNCTAD does not describe the source of FDI for data before the 2000s. COMTRADE data varies significantly from official Chinese records because not all countries, especially in developing regions, follow the same reporting standards. For consistency, I prefer to use the official Chinese records. </p>

<p>As much as I wanted to consider a large time frame, due to data availability, I will only consider 1990-2018. As such, I am missing 2 years for trade data and 13 years for FDI data. In some cases, data entries begin with 0 and remain 0 for a couple of years before non-zero numbers appear. So in theory, data points before will also be 0. However, I am not so confident in this logic. Looking at other research, it seems people avoid this problem by shortening their time series or imputing data.  </p>

<p>I am wondering how I can balance my data? Is there anyway to impute at least some of the data by deriving it from trade/FDI between SSA and the rest of the world for example? Or if there exists other data bases.</p>

<p>PS: Sorry if this is in the wrong section! </p>

CC BY-SA 4.0
2020-06-10T10:31:48.227Z
Imputing FDI for the early years seems unlikely to add information: China's interactions with the rest of the world has changed in recent years
Henry
CC BY-SA 4.0
2020-06-10T12:50:01.080Z
Have you checked the world bank group or IMF for related data series?
Mike J
<econometrics><paneldata>
Missing trade and FDI data in Time Series
user28358
# Missing trade and FDI data in Time Series

(Asked by: username_0 on 2020-06-10)

I want to run a panel VARX and some of my variables are bilateral trade and between countries in sub-Saharan Africa and China as well as FDI. Unfortunately the data I could find from official Chinese records only begin in 1992 and 2003 for trade and FDI respectively.

I am aware that there is data available at COMTRADE and UNCTAD. However, the data from UNCTAD does not describe the source of FDI for data before the 2000s. COMTRADE data varies significantly from official Chinese records because not all countries, especially in developing regions, follow the same reporting standards. For consistency, I prefer to use the official Chinese records.

As much as I wanted to consider a large time frame, due to data availability, I will only consider 1990-2018. As such, I am missing 2 years for trade data and 13 years for FDI data. In some cases, data entries begin with 0 and remain 0 for a couple of years before non-zero numbers appear. So in theory, data points before will also be 0. However, I am not so confident in this logic. Looking at other research, it seems people avoid this problem by shortening their time series or imputing data.

I am wondering how I can balance my data? Is there anyway to impute at least some of the data by deriving it from trade/FDI between SSA and the rest of the world for example? Or if there exists other data bases.

PS: Sorry if this is in the wrong section!

**Tags:** econometrics, paneldata
> **Comments:**
> **username_1**: Imputing FDI for the early years seems unlikely to add information: China's interactions with the rest of the world has changed in recent years  
> **username_2**: Have you checked the world bank group or IMF for related data series?  

---

## 0 answers

