Dear Statalisters,
I am looking for an elegant way of producing an indexed frequency table. In
particular,
I have observations on three variables:
ID var1 var2 var3
1 1 2 1
2 2 3 1
3 5 4 5
4 6 6 6
...
And I would like to produce a table showing only different patterns and
there observed frequencies, ie.
var1 var2 var3 frequency
First pattern 1 1 1 54
Second pattern 1 1 2 43
....
Using -egen group- generates only the observed frequencies, but how to
display only the distinct patterns?
Any suggestions?
Best wishes,
Thomas
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
