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]

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   AW: st: AW: Combining two financial reports in the same calendar year
Date   Sun, 4 Jul 2010 15:07:16 +0200

<> 

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/


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