Statalist


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

Re: st: AW: combining frequency tables


From   Shehzad Ali <sia500@york.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: combining frequency tables
Date   23 Feb 2009 15:46:21 +0000

Thanks, Martin, but -estpost- doesn't allow me to use -mdesc- and -nmissing- as subcommands, perhaps because these are user written programmes. Also -estpost- only allows use of -by- as an option and not at the start of the command which means I can use only one variable with -by-.

I don't mind using Stata's built-in commands if it can tabulate missing values for me.

Any thoughts?

Thank you,

Shehzad
On Feb 23 2009, Martin Weiss wrote:


<>


*************
help estpost,marker(tabulate)
*************



HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Shehzad Ali
Gesendet: Montag, 23. Februar 2009 16:17
An: statalist@hsphsun2.harvard.edu
Betreff: st: combining frequency tables

Hi listers,

Another (perhaps) simple question: is it possible to add different frequency 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 be for treatment A at time point 1. I want to know the number of missing values for each use variable for each treatment group and each time point. Also for each use variable there are 'if' conditions, so I can't do the frequency count in one go. Here is what I am doing using a user written programme -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 treatment groups to get a single table that I can export to Excel. Is there any way I could do that?

Thank you,

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


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



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