* 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