/*------------------------------------------------------------------------
* pwt623importfromcsv.do
*
* Created     2008/02/29 by Luke Stein
* Last edited 2009/09/22 by Luke Stein
*-------------------------------------------------------------------------
*
* INPUT:
*  pwt63.csv
*
*/


set more off

clear
set memory 10m

insheet using "pwt63.csv", clear






foreach var of varlist country countryisocode currency_unit {
	label variable `var'
}


foreach var of varlist  year pop xrat ppp cgdp cc cg ci p pc pg pi openc cgnp y yeks ycpdw rgdpl rgdpl2 rgdpch rgdptt openk kc kg ki rgdpeqa rgdpwok rgdpl2wok rgdpl2pe rgdpl2te rgdpl2th grgdpch grgdpl2 {
	cap replace `var' = "" if `var' == "na"
	cap destring `var', replace
	label variable `var'
}







label variable country "Country"
label variable countryisocode "Country ISO code"
label variable year "Year"
label variable currency_unit "National currency"
label variable pop "Population"
label variable xrat "Exchange rate"
label variable ppp "Purchasing Power Parity over GDP"
label variable cgdp "Real GDP per Capita"
label variable cc "Consumption share of CGPD"
label variable cg "Government share of CGDP"
label variable ci "Investment share of CGDP"
label variable p "Price level of GDP"
label variable pc "Price level of Consumption"
label variable pg "Price level of Government"
label variable pi "Price level of Investment"
label variable openc "Openness in current prices"
label variable cgnp "Ratio of GNP to GDP"
label variable y "CGDP relative to US (G-K method, current price)"
label variable yeks "CGDP relative to US (EKS method, current price)"
label variable ycpdw "CGDP relative to US (weighted CPD method, current price)"
label variable rgdpl "Real GDP per capita (constant prices: Laspeyres, growth rates of c, g, i)"
label variable rgdpl2 "Real GDP per capita (constant prices: Laspeyres, growth rates of domestic absorption)"
label variable rgdpch "Real GDP per capita (constant prices: chain series)"
label variable rgdpeqa "Real GDP per equivalent adult (chain series)"
label variable rgdpwok "Real GDP per worker (chain series)"
label variable rgdptt "Real Gross Domestic Income (RGDPL adjusted for terms of trade changes)"
label variable openk "Openness in constant prices"
label variable kc "Consumption share of RGDPL"
label variable kg "Government share of RGDPL"
label variable ki "Investment share of RGDPL"
label variable grgdpch "Growth rate of Real GDP per capita (chain series)"
label variable grgdpl2 "Growth rate of Real GDP per capita (Laspeyres, growth rates of domestic absorption)"
label variable rgdpl2wok "Real GDP per worker (Laspeyres, growth rates of domestic absorption)"
label variable rgdpl2pe "Real GDP per person engaged (Laspeyres, growth rates of domestic absorption)"
label variable rgdpl2te "Real GDP per person counted in total employment (Laspeyres, growth rates of domestic absorption)"
label variable rgdpl2th "Real GDP per hour worked by employees (Laspeyres, growth rates of domestic absorption)"



note: Source: Alan Heston, Robert Summers and Bettina Aten, Penn World Table Version 6.3, Center for International Comparisons of Production, Income and Prices at the University of Pennsylvania, August 2009.
note: Data downloaded as CSV and converted to Stata format TS by Luke Stein using pwt63importfromcsv.do


compress


save "pwt63.dta", replace

set more on