Rename Inside of a Column

[Anass Wajib]

Hello,

Any idea how to rename the countries code within (code) column. For instance AD stands for the country of ANDORRA. I want to change it to a 3-character format like ADR as to make it easier to merge with World Bank Database.

Cheers.

[Nick Cox]

This is a job for the replace command. You can replace values of a variable (the term to use here, better than column) with e.g.

replace code = "ADR" if code == "AD"

[Anass Wajib]

Nick Cox Thank you ever so much, you've spared me much headache, and cheers for the remark.

[Clyde Schechter]

You might also want to look into Rafal Raciborski's -kountry- package, from SSC. It automates the process of translating among various country code systems and also their full names.