Title: Fertility decline, changes in age structure and the potential for demographic dividends: A global analysis
Authors: Markus Dörflinger, Elke Loichinger

*********************************************************************************************
The "Replication files" .zip archive for this publication contains the following folders and files:


***** Folder: STATA_Do-Files
STATA-Do-Files for data preparation and analysis

00_get_UN_Data.do 
	- load excel sheets from UN Data
	- merge to dataset

01_Data_preparation.do
	- create variables for analysis

02_Cluster.do
	- run cluster analyses
	- run cluster diagnosis

03_Regressions.do
	- run regression models
	- run post-estimation
	
04_Robustnesschecks.do
	- create variables (alternative definitions of working-age)
	- run robustness checks

05_Prediction_intervals.do
	- load 95% prediction intervals from UN Data
        - create variables for analysis based on lower and upper bound of prediction intervals


****** Folder: STATA_Data
STATA Datasets

UN_data_2022.dta
	- Long data by country and year (1950-2100)

UN_data_2022_short.dta
	- Short data by country 

UN_data_2022_short_12.dta
	- Short data by country for import in RStudio (Stata version 12)

UN_data_2022_12.dta
	- Long data by country and year (1950-2100) for import in RStudio (Stata version 12)


***** Folder: R_Files
R-Code for tables and plots

06_Analysis.R
	- read STATA data
	- create tables and plots


*********************************************************************************************
Data from the United Nations World Population Prospects 2022 can be downloaded here:
https://population.un.org/wpp


*********************************************************************************************
Program versions used: Stata Version 16.0, RStudio "Cherry Blossom" 2023.03.0. Files may not be compatible with other versions.




*********************************************************************************************
*********************************************************************************************