I have a quick question on how I could reshape my below data into the "long" format? The variables E, F, G, H and I are the County IDs in my Panel.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int date double(E F G H I) 600 333.04 333.04 333.04 333.04 333.04 601 412.06 412.06 412.06 412.06 622.91 602 527.27 527.27 527.27 527.27 653.24 603 364.2 364.2 364.2 364.2 364.2 604 404.8 404.8 404.8 404.8 404.8 605 361.3 361.3 361.3 361.3 361.3 606 395.43 395.43 395.43 395.43 395.43 607 342.06 342.06 342.06 342.06 342.06 608 385.64 385.64 385.64 385.64 385.64 609 392.36 392.36 392.36 392.36 392.36 610 397.14 397.14 397.14 397.14 397.14 611 682.65 682.65 682.65 682.65 759.36 612 683.52 683.52 683.52 683.52 703.9300000000001 613 492.74 492.74 492.74 492.74 492.74 614 518.09 518.09 518.09 518.09 518.08 615 489.88 489.88 489.88 489.88 489.88 616 434.65000000000003 434.65000000000003 434.65000000000003 434.65000000000003 433.95 617 418.41 418.41 418.41 418.41 418.41 618 231.57 231.57 231.57 231.57 306.27 619 270.36 270.36 270.36 270.36 268.85 620 337.47 337.47 337.47 337.47 337.47 621 29.400000000000002 29.400000000000002 29.400000000000002 29.400000000000002 65.01 622 306.18 306.18 306.18 306.18 302.53000000000003 623 276.5 276.5 276.5 276.5 276.5 624 257.36 257.36 257.36 257.36 256.73 625 573.37 573.37 573.37 573.37 608.27 626 245.16 245.16 245.16 245.16 245.16 627 206.15 206.15 206.15 206.15 205.57 628 175.82 175.82 175.82 175.82 175.82 629 187.36 187.36 187.36 187.36 187.36 630 139.22 139.22 139.22 139.22 177.68 631 71.73 71.73 71.73 71.73 71.73 632 157.89000000000001 157.89000000000001 157.89000000000001 157.89000000000001 159.75 633 215.52 215.52 215.52 215.52 216.5 634 256.14 256.14 256.14 256.14 256.14 635 307.45 307.45 307.45 307.45 306.6 636 242.31 242.31 242.31 242.31 241.42000000000002 637 288.35 288.35 288.35 288.35 288.35 638 305.06 305.06 305.06 305.06 305.06 639 385.28000000000003 385.28000000000003 385.28000000000003 385.28000000000003 358.64 640 327.13 327.13 327.13 327.13 327.13 641 268.66 268.66 268.66 268.66 268.86 642 250.11 250.11 250.11 250.11 250.18 643 273.69 273.69 273.69 273.69 275.52 644 262.26 262.26 262.26 262.26 262.87 645 309.37 309.37 309.37 309.37 309.37 646 276.71 276.71 276.71 276.71 276.71 647 302.47 302.47 302.47 302.47 303.14 648 239.79 239.79 239.79 239.79 239.79 649 272.9 272.9 272.9 272.9 273.1 650 232.67000000000002 232.67000000000002 232.67000000000002 232.67000000000002 272.9 651 223.86 223.86 223.86 223.86 223.86 652 176.94 176.94 176.94 176.94 176.94 653 137.70000000000002 137.70000000000002 137.70000000000002 137.70000000000002 138.29 654 213.1 213.1 213.1 213.1 213.1 655 249.92000000000002 249.92000000000002 249.92000000000002 249.92000000000002 249.92000000000002 656 260.38 260.38 260.38 260.38 260.38 657 270.58 270.58 270.58 270.58 270.58 658 169.06 169.06 169.06 169.06 154.70000000000002 659 278.46 278.46 278.46 278.46 278.35 660 245.34 245.34 245.34 245.34 246.47 661 283.28000000000003 283.28000000000003 283.28000000000003 283.28000000000003 283.52 662 216.16 216.16 216.16 216.16 216.16 663 211.15 211.15 211.15 211.15 216.14000000000001 664 207.72 207.72 207.72 207.72 207.72 665 161.24 161.24 161.24 161.24 161.51 666 122.2 122.2 122.2 122.2 122.2 667 83.82000000000001 83.82000000000001 83.82000000000001 83.82000000000001 84.03 668 94.45 94.45 94.45 94.45 94.45 669 123.16 123.16 123.16 123.16 123.16 670 237.88 237.88 237.88 237.88 237.85 671 217.8 217.8 217.8 217.8 220.79 672 159.46 159.46 159.46 159.46 159.46 673 175.14000000000001 175.14000000000001 175.14000000000001 175.14000000000001 175.54 674 186.65 186.65 186.65 186.65 189.6 675 207.42000000000002 207.42000000000002 207.42000000000002 207.42000000000002 207.42000000000002 676 230.17000000000002 230.17000000000002 230.17000000000002 230.17000000000002 230.57 677 212.12 212.12 212.12 212.12 212.12 678 213.05 213.05 213.05 213.05 213.05 679 206.81 206.81 206.81 206.81 227.05 680 175.21 175.21 175.21 175.21 213.71 681 229.38 229.38 229.38 229.38 265.86 682 325.1 325.1 325.1 325.1 335.76 683 310.34000000000003 310.34000000000003 310.34000000000003 310.34000000000003 327.21 684 281.52 281.52 281.52 281.52 303.63 685 269.34000000000003 269.34000000000003 269.34000000000003 269.34000000000003 272.52 686 277.61 277.61 277.61 277.61 277.84000000000003 687 265.98 265.98 265.98 265.98 267.48 688 268.94 268.94 268.94 268.94 267.08 689 244.89000000000001 244.89000000000001 244.89000000000001 244.89000000000001 244.89000000000001 690 230.22 230.22 230.22 230.22 230.1 691 254.33 254.33 254.33 254.33 254.67000000000002 692 294.01 294.01 294.01 294.01 307.33 693 240.13 240.13 240.13 240.13 239.73000000000002 694 272.27 272.27 272.27 272.27 272.27 695 387.19 387.19 387.19 387.19 387.19 end format %tm date
Alex
0 Response to Panel Data reshape
Post a Comment