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]
AW: st: AW: Combining two financial reports in the same calendar year
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
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: [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/