Tabulate the same variable multiple times

[Aarti Malik]

Dear all,

I need to tabulate variable Y conditioned on different values another variable X can take. Currently, I am using the following code:

tabulate Y if X == 1
tabulate Y if X == 2
tabulate Y if X == 3
tabulate Y if X == 4
tabulate Y if X == 5
tabulate Y if X == 6

I am wondering if there is a more efficient code, perhaps using the foreach loop to do this. Many thanks in advance!

[Ali Atia]

forvalues x = 1/6{
    tabulate Y if X == `x'
}

[Nick Cox]

I would try this first:

tab Y X

[Aarti Malik]

I would try this first:

tab Y X

Thanks, Nick! I also need the frequency and Cum. columns which gets lost with this code.

[Aarti Malik]

forvalues x = 1/6{
tabulate Y if X == `x'
}

Works like a charm, many thanks!

[Nick Cox]

Naturally you can add whatever options you want, e.g.

tabulate Y X, col row