Jean-Benoit Hardouin
> I search a method to transform a data as :
> Item1 Item2 Item3 Item4 0 0 1 2 1 3 0 1
> 3 0 2 1
> (table of the responses of individuals to four items) in
> Item1 Item2 Item3 Item4 Count
> 0 0 0 0 125
> 0 0 0 1 88
> 0 0 0 2 72
> 0 0 0 3 52
> 0 0 1 0 28
> 0 0 1 1 65
> 0 0 1 2 42
> ...
> where 125 is the number of individuals who have respond 0 to each
item, 88
> is the number of individuals who have respond 0 to the first three
item and
> 1 to the last item, etc.
> I don't find how to obtain this kind of table with "reshape" or
"egen" (for
> example).
> I have idea to program that with four "forvalues..." but perhaps it
exist a
> specific command.
For a first-principles solution:
bysort Item? : gen Count = _N
by Item? : gen tag = _n == 1
list Item? Count if tag
For a canned solution, with extra bells and whistles:
ssc inst groups
groups Item? , show(f) showhead(Count)
whelp groups
Nick
[email protected]
*
* 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/
