How to sort group observations in ascending order

[Fariha Zaman]

I am working on HIES data

TERM PSU HHID S2AQ0A S2AQ00 S2AQ01 S2AQ02
1 1 6 2 4 1 1
1 1 6 2 1 1 1
1 1 6 2 2 1 2
1 1 6 2 3 2 2
1 1 9 4 3 1 1
1 1 9 4 5 1 1
1 1 9 4 2 1 1
1 1 9 4 6 1 1
1 1 9 4 1 1 1
1 1 9 4 4 1 1
1 1 14 4 3 1 1
1 1 14 4 4 1 1
1 1 14 4 1 1 1
1 1 14 4 2 1 1
1 1 14 4 5 1 1
1 1 28 1 4 2 2
1 1 28 1 3 2 2
1 1 28 1 1 2 2
1 1 28 1 2 2 2
1 1 28 1 8 2 2
1 1 28 1 7 2 2
1 1 28 1 6 1 1
1 1 28 1 5 2 2
1 1 29 2 1 1 1
1 1 29 2 2 1 1
1 1 29 2 3 1 1
1 1 33 2 1 1 1
1 1 33 2 3 1 1
1 1 33 2 4 1 1
1 1 33 2 2 1 1
1 1 38 1 1 2 2
1 1 38 1 3 1 1
1 1 38 1 2 2 2
1 1 38 1 4 1 1
1 1 45 2 1 1 1
1 1 45 2 2 1 1
1 1 48 2 2 2 2
1 1 48 2 1 1 1
1 1 54 1 1 1 1
1 1 54 1 2 1 1
1 1 54 1 3 1 1
1 1 65 3 2 2 2
1 1 65 3 4 2 2
1 1 65 3 5 1 1
1 1 65 3 1 2 2
1 1 65 3 3 1 1
1 1 67 1 1 1 1
1 1 67 1 3 1 1
1 1 67 1 2 1 1
1 1 72 1 2 1 1
1 1 72 1 1 1 1
1 1 72 1 4 1 1
1 1 73 2 1 1 1
1 1 73 2 2 1 1
1 1 74 1 3 1 1
1 1 74 1 4 1 1
1 1 74 1 1 1 1
1 1 74 1 2 1 1
1 1 75 2 1 1 1
1 1 75 2 3 1 1
1 1 75 2 2 1 1
1 1 84 2 1 2 2
1 1 84 2 2 1 1
1 1 84 2 4 1 1
1 1 85 1 2 1 1
1 1 85 1 1 1 1
1 1 100 1 2 1 1
1 1 100 1 1 1 1
1 1 109 2 4 1 1
1 1 109 2 2 1 1
1 1 109 2 1 1 1
3 2 7 1 2 2 2
3 2 7 1 3 1 1
3 2 7 1 1 2 2
3 2 12 2 2 2 2
3 2 12 2 1 2 2
3 2 12 2 5 2 2
3 2 12 2 3 2 2
3 2 12 2 4 2 2
3 2 19 4 2 2 2
3 2 19 4 3 1 1
3 2 19 4 7 1 1
3 2 19 4 1 2 2
3 2 19 4 4 1 1
3 2 28 1 3 1 1
3 2 28 1 1 2 2
3 2 28 1 2 2 2
3 2 28 1 4 1 1
3 2 29 2 1 1 1
3 2 29 2 2 2 2
3 2 29 2 3 1 1
3 2 30 2 2 1 1
3 2 30 2 1 2 2
3 2 36 2 1 2 2
3 2 36 2 2 2 2
3 2 38 2 2 2 2
3 2 38 2 3 1 1
3 2 38 2 1 2 2
3 2 38 2 4 2 2
3 2 40 1 1 2 2

S2AQ0A is respondent id code and S2AQ00 is my household member id code. S2AQ00 is not in ascending order. For example in the first HHID the order is 4,1,2,3 but I need in ascending order to generate the household id. I cannot sort A2AQ00 otherwise it was tamper the sequence of the household member id. How can I order the S2AQ00 variable?

[Andrew Musau]

You are allowed to sort multiple variables at once. Doing this will yield your desired result.

sort TERM PSU HHID S2AQ0A S2AQ00

[Fariha Zaman]

Thank you. It worked