Statalist The Stata Listserver


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

st: RE: RE: How to get stacked column of means?


From   "White, Justin" <JWhite@yesvirginia.org>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: How to get stacked column of means?
Date   Mon, 26 Jun 2006 09:59:25 -0400

If you want to use the collapse command, you would have to write it like
this:
collapse (mean) q92as q92bs q92csq92ds q92esq92fsq92gs q92hsq92is q92js
q92ks

If you don't want to loose the original data set, try the egen command.
For example:

egen q92as = (mean) q92as


Hope this helps,


Justin White


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: Sunday, June 25, 2006 2:10 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: How to get stacked column of means?

The report "not working" is too vague to discuss. 

However, I can guess what went wrong from your
point of view. What you asked for is not what 
you want. 

Once you -collapse- once, you have lost your original 
dataset. As you want several means, only one -collapse- 
is needed, mentioning several variables. 

Nick 
n.j.cox@durham.ac.uk 

buddyb
 
> I'm running STATA 8.2
> 
> I am trying to get a stacked column of means for
> several variables (q92as q92bs q92cs q92ds q92es q92fs
> q92gs q92hs q92is q92js q92ks)
> 
> This is what I'm wrote, but it's not working...does
> anyone have any ideas?
> 
> Thanks
> 
> keep resp q92as q92bs q92cs q92ds q92es q92fs q92gs
> q92hs q92is q92js q92ks
> 
> drop resp
> 
> collapse (mean)  q92as 
> collapse (mean)  q92bs 
> collapse (mean)  q92cs
>  collapse (mean)  q92ds 
> collapse (mean)  q92es
>  collapse (mean)  q92fs
> collapse (mean)   q92gs 
> collapse (mean)  q92hs
>  collapse (mean)  q92is 
> collapse (mean)  q92js 
> collapse (mean)  q92ks
> 
> 
> 
> stack q92as q92bs q92cs q92ds q92es q92fs q92gs q92hs
> q92is q92js q92ks, into (Score)
> 
> Table Score

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