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]
Re: st: Combining two financial reports in the same calendar year
From
Austin Nichols <[email protected]>
To
[email protected]
Subject
Re: st: Combining two financial reports in the same calendar year
Date
Sun, 4 Jul 2010 09:39:53 -0400
Matthew Krauchunas <[email protected]> :
Depends on how, conceptually, they _should_ be combined. For totals.
you might multiply the first total by 91/366 and the second by
1-91/366 and add them together; this can be easily done by generating
a weight variable and then using -collapse-, or using -by- to replace
the last obs within id/yr combo with the weighted total.
On Sun, Jul 4, 2010 at 7:40 AM, Matthew Krauchunas
<[email protected]> wrote:
> Hello,
>
> I am working with California nursing home data and I have a number of
> nursing homes that have numerous financial reports in the same
> calendar year that I need to combine. For instance, nursing home ABC
> has one financial report covering period Jan 1, 2004 - Mar 31, 2004
> and another Apr 1, 2004 - Dec 31, 2004. Is there a way in Stata to
> combine these two "observations" into a single observation?
>
> Thank you,
> Matt
*
* 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/