[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: Constructing a variable: sum of a var over all j's (if j does not equal i)

 From "Martin Weiss" To Subject st: AW: Constructing a variable: sum of a var over all j's (if j does not equal i) Date Fri, 6 Nov 2009 14:01:53 +0100

```<>

http://www.stata.com/support/faqs/data/members.html

HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Sven P. Jost
Gesendet: Freitag, 6. November 2009 10:04
An: statalist@hsphsun2.harvard.edu
Betreff: st: Constructing a variable: sum of a var over all j's (if j does
not equal i)

Hello everybody,

I am currently experiencing a problem with the construction of a variable.

Please consider the following: There are multiple cars in a city i.
Further consider that the number of cars in city i depends on a
weighted measure as given on the right hand side below (whereas i does
not equal j)):

Cars in city i = ... + SUM of [ (Cars in city j / Cars in all cities)
x car dealers in city j ] over all j's.

Please note that there is a variable car_loc indicating that a car is
registered in a specific city.

We are now interested in constructed the variable on the right hand
side which, as far as I can tell, consists of three parts : (i) the
sum of all cars in cities j (ii) the sum of cars in all cities (iii)
and the sum of gas stations in cities j.

Thank you for all your help in advance.

Regards,
Sven

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

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

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