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
Abhimanyu Arora <[email protected]>
To
[email protected]
Subject
Re: st: AW: Combining two financial reports in the same calendar year
Date
Sun, 4 Jul 2010 15:23:22 +0200
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/