Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: generating a new variable with the egen command

From   "Nick Cox" <>
To   <>
Subject   st: RE: generating a new variable with the egen command
Date   Mon, 28 Nov 2005 15:42:17 -0000

This is a FAQ. Look for material on precision
in the helps and FAQs. 

Your call should be 

egen double newvar = ...


egen long newvar = ... 

If these are integers, -long- is better. Either type 
is allowed by the syntax. See the help for -egen- once more. 


> I'm trying to generate a new variable given by the sum of an 
> existing variable 
> by year (as I have 2 six month observations for the same 
> year) and individual.
> The command is the following:
> egen newvar=sum (oldvar), by(id year)
> the problem is that the original values are, for instance: 
> 42224464 and 
> 67090781, but the sum that STATA computes is 109000000, 
> instead of 109315245. 
> Why does it round like that?
> The old variable is stored as "double", I have tried to 
> change the storage 
> type, using recast, but STATA does not allow to do it, as 
> many values would be 
> changed...

*   For searches and help try:

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