[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Banya, Winston" <w.banya@ic.ac.uk> |

To |
"'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |

Subject |
st: RE: RE: RE: RE: tabulation of variables |

Date |
Mon, 23 Sep 2002 16:43:03 +0100 |

Thanks Nick. It seems to work but some of the variables are not numeric and so when I took that into account I am geeting an error message. I wrote in the last line you sent me: list 'v2' if 'v1'==. | 'v1'=="&" and then the error message was that 'v1'is an invalid name. Note the in this database the missinbg value for a string variable is designarted as &. How can I modify it ? Winston -----Original Message----- From: Nick Winter [mailto:nwinter@policystudies.com] Sent: 23 September 2002 16:23 To: statalist@hsphsun2.harvard.edu Subject: st: RE: RE: RE: tabulation of variables 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/ * * 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/

**Follow-Ups**:**st: RE: RE: RE: RE: RE: tabulation of variables***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**st: RE: RE: RE: tabulation of variables** - Next by Date:
**st: RE: RE: RE: RE: RE: tabulation of variables** - Previous by thread:
**st: RE: RE: RE: tabulation of variables** - Next by thread:
**st: RE: RE: RE: RE: RE: tabulation of variables** - Index(es):

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