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

st: RE: custom table of summary stats

From   "David Harrison" <>
To   <>
Subject   st: RE: custom table of summary stats
Date   Mon, 14 Feb 2005 14:05:42 -0000

You can do a reasonable job of this using -table- (and a bit of looping).

I will presume that each observation represents a single study, with a variable called study containing some kind of study id and a variable n for the number of subjects.

qui count if !missing(study)
qui gen pcstudy=1/r(N) if !missing(study)
foreach v of varlist age ses {
	su n if !missing(`v'), meanonly
	qui gen pcn=n/r(sum) if !missing(`v')
	table `v', c(count study sum pcstudy sum n sum pcn)
	qui drop pcn


-----Original Message-----
From: Garrard, Wendy M. []
Sent: 11 February 2005 20:43
Subject: st: custom table of summary stats

Hello Statalist,
I need a rather simple table of summary stats, but having trouble identifying which of the many Stata commands (tabstat, tab, tabi, tab1, etc.) will do what I need.  Please, someone point me in the right direction.
The data is for meta-analysis. I am trying to output descriptives for several categorical variables, and the summary statistics per category reflect the count of studies, % of total studies, sum of sample n's, and % of total sample N that contribute to each category.  The % of subjects is the element that is making this tricky. There are many categorical variables, so I want to avoid doing this as a piecemeal caclulation.
Categ. Var.     Study(n)   Study(%)   Subj.(n)   Subj.(%)
                (N=100)               (N=1,000)
   Child          50        .50          400       .40
   Teen           50        .50          600       .60
Family SES   
   Low            35        .35          400       .40
   Middle         55        .65          480       .48
   High           10        .10          120       .12
Thanks very much,

*   For searches and help try:

*   For searches and help try:

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