Hi all,

I need your help. I have a dataset with two variables:
- Username
- Round: Ordinal number of rounds.

I would like to get the spell of each user: at which round he starts and at which round he ends.

Thank you for your help.

Here is the dataset:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str18 username int round
"user E"  1
"user C"  1
"user D"  1
"user E"  2
"user C"  2
"user D"  2
"user E"  3
"user C"  3
"user D"  3
"user E"  4
"user C"  4
"user D"  4
"user E"  5
"user C"  5
"user D"  5
"user E"  6
"user C"  6
"user D"  6
"user F"  6
"user E"  7
"user D"  7
"user F"  7
"user E"  8
"user D"  8
"user F"  8
"user E"  9
"user D"  9
"user F"  9
"user E" 10
"user D" 10
"user F" 10
"user A" 10
end