BookmarkSubscribeRSS Feed
Tirth8
Calcite | Level 5

 

Create a new variable for place of residence, classifying everyone as residing in Mumbai or somewhere else (i.e., group guj, delhi, etc., into a single “Other” category). 

 

I have an existing data set in which one column is named as address: in which diff states are mentioned

Now I need to group them in two only one mumbai and rest of all in other

 

What code should be written?

3 REPLIES 3
ballardw
Super User

Extract the state into a separate variable if it is not already. Then either an IF/then/else block of code can assign the value you want.

Or a custom format could display the values of the variable with the state value as desired with the existing values unchanged.

PeterClemmensen
Tourmaline | Level 20

If you have existing data, then please post a representative sample and your desired result.

 

Makes it much easier to provide a usable code answer.

tom_grant
SAS Super FREQ
if index(upcase(address),'MUMBAI)>0 then state = 'Mumbai' else state = 'Other';

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 3 replies
  • 635 views
  • 1 like
  • 4 in conversation