Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: RE: Finding 3 most popular responses to a question


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: Finding 3 most popular responses to a question
Date   Sun, 28 Nov 2004 17:04:56 -0000

In addition to Ben's excellent program, note
also other efforts in this territory. 

http://www.stata.com/support/faqs/data/multresp.html

On structure & shape: the case of multiple responses. 
Stata Journal 3(1): 81--99 (2003)

I haven't tried to debug your program, as I suspect 
that other more general programs already exist. 

Nick 
n.j.cox@durham.ac.uk 

Jann, Ben
 
> -mrtab- on SSC might help. Type
> 
>  . ssc install mrtab
> 
> to download the program. Then type
> 
>  . mrtab concern1-concern3, poly response(1/6) countall sort
> 
> in order to see a table of counts for the 6 categories. It is 
> also possible to save count variable for the individual 
> categories:
> 
>   . mrtab concern1-concern3, poly response(1/6) countall ///
>     generate(C)
> 
> will produce 6 variables C1-C6 which can then be further
> processed by applying
> 
>  . collapse ..., by(VID)
> 
> A solution to deal with ties would be to apply -mrtab- 
> repeatedly: first to concern1-concern3, then to 
> concern1-concern2, then to concern1 (or just use 
> -tabulate- for the last step).
 
Farooq Naseer
 
> > A randomly selected group of people within some survey 
> > villages were given the
> > option to pick their top three every-day concerns: Of the six coded
> > options available, a respondent could pick, say, (4,4,2) and another
> > one in the same village could pick (1,6,5). (Duplicates like 4,4,..
> > occur due to the fact that the responses were post-coded into six
> > broad categories to make analysis simpler).
> > 
> > Now i want to get a measure for the community's top three priorities
> > by aggregating the information contained in the above individual
> > responses.
> > 
> > I have the above info in a stata dataset as variables:
> > concern1-concern3. To avoid complications re. appropriate weighing
> > scheme, for the time being, I just want to take an 
> unweighted count of
> > the values in these 3 variables for each village -- the variable VID
> > -- in my sample. In case there is a tie, for instance a village 'j'
> > has 20 responses each for values 4 and 6, I want to pick the value
> > which gets mentioned more in a higher-priority variable acc. to the
> > following priority ranking: concern1 > concern2 > concern3.
> > 
> > I know it should be straight-forward to handle in Stata. But after
> > having spent some on it, and seeking help from Stata's Programming
> > manual, the program I produced is not working correctly and is quite
> > inelegant in its use of all the nested loops. I attach the 
> program, as
> > is, below. Any help will be (greatly)^greatly appreciated!
> > 


*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index