Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: TSCS: Subtracting values
From
"DeMichele, Matthew" <[email protected]>
To
<[email protected]>
Subject
st: TSCS: Subtracting values
Date
Mon, 18 Nov 2013 11:18:44 -0500
Dear Stata list:
I have a pooled dataset arranged by state and year. I am trying to
generate a variable from two existing variables, but I am having trouble
figuring out what to tell Stata.
Here is a snapshot of what the data look like. I want to generate a
variable identifying the difference for each state between the end of
year population (totend) and the beginning (totbeg) of the next year's
population. For instance, the difference in the totend in 2005 and
totbeg 2006 for state 1 and state 2. In the case of state 1, this would
be difference 54369-55175 = -806. These are populations for = December
31 and January 1 in which the total should be pretty close. But, I need
to do this for all 50 states over 30 years. Any suggestions?
stateid year totbeg totend
1 2005 53865 55175
1 2006 54369 55806
1 2007 55018 53230
1 2008 52187 50418
2 2005 3841 4115
2 2006 4115 4477
2 2007 4477 4596
2 2008 4596 4662
Matthew
*
* 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/