How to Create a new variable from existing data set

[Tirth8]

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?

[ballardw]

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]

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]

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