* Air Pollution in Cities 2000 (WLD_2000_APC_v01_M) * Conversion from XLS to Stata 10 format * ------------------------------------------------- * Run this after copy/pasting data at country level rename var1 ctrycode rename var2 ctryname rename var3 up2000 rename var4 pm10c_1999 la var ctrycode "Country code" la var ctryname "Country name" la var up2000 "Urban population, 2000" la var pm10c_1999 "PM10 concentration level, 1999" sort ctrycode compress save "D:\Archive\WLD_2000_APC_v01_M\Data\AP_country.dta", replace * Run this after copy/pasting data at city level * Note that a few missing values for "Country name" were filled in Excel based on country code rename var1 ctrycode rename var2 ctryname rename var3 citycode rename var4 cityname rename var5 cp2000 rename var6 pm10c_1999 la var pm10c_1999 "PM10 concentration level, 1999" la var ctryname "Country name" la var cp2000 "City population, 2000" la var ctrycode "Country code" la var cityname "Country name" la var citycode "City code" sort ctrycode citycode compress save "D:\Archive\WLD_2000_APC_v01_M\Data\AP_city.dta", replace