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: AW: Combining two financial reports in the same calendar year
From
Matthew Krauchunas <[email protected]>
To
[email protected]
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 <[email protected]> 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: [email protected]
> [mailto:[email protected]] Im Auftrag von Abhimanyu Arora
> Gesendet: Sonntag, 4. Juli 2010 15:23
> An: [email protected]
> 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 <[email protected]> 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: [email protected]
>> [mailto:[email protected]] Im Auftrag von Martin Weiss
>> Gesendet: Sonntag, 4. Juli 2010 14:39
>> An: [email protected]
>> 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: [email protected]
>> [mailto:[email protected]] Im Auftrag von Matthew
>> Krauchunas
>> Gesendet: Sonntag, 4. Juli 2010 14:30
>> An: [email protected]
>> 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 <[email protected]> wrote:
>>>
>>> <>
>>>
>>> This sounds like a textbook description of panel data to me, which you
>>> should -xtset-.
>>>
>>>
>>>
>>> HTH
>>> Martin
>>>
>>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: [email protected]
>>> [mailto:[email protected]] Im Auftrag von Matthew
>>> Krauchunas
>>> Gesendet: Sonntag, 4. Juli 2010 14:10
>>> An: [email protected]
>>> 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 <[email protected]>
> 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: [email protected]
>>>> [mailto:[email protected]] Im Auftrag von Matthew
>>>> Krauchunas
>>>> Gesendet: Sonntag, 4. Juli 2010 13:40
>>>> An: [email protected]
>>>> 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/