rename observations which both belong to the same column.

[France]

Dear all,

How to rename observation 'UK' as 'GB' which both belong to the same column.

for example, I would like to transfer the following table1

table1
person_ctry_code, psn_name_cited
UK, apple
UK, pear
GB, juice

 to table2

table2
person_ctry_code, psn_name_cited
GB, apple
GB, pear
GB, juice

thanks in advance.

[novinosrin · Accepted solution]

just rename one

if upcase(country)='UK' then country='GB';