Hi,

I would like to create a categorical variable (4 categories) for each variable.

I organized the data file in this format:

Code:
ID_Code              ID_name            total_empl         salary           employee
011                Paris                131                 1456             44
011                Paris                156                 1496             78
011                Paris                153                 2345            99
011                Paris                89                   9904             59
021                Berlin               156                 2233             56
021               Berlin                123                 4455             84
021               Berlin                 89                  2235             78
021               Berlin                134                  7753            79
I would like to create a categorical variable named "Group_id" from 1 - 4 in order for each ID_Code.

The format I want is:
Code:
ID_Code             ID_name          total_empl          salary        employee         Group_id
011                Paris                131                 1456             44                 1
011                Paris                156                 1496             78                 2
011                Paris                153                 2345            99                  3
011                Paris                89                   9904             59                 4
021                Berlin               156                 2233             56                1
021               Berlin                123                 4455             84                2
021               Berlin                 89                  2235             78                3
021               Berlin                134                  7753            79                4
Thank you soooo much!