Re: [SPAM] Re: st: sum the variable based on other variables

[wanhaiyou <wanhaiyou@hnu.edu.cn>]

Nick,thanks very much.
In fact, I only need the mean. 
I attemp to save these value as a matrix.However,when the number of variable large,e.g.,100,
the method is unfeasible.
The following codes 
**
clear
input v1 v2 v3
1 1 0
0 0 1
1 0 1
1 1 1
0 1 0
1 1 1
end

forv i=1/3 {
  forv j=1/3 {
  if `i'~=`j' {
    sum  c`i' if c`i'==c`j', meanonly
	mat b=(nullmat(b)\r(mean))
}
}
}

How could I save those value (r(mean) from "sum"
as a column?


Bests,
wanhaiyou
Hunan University


> -----原始邮件-----
> 发件人: "Nick Cox" <njcoxstata@gmail.com>
> 发送时间: 2014-03-25 17:01:06 (星期二)
> 收件人: "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
> 抄送: 
> 主题: [SPAM] Re: st: sum the variable based on other variables
> 
> You are using -egen- to create variables, each of which just holds a
> constant. That is not necessary. The sum is left in memory as r(sum)
> after -summarize-.
> 
> I don't know what you want to do with your millions of sums, so this
> code is only a start.
> 
> forv i=1/3 {
>   forv j=1/3 {
>   if `i'~=`j' {
>     sum  v`i' if v`i'==v`j', meanonly
>     di r(sum)
> }
> }
> }
> 
> Nick
> njcoxstata@gmail.com
> 
> On 25 March 2014 04:19, wanhaiyou <wanhaiyou@hnu.edu.cn> wrote:
> 
> > I want to creat the sum of one variable based on other variables.For example,
> > I have the following dataset
> > v1 v2 v3
> > 1 1 0
> > 0 0 1
> > 1 0 1
> > 1 1 1
> > 0 1 1
> > 0 1 0
> >
> > If v1=v2, then sum the corresponding value of v1
> > v1 v2
> > 1 1   equal
> > 0 0   equal
> > 1 0   not equal
> > 1 1   equal
> > 0 1   not equal
> > 0 1   not equal
> > if v1=v3, then sum the corresponding value of v1
> > ....
> >
> > if v3==v1,then sum the corresponding value of v3
> > if v3=v2,then sum the corresponging value of v3
> >
> > I have written the following codes
> >
> > forv i=1/3 {
> >   forv j=1/3 {
> >   if `i'~=`j' {
> >   egen vsum`i'`j'=total(v`i') if v`i'==v`j'
> > }
> > }
> > }
> >
> > However, I have 5000 variables but the max number of variables is 32,767.
> > Therefore, this codes cannot be used.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/


--
Bests,

wanhaiyou

Hunan University


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