topic Re: How to Create a new variable from existing data set in SAS Software for Learning Community

How to Create a new variable from existing data set

Tirth8 — Thu, 27 Oct 2022 01:26:34 GMT

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?

Re: How to Create a new variable from existing data set

ballardw — Thu, 27 Oct 2022 06:41:19 GMT

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.

Re: How to Create a new variable from existing data set

PeterClemmensen — Thu, 27 Oct 2022 09:50:43 GMT

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.

Re: How to Create a new variable from existing data set

tom_grant — Mon, 07 Nov 2022 01:33:51 GMT

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