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/