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 on April 23, 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:48:32 -0400

Ok, answered my first problem by running the command:

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])

Any ideas for the second problem?

On Mon, Jul 5, 2010 at 11:42 AM, Matthew Krauchunas
<krauchunasms@mymail.vcu.edu> wrote:
> 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