I have a variable with city names and I want to create a new variable which a unique number for each city.
I want my dataset to look like as follows:
CITY_NAME CITY_ID
Delhi 1
Delhi 1
Kolkata 2
Mumbai 3
Mumbai 3
Pune 4

How do I generate the numerical variable CITY_ID from the variable CITY_NAME?