rename observations which both belong to the same column.

France — Mon, 19 Nov 2018 17:40:48 GMT

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.

Re: rename observations which both belong to the same column.

novinosrin — Mon, 19 Nov 2018 17:43:31 GMT

just rename one

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