Statalist The Stata Listserver


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

Re: st: Data management


From   "Austin Nichols" <[email protected]>
To   [email protected]
Subject   Re: st: Data management
Date   Wed, 28 Feb 2007 17:41:03 -0500

Dear Suryadipta Roy--

clear
input str1 octy str1 dcty  dist  tshare
          a         b       10    0.13
          a         c       15    0.13
          a         d       25    0.13
          b         a       10    0.44
          b         c       30    0.44
          b         d       25    0.44
          c         a       15    0.22
          c         b       30    0.22
          c         d       5     0.22
          d         a       25    0.21
          d         b       25    0.21
          d         c       5     0.21
end
gen double other_tshare=.
qui levelsof octy, local(clist)
foreach i of local clist {
su tshare if octy=="`i'", meanonly
qui replace other_tshare=r(mean) if dcty=="`i'"
}
g dt=dist*other_tshare
egen x1=sum(dt), by(octy)
*Value x1=12.95 for octy=a given by the formula:
*tshare(b)*dist(a,b)+tshare(c)*dist(a,c)+tshare(d)*dist(a,d).
l, noo clean


On 2/28/07, Roy,Suryadipta <[email protected]> wrote:
I had posted a similar query sometime back and did not get
any response- so probably my question was not very clear.
Here I have modified the query and it would be extremely
helpful to get some help. The dataset is as follows:
*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index