/* Before running this program, all xls files should be converted into csv format */ clear insheet using "C:\ALL_FDS\Work\request8095.csv" compress la var name "Name of the country " la var cc "ISO country code " la var growthsh "Growth rate, SH" la var rgdpsh "Initial GDP, SH" la var lrgdpsh "Log(Initial GDP, SH)" la var lac "Latin America" la var eca "Europe and Central Asia" la var mna "Middle East/North Africa" la var afr "Sub-Saharan Africa" la var sas "South Asia" la var eap "East Asia/Pacific" la var oecd "OECD" la var oil "Oil" la var assass "Assassinations" la var civil "Civil Rights" la var revc "Revolutions/Coups" la var bmp "BMP" la var lbmp "Log(BMP)" la var bmpi "Initial BMP" la var lbmpi "Log(Initial BMP)" la var pi "Inflation" la var lpi "Log(Inflation)" la var pii "Initial Inflation" la var lpii "Log(Initial Inflation)" la var initial "Initial GDP" la var linitial "Log (Initial GDP)" la var trade "Trade" la var tradei "Initial Trade" la var gov "Government expenditure" la var govi "Initial Govt. expenditure" la var growth "Growth rate" la var capgrols "Capital growth" la var school80 "Schooling 1980" la var school90 "Schooling 1990" la var gschool "Growth in schooling" la var returned80 "Return on education 80" la var returned90 "Return on education 90" la var dhuman "Change in Human capital" la var prod1 "Productivity growth 1" la var prod2 "Productivity growth 2" la var prod3 "Productivity growth 3" la var psr_ca "Private savings" la var corp "Corporate tax" la var corploc "Corporate local tax" la var distprt "Corporate profit tax" la var person "Personal tax" la var persloc "Personal local tax" la var capgain "Capital Gains tax" la var interest "Interest tax" la var divid "Dividend tax" la var rebdivd "Dividend rebate" la var netint "Net interest" la var netcapg "Net Capital Gain" la var netdiv "Net Dividend" la var dadvdiv "Dividend Disadvantage" la var dadvcg "Capital Gain Disadvantage" la var account "Accounting" la var one "One share-one vote" la var proxy "Proxy by mail" la var blocked "Shares not blocked" la var cumvote "Cumulative voting" la var minor "Oppressed minority" la var preemptn "Preemptive rights" la var esmreq "Extraordinary meeting" la var srights "Anti-director rights" la var mandiv "Mandatory dividend" la var reorg "Reorganization" la var autostay "No automatic stay" la var secured1 "Secured first" la var manages "No management stay" la var crights "Creditor Rights" la var reserve "Legal reserve" la var gini "Gini coefficent" la var govrep "Government repudiation" la var exprop "Expropriation risk" la var law "Law and order" la var contract "Contract enforceability" la var corrupt "Corruption" la var taxevas "Tax compliance" la var avelf "Ethnic fractionalization" la var bureau "Bureaucratic quality" la var catho80 "Catholic share" la var muslim80 "Muslim Share" la var protmg80 "Protestant Share" la var no_cpm80 "Other religion share" la var legor_uk "British origin" la var legor_fr "French origin" la var legor_so "Communist origin" la var legor_ge "German origin" la var legor_sc "Scandinavian origin" la var lat_abst "Latitude" la var f_prop97 "Property rights" la var f_regu97 "Regulation" la var soe "SOEs in the economy" la var mcap "Stock market capitalization" la var tvt "Total value traded" la var tor "Turnover ratio" la var privateb "Private bond market" la var publicbo "Private bond market" la var equityis "Equity issues" la var longterm "Debt issues" la var bia "Banklike institutions assets" la var lifea "Life insurance assets" la var insa "Insurance assets" la var pensiona "Pension assets" la var mutuala "Mutual fund assets" la var devta "Development banks assets" la var bip "Banklike institutions assets" la var lifep "Life insurance assets" la var insp "Insurance assets" la var pensionp "Pension assets" la var mutualp "Mutual fund assets" la var devtp "Development banks assets" la var nonpen "Nonlife penetration" la var lifepen "Life penetration" la var nondens "Nonlife density" la var lifedens "Life density" la var conc "Concentration" la var foreigna "Foreign Banks (Assets)" la var foreignn "Foreign Banks (Number)" la var overhead "Overheads costs" la var netinter "Net interest margin" la var publicsh "Public share" la var cbt "Central Bank Assets /Total Financial Assets" la var dbt "Deposit Money Bank Assets / Total Financial Assets" la var oft "Other Financial Inst. Assets /Total Financial Assets" la var btot "Deposit Money-Central Bank" la var lly "Liquid Liabilities" la var cby "Central bank Assets" la var dby "Deposit Money Bank Assets" la var ofy "OFI Assets" la var priv "Bank Credit" la var ofp "OFI Credit" la var privo "Private Credit" la var income "Income group" la var oversize "Overall size" la var over1 "Overall efficiency 1" la var over2 "Overall efficiency 2" la var over3 "Overall efficiency 3" la var over4 "Overall efficiency 4" la var dbmcap "Relative bank size 1" la var dbofy "Relative Bank Size 2" la var dbtvt "Relative Bank Activity" la var oftvt "Relative Nonbank Activity" la var tvover "Relative market efficiency 1" la var tvnet "Relative market efficiency 2" la var structur "Structure index" la var market "Market" la var develop "Developed" la var secure "Securitites" la var insure "Insurance" la var estate "Real Estate" la var bankinnf "Nonfinancial firms" la var restrict "Restricted banking" la var deposit80 "Deposit insurance" encode name, gen(name_code) encode cc, gen(cc_code) save "C:\ALL_FDS\Data\request8095", replace ********************************************* clear insheet using "C:\ALL_FDS\Work\FinStructure_60_04_final.csv" compress label var cn "Country" label var cncode "WB Country Code" label var region "WB Region" label var incgr "WB Income Group" label var year "Year" label var cbata "Central Bank Assets / Total Financial Assets" label var dbata "Deposit Money Bank Assets / Total Financial Assets" label var ofata "Other Financial Institutions Assets / Total Financial Assets" label var dbacba "Deposit Money Bank Assets / (Deposit Money + Central) Bank Assets" label var llgdp "Liquid Liabilities / GDP" label var cbagdp "Central Bank Assets / GDP" label var dbagdp "Deposit Money Bank Assets / GDP" label var ofagdp "Other Financial Institutions Assets / GDP" label var pcrdbgdp "Private Credit by Deposit Money Banks / GDP" label var pcrdbofgdp "Private Credit by Deposit Money Banks and Other Financial Institutions / GDP" label var bdgdp "Bank Deposits / GDP" label var fdgdp "Financial System Deposits / GDP" label var overhead "Bank Overhead Costs / Total Assets" label var netintmargin "Net Interest Margin" label var concentration "Bank Concentration" label var inslife "Life Insurance Premium Volume / GDP" label var insnonlife "Non-Life Insurance Premium Volume / GDP" label var stmktcap "Stock Market Capitalization / GDP" label var stvaltraded "Stock Market Total Value Traded / GDP" label var stturnover "Stock Market Turnover Ratio" label var prbond "Private Bond Market Capitalization / GDP" label var pubond "Public Bond Market Capitalization / GDP" encode cn, gen(cn_code) encode cncode, gen(cn_iso) encode region, gen(reg_code) encode incgr, gen(incgr_code) save "C:\ALL_FDS\Data\FinStructure_60_04_final", replace ********************************************************** clear insheet using "C:\ALL_FDS\Work\FinStructure_2007.csv" compress la var cn "Country" la var cncode "WB Country Code" la var year "Year" la var region "WB Region" la var incgr "WB Income Group" la var dbacba "Deposit Money Bank Assets / (Deposit Money + Central) Bank Assets" la var llgdp "Liquid Liabilities / GDP" la var cbagdp "Central Bank Assets / GDP" la var dbagdp "Deposit Money Bank Assets / GDP" la var ofagdp "Other Financial Institutions Assets / GDP" la var pcrdbgdp "Private Credit by Deposit Money Banks / GDP" la var pcrdbofgdp "Private Credit by Deposit Money Banks and Other Financial Institutions / GDP" la var bdgdp "Bank Deposits / GDP" la var fdgdp "Financial System Deposits / GDP" la var bcbd "Bank Credit / Bank Deposits" la var outbase "Currency Outside Banking System / Base Money" la var ll_usd "Liquid Liabilities (in mil. 2000 USD)" la var overhead "Bank Overhead Costs / Total Assets" la var netintmargin "Net Interest Margin" la var concentration "Bank Concentration" la var roa "Bank ROA" la var roe "Bank ROE" la var costinc "Bank Cost-Income Ratio" la var zscore "Bank Z-Score" la var inslife "Life Insurance Premium Volume / GDP" la var insnonlife "Non-Life Insurance Premium Volume / GDP" la var stmktcap "Stock Market Capitalization / GDP" la var stvaltraded "Stock Market Total Value Traded / GDP" la var stturnover "Stock Market Turnover Ratio" la var listco_emdb "No. of listed companies (EMDB)" la var prbond "Private Bond Market Capitalization / GDP" la var pubond "Public Bond Market Capitalization / GDP" la var intldebt "International debt issues/GDP" la var intldebtnet "Loans from non-resident banks (net)/GDP" la var nrbloan "Loans from non-resident banks (amt outstanding)/GDP" la var offdep "Offshore Bank Deposits / Domestic Bank Deposits" la var remit "Remittance Inflows / GDP" encode cn, gen(cn_code) encode cncode, gen(cn_iso) encode region, gen(reg_code) encode incgr, gen(incgr_code) save "C:\ALL_FDS\Data\FinStructure_2007", replace ******************************************************** clear insheet using "C:\ALL_FDS\Work\FinStructure_2007_v2_2.csv" compress la var cn "COUNTRY" la var cncode "WB COUNTRY CODE" la var year "YEAR" la var region "WB REGION" la var incgr "WB INCOME GROUP" la var bdgdp "BANK DEPOSITS / GDP" la var cbagdp "CENTRAL BANK ASSETS / GDP" la var dbagdp "DEPOSIT MONEY BANK ASSETS / GDP" la var fdgdp "FINANCIAL SYSTEM DEPOSITS / GDP" la var intldebt "INTERNATIONAL DEBT ISSUES / GDP" la var llgdp "LIQUID LIABILITIES / GDP" la var nrbloan "LOANS FROM NON-RESIDENT BANKS (AMT OUTSTANDING) / GDP" la var ofagdp "OTHER FINANCIAL INSTITUTIONS ASSETS / GDP" la var pcrdbgdp "PRIVATE CREDIT BY DEPOSIT MONEY BANKS / GDP" la var pcrdbofgdp "PRIVATE CREDIT BY DEPOSIT MONEY BANKS AND OTHER FINANCIAL INSTITUTIONS / GDP" la var prbond "PRIVATE BOND MARKET CAPITALIZATION / GDP" la var pubond "PUBLIC BOND MARKET CAPITALIZATION / GDP" la var stmktcap "STOCK MARKET CAPITALIZATION / GDP" la var bcbd "BANK CREDIT / BANK DEPOSITS" la var concentration "BANK CONCENTRATION" la var costinc "BANK COST-INCOME RATIO" la var dbacba "DEPOSIT MONEY BANK ASSETS / (DEPOSIT MONEY + CENTRAL) BANK ASSETS" la var inslife "LIFE INSURANCE PREMIUM VOLUME / GDP" la var insnonlife "NON-LIFE INSURANCE PREMIUM VOLUME / GDP" la var intldebtnet "LOANS FROM NON-RESIDENT BANKS (NET) / GDP" la var listco_pc "NO. OF LISTED COMPANIES PER 10K POPULATION" la var ll_usd "LIQUID LIABILITIES (IN MIL. 2000 USD)" la var netintmargin "NET INTEREST MARGIN" la var offdep "OFFSHORE BANK DEPOSITS / DOMESTIC BANK DEPOSITS" la var overhead "BANK OVERHEAD COSTS / TOTAL ASSETS" la var remit "REMITTANCE INFLOWS / GDP" la var roa "BANK ROA" la var roe "BANK ROE" la var stturnover "STOCK MARKET TURNOVER RATIO" la var stvaltraded "STOCK MARKET TOTAL VALUE TRADED / GDP" encode cn, gen(cn_code) encode cncode, gen(cn_iso) encode region, gen(reg_code) encode incgr, gen(incgr_code) save "C:\ALL_FDS\Data\FinStructure_2007_v2_2", replace ******************************************************** clear insheet using "C:\ALL_FDS\Work\FinStructure_2008_v4.csv" compress la var cn "COUNTRY" la var cncode "WB COUNTRY CODE" la var year "YEAR" la var region "WB REGION" la var incgr "WB INCOME GROUP" la var dbacba "DEPOSIT MONEY BANK ASSETS / (DEPOSIT MONEY + CENTRAL) BANK ASSETS" la var llgdp "LIQUID LIABILITIES / GDP" la var cbagdp "CENTRAL BANK ASSETS / GDP" la var dbagdp "DEPOSIT MONEY BANK ASSETS / GDP" la var ofagdp "OTHER FINANCIAL INSTITUTIONS ASSETS / GDP" la var pcrdbgdp "PRIVATE CREDIT BY DEPOSIT MONEY BANKS / GDP" la var pcrdbofgdp "PRIVATE CREDIT BY DEPOSIT MONEY BANKS AND OTHER FINANCIAL INSTITUTIONS / GDP" la var bdgdp "BANK DEPOSITS / GDP" la var fdgdp "FINANCIAL SYSTEM DEPOSITS / GDP" la var bcbd "BANK CREDIT / BANK DEPOSITS" la var ll_usd "LIQUID LIABILITIES (IN MIL. 2000 USD)" la var overhead "BANK OVERHEAD COSTS / TOTAL ASSETS" la var netintmargin "NET INTEREST MARGIN" la var concentration "BANK CONCENTRATION" la var roa "BANK ROA" la var roe "BANK ROE" la var costinc "BANK COST-INCOME RATIO" la var zscore "BANK Z-SCORE" la var inslife "LIFE INSURANCE PREMIUM VOLUME / GDP" la var insnonlife "NON-LIFE INSURANCE PREMIUM VOLUME / GDP" la var stmktcap "STOCK MARKET CAPITALIZATION / GDP" la var stvaltraded "STOCK MARKET TOTAL VALUE TRADED / GDP" la var stturnover "STOCK MARKET TURNOVER RATIO" la var listco_pc "NO. OF LISTED COMPANIES PER 10K POPULATION" la var prbond "PRIVATE BOND MARKET CAPITALIZATION / GDP" la var pubond "PUBLIC BOND MARKET CAPITALIZATION / GDP" la var intldebt "INTERNATIONAL DEBT ISSUES / GDP" la var intldebtnet "LOANS FROM NON-RESIDENT BANKS (NET) / GDP" la var nrbloan "LOANS FROM NON-RESIDENT BANKS (AMT OUTSTANDING) / GDP" la var offdep "OFFSHORE BANK DEPOSITS / DOMESTIC BANK DEPOSITS" la var remit "REMITTANCE INFLOWS / GDP" encode cn, gen(cn_code) encode cncode, gen(cn_iso) encode region, gen(reg_code) encode incgr, gen(incgr_code) save "C:\ALL_FDS\Data\FinStructure_2008_v4", replace ********************************************************