Hello,

My data looks like this:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str4 city byte id long id2 double time
"ATLA" 1 13 160
"ATLA" 1 13 161 
"ATLA" 1 13 162
"ATLA" 1 13 163
“NYC" 2 13 160
"NYC" 2 13 161
"NYC" 2 13 162
"NYC" 2 13 163
"ATLA" 1 14 160
"ATLA" 1 14 161 
"ATLA" 1 14 162
"ATLA" 1 14 163
“NYC" 2 14 160
"NYC" 2 14 161
"NYC" 2 14 162
"NYC" 2 14 163
end
format %tq time
I want it to be sorted as such:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str4 city byte id long id2 double time
"ATLA" 1 13 160
"NYC" 2 13 160
"ATLA" 1 13 161
"NYC" 2 13 161
“ATLA" 1 13 162
"NYC" 2 13 162
"ATLA" 1 13 163
"NYC" 2 13 163
"ATLA" 1 14 160
"NYC" 2 14 160 
"ATLA" 1 14 161
"NYC" 2 14 161
“ATLA" 1 14 162
"NYC" 2 14 162
"ATLA" 1 14 163
"NYC" 2 14 163
end
format %tq time
I would appreciate any assistance.

Thanks,
Anoush K.