BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
France
Quartz | Level 8

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

just rename one

 

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

 

View solution in original post

1 REPLY 1
novinosrin
Tourmaline | Level 20

just rename one

 

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

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 813 views
  • 2 likes
  • 2 in conversation