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

st: RE: RE: RE: tabulation of variables


From   "Nick Winter" <nwinter@policystudies.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: RE: tabulation of variables
Date   Mon, 23 Sep 2002 11:23:04 -0400

Unless I'm misunderstanding, then my code will do it for you.  Calling
your variables v1 to v50:

	foreach v1 of varlist v4-v50 {
		foreach v2 of varlist v1 v2 v3 {
			tab `v2' if `v1'==.
		}
	}

It is not one line, but it is pretty quick and easy to do.

If you actually want the cases listed, rather than tabulated, just
substitute "list" for "tab" above.

If you want to list all three of the variables v1 v2 v3, then:

	foreach v1 of varlist v4-v50 {
		list v1 v2 v3 if `v1'==.
	}

--Nick Winter

-----------------------------------------------------------
 Nicholas Winter, Ph.D.                     P 202.939.5343
 Policy Studies Associates                  F 202.939.5732
 1718 Connecticut Avenue, NW     nwinter@policystudies.com
 Washington, DC 20009-1148           www.policystudies.com
----------------------------------------------------------- 

> -----Original Message-----
> From: Banya, Winston [mailto:w.banya@ic.ac.uk] 
> Sent: Monday, September 23, 2002 11:20 AM
> To: 'statalist@hsphsun2.harvard.edu'
> Subject: st: RE: RE: tabulation of variables
> 
> 
> Thanks Nick but I am not sure if I am getting it right. The 
> 'd' is among the
> variables just likje a b or c but a b and c do not have 
> missing values and
> in a way are unique. So imagine that my variables are 
> labelled 1-50 and 1-3
> do not have missing values, then starting with variable 4  to 
> variable 50 I
> want all the 1-3 that have missing values in variables 4 - 50 
> but one at at
> time in a single command. I want 1-3 listed for missing 
> values in 4, 5, 6
> etc one at a time.
> 
> Winston Banya
> 
> -----Original Message-----
> From: Nick Winter [mailto:nwinter@policystudies.com]
> Sent: 23 September 2002 16:12
> To: statalist@hsphsun2.harvard.edu
> Subject: st: RE: tabulation of variables
> 
> 
> Assuming you want to do this:
> 
> 	tabulate a if d==.
> 	tabulate b if d==.
> 	tabulate c if d==.
> 
> for each of many variables d, the following code wil do it for you:
> 
> 	foreach v1 of varlist <list of 'd' variables> {
> 		foreach v2 of varlist a b c {
> 			tab `v2' if `v1'==.
> 		}
> 	}
> 
> Nick Winter
> 
> > -----Original Message-----
> > From: Banya, Winston [mailto:w.banya@ic.ac.uk] 
> > Sent: Monday, September 23, 2002 11:06 AM
> > To: 'statalist@hsphsun2.harvard.edu'
> > Subject: st: tabulation of variables
> > 
> > 
> > Dear All,
> > 
> > I am working on a dataset with several variables ( more than 
> > 50) and I want
> > list missing values in terms of 3 variables. For example if 
> > variable d has
> > missing values, then I will want to list all the a, b or c 
> > for which d is
> > missing. I want to issue just one command to do that for me 
> > rather doing it
> > for one variable at a time. Can someone please show me how to do it?
> > 
> > 
> > Winston Banya
> > Care of The Elderly Section
> > Imperial College School of Medicine
> > Hamersmith Hospital Campus
> > Du Cane Road
> > London W12 0NN
> > 
> > Tel: (+44) 0208 383 4284
> > Fax: (+44) 0208 383 3378
> > Email: w.banya@ic.ac.uk
> > 
> > *
> > *   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/
> > 
> *
> *   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/
> *
> *   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/
> 
*
*   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