### Friday, January 06, 2006

## Re: st: Some kind of count or tabulation?

thanks to nick and scott for their replies. i understand what scott tried to do but looking at his commands made me realised that perhaps he, and by extension also nick too, misunderstood my question, which could be better expressed in retrospect. i have less of an understanding of nick's commands since it has something to do with macros (afraid my stata fluency don't go that far yet).

however, running scott's command viz-a-viz nick's showed a difference of 1, e.g. scott's would return a value of 78 whilst nick's 77. i am not sure why that is the case. be that as it may, neither was what i was looking for. so thinking laterally, using what i knew of stata, here's what i did to get what i want.

gen dumvar1=. gen dumvar2=. . . . sort var1 by var1: replace dumvar1 = 1 if var1 == "jacn" by var1: replace dumvar1 = 1 if var1 == "bstr" sort dumvar1 replace dumvar1 = 0 if dumvar1==. . . . sort var2 by var2: replace dumvar2 = 1 if var2 == "clstr" by var2: replace dumvar2 = 1 if var2 == "rct" by var2: replace dumvar2 = 1 if var2 == "xovr" sort dumvar2 replace dumvar1 = 0 if dumvar1==. . . gen total = var1 + var2 +... sort total l obs total

but...

1. not elegant (not a problem since it does the job) 2. it loses the information the variables conveyed by replacing with 1's (not ideal) 3. initially at least it looked like amadou's tablemat would be helpful but unfortunately it was not

so...

would appreciate (if nothing else, for my own stata's education now) further help/advice to shorten the do-file if possible (i think it needed -foreach val- at the beginning).

regards, bw

>From: smerryman@kc.rr.com >Reply-To: statalist@hsphsun2.harvard.edu >To: statalist@hsphsun2.harvard.edu >Subject: Re: st: Some kind of count or tabulation? >Date: Thu, 05 Jan 2006 14:33:03 -0600 > >-egen all_var = rmiss(Var*)- > >-count if all_var == 0 - > > >Scott > > >----- Original Message ----- >From: "b. water" <barleywater@hotmail.com> >Date: Thursday, January 5, 2006 2:09 pm >Subject: st: Some kind of count or tabulation? > > > Dear all, > > > > Stata 8.2 Windows XP Pro SP2 > > > > My data set looks like this: > > > > obs Var1 Var2 Var3 Var(nth) > > 1 jacn clstr lnreg pval > > 2 bstr . lgreg nopval > > 3 . rct . nopval > > 4 jacn clstr anova . > > > > What I want to do firstly is to count frequencies of features in > > each > > variable, which I did with tab1 varlists. Then what I want to find > > out is > > simply how many observations contained all the variables, e.g. in > > this > > example, only 1 observation i.e. the first (observation 1) > > contained all the > > variables. I think it has something to do with tabulate but just > > couldn't > > get the syntax for this. Any help/advise is appreciated. > > > > Regards, > > bw > > >* >* 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/

_________________________________________________________________ Don�t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

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

Tag: statalist