Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Austin Nichols <austinnichols@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | Re: st: Combining two financial reports in the same calendar year |
| Date | Sun, 4 Jul 2010 09:39:53 -0400 |
Matthew Krauchunas <krauchunasms@mymail.vcu.edu> : 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 <krauchunasms@mymail.vcu.edu> 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/