It can also be done without generating a new
variable.
unab var : *
local var : subinstr local var " " ",", all
count if !mi(`var')
Nick
[email protected]
[email protected]
> -egen all_var = rmiss(Var*)-
>
> -count if all_var == 0 -
[email protected]
> > 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.
*
* 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/