OK, so #2 depends on what you wish to do with the data outside Stata, which was not clear.
#1 is indeed puzzling if the variables you were using in the -reshape- are precisely those you used in the -tsset-. But Stata is telling which panels it believes to be problematic, so have a look.
Nick
[email protected]
max r
What is puzzling me is that I am able to tsset the data and run xt
commands, which means that there could not be any repeated time
periods within panels, no?
Second, I converting the data into wide format to be used for
processing in a GIS software. So of all the variables I keeping the
panel and time identifiers along with a couple of other variables from
the larger dataset and trying to convert the small set into wide
format.
On Mon, Apr 13, 2009 at 10:32 AM, Nick Cox <[email protected]> wrote:
> Stata is giving a clear signal of the problem. Precisely which part of what it says is unclear to you?
>
> In any case why do you think that panel "stuff" requires a wide structure?
>
> Nick
> [email protected]
>
> max r
>
> I am working a subset of my dataset,
> the data has around 1600 households, and 110 months for each. I am
> able to run my xtregs and do other panel stuff. Now i am trying to
> reshape the data from the long-format into wide-format. I used
> "reshape wide r, i(panelid) j(timevar)" . Following is the response
> from STATA.
>
> . reshape wide r, i(panelid) j(timevar)
> (note: j = 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460
>> 461 462 463 464 465 466 467 468 469 470 471 472 473 474 476 477 478 479 480 4
>> 81 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 50
>> 0 501 504 505 506 507 508 509 510 511 514 515 516 517 518 519 520 521 522 523
>> 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542
>> 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558)
> timevar not unique within panel_id;
> there are multiple observations at the same timevar within panel_id.
> Type "reshape error" for a listing of the problem observations.
> r(9);
*
* 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/
