# Re: st: RE: summation

 From "Dominic Muston" To , Subject Re: st: RE: summation Date Mon, 12 Dec 2005 09:25:38 +0000

```Can this problem be simplified with a standard summation formula?

The sum from 1 to n in steps of 1 is 0.5 x n x (n+1).

Your problem appears like it might be a summation from 10*(min-1) to
10*(max-1) in steps of 10, which I think would have a formula of:

5 x ((max-1) * max - (min - 2) * (min - 1))

eg min = 2, max = 20 => sum = 5 x ( 19 x 20 - 0 x 1 ) = 1900.

The method doesn't work with your other example as I see that you have
treated missing as zero. As you can see, the formula ignores all your
data other than min and max, so if these are important, then the formula
might not work for you.

A. Mushfiq Mobarak, Assistant Professor of Economics

> I post a part of my dataset below.  I would like to sum the variable
> "length" from n=min to n=max for each state, where n, min and
> max are 3
> different variables.  I'm using Stata8SE.
>
> So, for example, for state=1, the answer I'm looking for would be:
>
> summation (n going from 2 to 20) of "length', which equals
> 10+20+30+....+190 = 1900
>
> For state=3, the answer would be summation (n going from 6 to 16) of
> length = 50+60+.+150 = 1100
>
> For state=2, I would just get "." (missing)
>
> This is a very large dataset, which is why I need to automate the
> summing procedure. I apologize in advance if the answer is obvious.
I
> will be grateful for any help or suggestions.  I subscribe to
> the digest
> version, so copying the response to mobarak@colorado.edu
> all" rather than "reply" may also work) will help me get your
response
> quicker.
>
> group	n	min	max	state	length
> 3	2	2	20	1	10
> 3	3	.	.	2	20
> 3	4	2	20	1	30
> 3	5	2	20	1	40
> 3	6	6	16	3	50
> 3	7	2	20	1	60
> 3	8	6	16	3	70
> 3	9	2	20	1	80
> 3	10	6	16	3	90
> 3	11	2	20	1	100
> 3	12	6	16	3	110
> 3	13	2	20	1	120
> 3	14	6	16	3	130
> 3	15	2	20	1	140
> 3	16	6	16	3	150
> 3	17	17	25	4	160
> 3	18	2	20	1	170
> 3	19	17	25	4	180
> 3	20	2	20	1	190
> 3	21	17	25	4	200
> 3	22	22	28	5	210
> 3	23	17	25	6	220
> 3	24	22	28	5	230
> 3	25	17	25	6	240
> 3	26	22	28	5	250
> 3	27	.	.	7	260
> 3	28	22	28	5	270

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

------------------------------

Date: Fri, 9 Dec 2005 13:13:40 -0000
From: "Nick Cox" <n.j.cox@durham.ac.uk>
Subject: st: RE: [question about testing for normality]

Nothing in this question looks unique to econometrics.

It all depends what you want to do with
the distributions in question, which you do not say.

Otherwise my advice is that given earlier
this week to a questioner about -sktest-.

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

Isabel Vargas

> I am working with cross-section data, and I use swilk
> sfrancia and iqr and I
> found that it reject normality, it is serious? If it is, what
> can I do?

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

------------------------------

Date: Fri, 09 Dec 2005 12:25:04 -0200
From: Fernando Augusto Proietti <proietti@medicina.ufmg.br>
Subject: st: How ?

This is a multi-part message in MIME format.
- --------------239F3F5331B035C3ECDE8CA1
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Dear all,

I have a data set , from a population based study, including 20,000
participants.

These 20,000 participants are nested in about 5,000 families.
All family members (living in the same house)  are included in the
study. I want to create a new variable, income per capita.

The data looks like that:

ID                Income (monthly)

9001             0,0000
9001             5,0000
9001             8,0000

9003             5,0000
9003             6,0000
9003             0,0000
9003             2,0000

The 9001 are member (3) of the same family, as well as the 9003 (4
members) and so on.

- --------------239F3F5331B035C3ECDE8CA1
Content-Type: text/x-vcard; charset=us-ascii;
name="proietti.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Fernando Augusto Proietti
Content-Disposition: attachment;
filename="proietti.vcf"

begin:vcard
n:Proietti;Fernando
tel;fax:55-31-3248-9675
tel;work:55-31-3248-9949 / 3248-9102
x-mozilla-html:FALSE
org:Dep de Medicina Preventiva e Social - UFMG
version:2.1
email;internet:proietti@medicina.ufmg.br
Alfredo Balena, 190;Belo Horizonte;Minas Gerais;30130-100;Brasil
x-mozilla-cpt:;17392
fn:Fernando  Proietti
end:vcard

- --------------239F3F5331B035C3ECDE8CA1--

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

------------------------------

Date: Fri, 9 Dec 2005 15:27:20 +0100
From: "Maarten Buis" <M.Buis@fsw.vu.nl>
Subject: st: RE: How ?

Fernando:

Here is an example of how you could achieve what you want:

*----------------example-------------
sysuse auto, clear
sort rep78
by rep78: egen mean = mean(price)
list mean
*--------------end example----------------

HTH,
Maarten

- -----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands

Buitenveldertselaan 3 (Metropolitan), room Z214

+31 20 5986715

http://home.fsw.vu.nl/m.buis/
- -----------------------------------------

- -----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Fernando
Augusto Proietti
Sent: vrijdag 9 december 2005 15:25
To: statalist@hsphsun2.harvard.edu
Subject: st: How ?

Dear all,

I have a data set , from a population based study, including 20,000
participants.

These 20,000 participants are nested in about 5,000 families.
All family members (living in the same house)  are included in the
study. I want to create a new variable, income per capita.

The data looks like that:

ID                Income (monthly)

9001             0,0000
9001             5,0000
9001             8,0000

9003             5,0000
9003             6,0000
9003             0,0000
9003             2,0000

The 9001 are member (3) of the same family, as well as the 9003 (4
members) and so on.

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

------------------------------

Date: Fri, 9 Dec 2005 14:41:53 -0000
From: "Roger Newson" <roger.newson@kcl.ac.uk>
Subject: st: New version of -rbn1mono- scheme on SSC

Hello All

Thanks to Kit Baum, a new version of the -rbn1mono- scheme is now
available
for download from SSC. In Stata, use the -ssc- command to do this,
typing

ssc desc scheme_rbn1mono

for a description, and

ssc install scheme_rbn1mono, replace

to install.

The -rbn1mono- package is described as below on my website. In the new
version, I have reshuffled the preferences amongst the shades of gray
to use
for shaded bars and areas, so -rbn1mono- now prefers white bars as
first
choice, then medium gray, then light gray, then dark gray. -rbn1mono-
is
therefore now a bit more minimal and photocopier-friendly than it was,
but
it is still a bit less minimal and photocopier-friendly than Svend
Juul's -lean- schemes.

Best wishes

Roger

-
----------------------------------------------------------------------------
package rbn1mono from http://www.kcl-phs.org.uk/rogernewson/stata9
-
----------------------------------------------------------------------------

TITLE
rbn1mono: A minimal monochrome graphics scheme

DESCRIPTION/AUTHOR(S)
rbn1mono is Roger Newson's personal default scheme. It specifies
a
minimal and photocopier-friendly black-and-white look, with gray
background lines and minimal gray shading.  It is slightly more
minimal and photocopier-friendly than s1mono (which is its
mother
scheme), and slightly less minimal and photocopier-friendly than
latest
form using the findit command).

Author: Roger Newson
Distribution-date: 08 December 2005
Stata-version: 9

install)
scheme-rbn1mono.scheme
scheme_rbn1mono.hlp
-
----------------------------------------------------------------------------

- --
Roger Newson
Lecturer in Medical Statistics
Department of Public Health Sciences
Division of Asthma, Allergy and Lung Biology
King's College London

5th Floor, Capital House
42 Weston Street
London SE1 3QD
United Kingdom

Tel: 020 7848 6648 International +44 20 7848 6648
Fax: 020 7848 6620 International +44 20 7848 6620
or 020 7848 6605 International +44 20 7848 6605
Email: roger.newson@kcl.ac.uk
Website: http://phs.kcl.ac.uk/rogernewson/

Opinions expressed are those of the author, not the institution.

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

------------------------------

Date: Fri, 9 Dec 2005 09:44:07 -0500
From: "David Roodman \(DRoodman@cgdev.org\)" <DRoodman@CGDEV.ORG>
Subject: st: new, memory-conserving xtabond2

The main comment I got on the new, Mata-based version of xtabond2 (see
http://www.stata.com/statalist/archive/2005-11/msg00717.html) is that
it
uses a lot of memory.

So I have just put up a new version that can operate in a space-saving
mode. Its behavior is controlled by the Mata system parameter
"matafavor". For example, typing the below at the *Stata* (not Mata)
prompt:
mata: mata set matafavor speed
xtabond2 ....
will run a command in speed-optimized mode.

Whereas:
mata: mata set matafavor space
xtabond2 ....
should use much less memory, at a modest cost in speed. (The
difference
is that in this mode, xtabond2 does not build the entire matrix of
"GMM-style" instruments, but only builds the rows for each individual
as
needed.)

See "help mata_set" for information about mainpulating the matafavor
parameter. Type "ssc install xtabond2, replace" to get the new
version.

All of this is relevant for Stata 9 only. Please let me know of any
problems.

- --David Roodman
Center for Global Development

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

------------------------------

Date: Fri, 9 Dec 2005 10:06:21 -0500
From: "Kallimanis, Bellinda" <bkallimanis@fmhi.usf.edu>
Subject: st: Generating unique admission id

Hi Everyone,

I have a data manipulation question. I have a large data set (panel
format) and I am trying to calculate length of stay for each
individual.
The thing is many individuals come in (adm asses) and stay then leave
(disch) then come back. But to complicate it more, some people leave
with anticipated return (dis_ret) then come back (reentry) and some
people are admitted and have follow up but have not been discharged.
What I would

Dominic Muston
Cancer Screening Evaluation Unit
Institute of Cancer Research
Sutton, UK
Tel: +44 (0)20 7352 8133 x 4544
www.icr.ac.uk/cseu

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