Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: AW: Combining two financial reports in the same calendar year


From   Matthew Krauchunas <krauchunasms@mymail.vcu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: AW: Combining two financial reports in the same calendar year
Date   Mon, 5 Jul 2010 11:42:37 -0400

Thank you everyone for responding, but now I have a new wrinkle.  Some
of the nursing homes changed ownership and that is the reason some of
them have multiple financial reports in a given year.  I do not want
to drop these observations as I need them later, but I want to exclude
them from my collapse commands.

I have used the following code suggested and I have found out the following:

(1)
sort  oshpd_fac_no year,stable
br oshpd_fac_no year facility_name if (oshpd_fac_no==
oshpd_fac_no[_n-1]| oshpd_fac_no==oshpd_fac_no[_n+1]) &
(year==year[_n-1]|year==year [_n+1])

- This returns 460 observations, but not all of them are for nursing
homes that have more than one financial period in a calendar year
(i.e., some facilities with only one financial report are included in
the list).

(2)
I manually cut and pasted one nursing home's two financial reports (in
a single calendar year) into another opened version of Stata.  I then
ran the following command:
collapse (rawsum)  snf_medcare_days -  total_op_rev (mean)
lic_bed_month_avg [aweight=  days_in_rep_period] , by( oshpd_fac_no
year)

- I have checked the results and it has worked correctly.

My problem now is how do I "keep" only the observations where the
names match and there are more than one financial report per calendar
year?  Second, how do I get the collapse results back into the master
data (i.e., how do I replace the 2 financial reports with my new
"collapse" results?)

Thank you,
Matt






On Sun, Jul 4, 2010 at 9:27 AM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>
> <>
>
> The point that Stata likes data to be in long form remains valid, though,
> and -tsset-ing when really you have panel data wastes a lot of useful
> information unnecessarily. So the fact that -reshape-ing is technically
> possible does not mean that Matthew is better off with the resulting
> dataset...
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Abhimanyu Arora
> Gesendet: Sonntag, 4. Juli 2010 15:23
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: st: AW: Combining two financial reports in the same calendar
> year
>
> Thanks to Martin Weiss, here is a simplified solution for you
>
>
> *************
> clear
> input var1 var2
> 1 5
> 1 3
> 2 6
> 2 4
> end
>
> bys var1:gen var3=_n
> reshape wide var2, i(var1) j(var3)
>
> list, noo
> *************
>
> On Sun, Jul 4, 2010 at 3:07 PM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>>
>> <>
>>
>> BTW, if you are enamoured of -tsset-, use its second syntax
>>
>> "tsset panelvar timevar [, options]"
>>
>> which is equivalent to -xtset-ting.
>>
>>
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Martin Weiss
>> Gesendet: Sonntag, 4. Juli 2010 14:39
>> An: statalist@hsphsun2.harvard.edu
>> Betreff: AW: st: AW: Combining two financial reports in the same calendar
>> year
>>
>>
>> <>
>>
>> Not a problem. Leave the data as "long", and -xtset- "generic":
>>
>>
>> *************
>> clear*
>> set obs 230
>> gen int nurshome=_n
>> expand 2
>> bys nurshome: gen byte observation=_n
>> xtset nurshome observation, generic
>> xtdes
>> *************
>>
>> Or if the reports are issued half-yearly, change the option to -xtset-
>> appropriately, to -halfyearly-.
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Matthew
>> Krauchunas
>> Gesendet: Sonntag, 4. Juli 2010 14:30
>> An: statalist@hsphsun2.harvard.edu
>> Betreff: Re: st: AW: Combining two financial reports in the same calendar
>> year
>>
>> It is indeed panel data, but it will not let me xtset the data by year
>> because I have 230 nursing homes that have 2 financial reports in a
>> given calendar year.  Thus, my challenge is to combine these financial
>> reports into 1 observation which is the crux of my problem.
>>
>> Thanks,
>> Matt
>>
>> On Sun, Jul 4, 2010 at 8:18 AM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>>>
>>> <>
>>>
>>> This sounds like a textbook description of panel data to me, which you
>>> should -xtset-.
>>>
>>>
>>>
>>> HTH
>>> Martin
>>>
>>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: owner-statalist@hsphsun2.harvard.edu
>>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Matthew
>>> Krauchunas
>>> Gesendet: Sonntag, 4. Juli 2010 14:10
>>> An: statalist@hsphsun2.harvard.edu
>>> Betreff: Re: st: AW: Combining two financial reports in the same calendar
>>> year
>>>
>>> Hi,
>>>
>>> Thank you for your quick reply.  No, I need it to stay in long format.
>>>  I have about 200 nursing homes that have more than one financial
>>> report for a given calendar year.  These are all in the same file.  I
>>> need to combine these into one
>>> observation or I cannot tsset the data.
>>>
>>> Thanks,
>>> Matt
>>>
>>> On Sun, Jul 4, 2010 at 7:58 AM, Martin Weiss <martin.weiss1@gmx.de>
> wrote:
>>>>
>>>> <>
>>>>
>>>> Look at
>>>>
>>>> *************
>>>> help reshape_example
>>>> *************
>>>>
>>>> to see the two formats available to you. Stata likes long format better,
>>> but
>>>> it also depends on what you want to do with the data down the road.
>>>>
>>>> Where do these observations reside? If in different files, you could
>>>> -merge-.
>>>>
>>>>
>>>> HTH
>>>> Martin
>>>>
>>>> -----Ursprüngliche Nachricht-----
>>>> Von: owner-statalist@hsphsun2.harvard.edu
>>>> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Matthew
>>>> Krauchunas
>>>> Gesendet: Sonntag, 4. Juli 2010 13:40
>>>> An: statalist@hsphsun2.harvard.edu
>>>> Betreff: st: Combining two financial reports in the same calendar year
>>>>
>>>> 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/
>>>>
>>>>
>>>> *
>>>> *   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/
>>>>
>>>
>>> *
>>> *   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/
>>>
>>>
>>> *
>>> *   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/
>>>
>>
>> *
>> *   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/
>>
>>
>> *
>> *   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/
>>
>>
>> *
>> *   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/
>>
>
> *
> *   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/
>
>
> *
> *   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/
>

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


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index