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 08:34:06 -0400

I am sorry, I meant to use xtset instead of tsset because it is indeed
panel data.  Thank you all for your help!

On Sun, Jul 4, 2010 at 9:07 AM, 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/


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