Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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:27:54 +0200 |

<> 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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Abhimanyu Arora Gesendet: Sonntag, 4. Juli 2010 15:23 An: statalist@hsphsun2.harvard.edu 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 <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/ * * 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/

**References**:**st: Combining two financial reports in the same calendar year***From:*Matthew Krauchunas <krauchunasms@mymail.vcu.edu>

**Re: st: AW: Combining two financial reports in the same calendar year***From:*Matthew Krauchunas <krauchunasms@mymail.vcu.edu>

**Re: st: AW: Combining two financial reports in the same calendar year***From:*Matthew Krauchunas <krauchunasms@mymail.vcu.edu>

**Re: st: AW: Combining two financial reports in the same calendar year***From:*Abhimanyu Arora <abhimanyu.arora1987@gmail.com>

- Prev by Date:
**AW: st: AW: Combining two financial reports in the same calendar year** - Next by Date:
**Re: st: AW: Combining two financial reports in the same calendar year** - Previous by thread:
**Re: st: AW: Combining two financial reports in the same calendar year** - Next by thread:
**Re: st: AW: Combining two financial reports in the same calendar year** - Index(es):