Create a simple grouping variable

[Chris Dalton]

Hello

I'm sure this is something simple but how do you create a grouping variable (say "Group") where Group=1 for for the first 10 observations, Group=2 for the next 10 and so on without writing

gen Group=1 if _n<=10

then

replace Group=2 if Group==. &_n<=20

then

replace Group=3 if Group=. & _n<=30

etc.etc.

or a loop of some sort.

Regards

Chris

[Nick Cox]

gen group = ceil(_n/10) 

egen group = seq(), block(10)

Note that even with #1 you can simplify to

 
 gen Group=1 in 1/10  
 replace Group=2 in 11/20   
 replace Group=3 in 21/30

I am not recommending that, but it's less typing than #1 (and a little more efficient too).

[Chris Dalton]

Thanks Nick.
Thought there would be an efficient way like that but i just couldn't find it.
Regards
Chris