[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Shehzad Ali <sia500@york.ac.uk> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: combining frequency tables |

Date |
24 Feb 2009 19:43:18 +0000 |

I think I will do this in Excel. Cheers, Shehzad On Feb 23 2009, Nick Cox wrote:

As I've said before, there's no virtue in simple questions. We want_interesting_ questions!This seems to be a question about Excel to the extent that it raises another question: Can't you do that in Excel if that's a tool of choice?(No idea from me.)But there are also many Stata answers. -findit mdesc- reveals that it is a program by Rose Anne Medeiros, who once wrote a program called -njc-, for which I am not responsible. Here is a matrix version of her program,for which she is not responsible.*! mmdesc 1.0 NJC 23 February 2009* mdesc 1.0 RAM 18 JULY 2008* Returns a table with number missing, total, and missing/total program mmdesc, rclass byable(recall)version 8syntax [varlist] [if] [in]tempvar touse mark `touse' `if' `in'local nvars : word count `varlist'tempname matrixmatrix `matrix' = J(`nvars', 3, .)local i = 1quietly foreach var of local varlist {count if missing(`var') & `touse'matrix `matrix'[`i', 1] = r(N)count if `touse'matrix `matrix'[`i', 2] = r(N)matrix `matrix'[`i', 3] = `matrix'[`i',1] / `matrix'[`i',2]local ++i}matrix rownames `matrix' = `varlist'matrix colnames `matrix' = Missing Total Missing/Totalmatrix list `matrix', noheaderreturn matrix table = `matrix'endOnce you run this, you can save its results by e.g.mat A = r(table)...mat B = r(table)...mat C = A + BNickn.j.cox@durham.ac.ukShehzad AliAnother (perhaps) simple question: is it possible to add differentfrequency tables together to form a combined single table in Excel?I have two group variables (say, var1: type of treatment; and var2: time point of observation) and 5 use variables. So an observation would befortreatment A at time point 1. I want to know the number of missing valuesfor each use variable for each treatment group and each time point. Alsofor each use variable there are 'if' conditions, so I can't do thefrequency count in one go. Here is what I am doing using a user writtenprogramme -mdesc- or -missing-:by treatment timpoint: mdesc use1 if (condition1 condition2) by treatment timpoint: mdesc use2 if (condition3 condition4)and so on.Now I want to combine all these counts for all timepoints and treatmentgroups to get a single table that I can export to Excel. Is there anyway Icould do that?* * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

* * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**RE: st: RE: combining frequency tables***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**References**:**st: combining frequency tables***From:*Shehzad Ali <sia500@york.ac.uk>

**st: RE: combining frequency tables***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**Re: st: question about histograms** - Next by Date:
**st: RE: xtmelogit post-estimation** - Previous by thread:
**RE: st: RE: combining frequency tables** - Next by thread:
**RE: st: RE: combining frequency tables** - Index(es):

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