I have a survey data as presented below
and A panel data with the id representing the company index in the survey.
The id in the panel data is same as comp in the survey. I want to merge the survey value into the Panel data repeating the same value of the survey for the Panel data across time for each cross sectional unit.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float(comp compete_supch demand_mang order_fulf customer inventory_man tech_auto employee_attr organiz_perf) byte _est__mc_model float(operation_eff operation_effi operation_efficiency) 1 4 3 4 4 4 4 4 4 1 4 4 4 2 4 4 3 4 4 4 3 4 1 3.666667 3.666667 4 3 4 4 4 4 4 4 3 3 1 3.666667 3.666667 4 4 3 3 4 4 4 3 2 3 1 3 3 3 5 2 2 2 2 2 2 2 2 1 2 2 2 6 3 4 3 4 3 4 4 3 1 3.666667 3.666667 4 7 4 4 4 4 4 4 4 5 1 4.6666665 4 4 8 3 4 4 4 3 2 4 4 1 3 3 3 9 4 4 4 4 4 4 4 3 1 4 4 4 10 4 4 3 4 4 4 4 3 1 4 4 4 11 3 4 3 4 4 4 4 5 1 4 4 4 12 4 4 4 4 4 4 4 4 1 4 4 4 13 4 4 4 4 4 4 3 3 1 3.666667 3.666667 4 14 4 4 4 4 4 4 4 3 1 4.3333335 4 4 15 4 4 4 4 4 4 4 4 1 4 4 4 16 4 2 4 2 2 2 2 2 1 2 2 2 17 4 4 4 3 2 2 3 3 1 1.6666666 2.3333333 2 18 4 4 3 3 3 4 3 4 1 3.333333 3.333333 3 19 3 4 4 4 4 4 4 3 1 4 4 4 20 4 4 4 4 4 4 4 3 1 5 4 4 21 3 4 4 3 4 4 4 3 1 4 4 4 22 4 4 4 4 4 4 4 3 1 4 4 4 23 4 4 4 4 4 4 4 4 1 4.3333335 4 4 24 4 4 4 4 4 4 4 4 1 4.3333335 4 4 25 4 4 4 4 4 4 4 3 1 4.3333335 4 4 26 4 4 4 4 4 4 4 4 1 4 4 4 27 4 3 3 4 3 3 3 3 1 3 3 3 28 3 4 3 3 3 4 3 4 1 3.333333 3.333333 3 29 4 4 4 4 4 4 4 5 1 4 4 4 30 4 4 3 4 3 4 4 4 1 3.666667 3.666667 4 31 4 4 4 4 4 4 4 3 1 4 4 4 32 4 4 4 4 4 4 4 4 1 4 4 4 33 4 4 4 4 4 4 4 3 1 4 4 4 34 4 4 4 3 4 4 4 4 1 4 4 4 35 4 4 4 4 3 4 4 4 1 3.666667 3.666667 4 36 4 4 4 4 4 3 4 4 1 4 3.666667 4 37 4 4 3 4 3 3 4 3 1 3.333333 3.333333 3 38 4 4 4 4 4 4 4 3 1 4.3333335 4 4 39 4 3 4 3 4 4 3 2 1 3.666667 3.666667 4 40 2 2 3 2 2 3 2 5 1 2.3333333 2.3333333 2 41 3 3 3 3 4 4 3 4 1 3.666667 3.666667 4 42 3 4 3 4 4 4 4 3 1 4 4 4 43 4 4 3 4 4 4 4 4 1 4.3333335 4 4 44 4 2 4 3 4 4 3 3 1 3.666667 3.666667 4 45 4 4 4 4 3 4 4 4 1 4 3.666667 4 46 4 4 4 4 3 4 2 4 1 3 3 3 47 4 4 4 4 4 4 3 3 1 4 3.666667 4 48 4 4 3 4 4 4 4 2 1 4.3333335 4 4 49 4 4 3 4 4 4 3 5 1 4.3333335 3.666667 4 50 4 4 3 4 3 4 4 4 1 4 3.666667 4 51 4 4 4 4 3 4 4 4 1 4 3.666667 4 52 4 4 4 4 3 4 4 4 1 4 3.666667 4 53 4 4 4 4 3 4 4 4 1 4 3.666667 4 54 4 2 3 4 3 3 4 4 1 3.333333 3.333333 3 55 4 4 3 4 4 4 4 4 1 4.3333335 4 4 56 4 4 3 4 4 4 4 4 1 4.3333335 4 4 57 4 4 3 4 4 4 4 4 1 4.3333335 4 4 58 4 4 3 4 4 4 4 4 1 4.3333335 4 4 59 4 4 3 4 4 4 4 4 1 4.3333335 4 4 60 4 4 3 4 4 4 4 4 1 4.3333335 4 4 61 4 4 3 4 4 4 4 4 1 4.3333335 4 4 62 4 4 3 4 4 4 4 4 1 4.3333335 4 4 63 4 4 3 4 4 4 4 4 1 4.3333335 4 4 64 4 4 3 4 4 4 4 4 1 4.3333335 4 4 65 4 4 3 4 4 4 4 4 1 4.3333335 4 4 66 4 4 3 4 4 4 4 4 1 4.3333335 4 4 67 4 4 3 4 3 4 3 4 1 3.333333 3.333333 3 68 4 4 4 4 4 4 4 4 1 4 4 4 69 4 4 3 4 4 4 4 4 1 4.3333335 4 4 70 3 4 3 4 4 4 4 5 1 4.3333335 4 4 71 2 2 2 2 2 2 2 3 1 1.6666666 2 2 72 4 4 3 4 4 4 4 4 1 4.3333335 4 4 73 4 4 3 4 4 4 4 4 1 4.3333335 4 4 74 4 4 3 4 4 4 4 4 1 4.3333335 4 4 75 2 2 2 2 2 2 2 2 1 2 2 2 76 4 4 3 4 4 4 4 4 1 4.3333335 4 4 77 4 4 3 4 4 4 4 4 1 4.3333335 4 4 78 4 4 3 4 4 4 4 4 1 4.3333335 4 4 79 4 4 3 4 4 4 4 4 1 4.3333335 4 4 80 4 4 3 4 4 4 4 4 1 4.3333335 4 4 81 2 2 2 2 2 2 2 3 1 2 2 2 82 4 4 4 4 4 4 2 4 1 3 3.333333 3 83 3 4 3 4 3 4 3 4 1 3.333333 3.333333 3 84 4 4 3 4 3 4 4 4 1 4 3.666667 4 85 3 3 3 2 3 2 3 3 1 2.3333333 2.666667 3 86 4 4 3 4 4 3 3 3 1 3.333333 3.333333 3 87 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 88 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 89 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 90 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 91 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 92 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 93 4 3 3 3 3 3 3 4 1 3 3 3 94 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 95 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 96 3 3 3 4 3 4 3 4 1 3.333333 3.333333 3 97 4 2 4 4 3 4 4 3 1 4 3.666667 4 98 4 2 4 4 3 4 4 3 1 4 3.666667 4 99 4 2 4 4 3 4 4 3 1 4 3.666667 4 100 4 2 4 4 3 4 4 3 1 4 3.666667 4 end
Code:
* Example generated by -dataex-. For more info, type help dataex clear input byte id int year double(x1 x2 x3 x4) 1 2015 20.347026922248485 49.47079438424892 109.04879903504597 79.92503157304553 1 2016 20.347026922248485 49.47079438424892 109.04879903504597 79.92503157304553 1 2017 20.347026922248485 49.47079438424892 109.04879903504597 79.92503157304553 1 2018 20.35 49.47 109.05 79.93 1 2019 281.5659509074303 175.16150776489016 0 106.40444314254015 1 2020 20.35 49.47 109.05 79.93 2 2015 20.35 49.47 109.05 79.93 2 2016 20.347026922248485 49.47079438424892 109.04879903504597 79.92503157304553 2 2017 20.347026922248485 49.47079438424892 109.04879903504597 79.92503157304553 2 2018 754.6806217017153 569.7589838509434 92.78338302333559 277.7050208741074 2 2019 20.35 49.47 109.05 79.93 2 2020 281.5659509074303 175.16150776489016 0 106.40444314254015 3 2015 20.35 49.47 109.05 79.93 3 2016 755.2314928784776 71.51901774255923 118.0188717931034 801.7313469290218 3 2017 20.35 49.47 109.05 79.93 3 2018 20.35 49.47 109.05 79.93 3 2019 20.35 49.47 109.05 79.93 3 2020 20.35 49.47 109.05 79.93 4 2015 20.35 49.47 109.05 79.93 4 2016 20.35 49.47 109.05 79.93 4 2017 20.35 49.47 109.05 79.93 4 2018 281.5659509074303 175.16150776489016 0 106.40444314254015 4 2019 187.0916141934912 80.76320483159611 0 106.3284093618951 4 2020 20.35 49.47 109.05 79.93 5 2015 240.1311261225785 26.33112471712456 35.455171719850846 249.2551731253048 5 2016 225.39589024771126 29.048676926305582 19.84516278242997 216.19237610383567 5 2017 20.35 49.47 109.05 79.93 5 2018 20.35 49.47 109.05 79.93 5 2019 20.35 49.47 109.05 79.93 5 2020 20.35 49.47 109.05 79.93 6 2015 20.35 49.47 109.05 79.93 6 2016 20.35 49.47 109.05 79.93 6 2017 20.35 49.47 109.05 79.93 6 2018 201.34874071811177 20.35 49.47 109.05 6 2019 20.35 49.47 109.05 79.93 6 2020 20.35 49.47 109.05 79.93 7 2015 20.35 49.47 109.05 79.93 7 2016 84.57281104930097 107.10183737317888 44.841881937177924 22.312855613300002 7 2017 84.57281104930097 107.10183737317888 44.841881937177924 22.312855613300002 7 2018 2.92 107.10183737317888 44.841881937177924 -59.339955436000956 7 2019 20.35 49.47 109.05 79.93 7 2020 20.35 49.47 109.05 79.93 8 2015 20.35 49.47 109.05 79.93 8 2016 20.35 49.47 109.05 79.93 8 2017 84.57281104930097 107.10183737317888 44.841881937177924 22.312855613300002 8 2018 20.35 49.47 109.05 79.93 8 2019 84.57281104930097 107.10183737317888 44.841881937177924 22.312855613300002 8 2020 84.57281104930097 107.10183737317888 44.841881937177924 22.312855613300002 9 2015 39.27948232808293 42.71068032128863 323.5918529595831 320.16065496637736 9 2016 20.35 49.47 109.05 79.93 9 2017 -4.996090851622248 58.6785658166025 317.8382168845239 254.16356021629917 9 2018 30.596338978363097 19.971784613285443 277.6765530739841 288.3011074390618 9 2019 30.596338978363097 19.971784613285443 277.6765530739841 288.3011074390618 9 2020 84.57 107.1 44.84 22.31 10 2015 30.596338978363097 19.971784613285443 277.6765530739841 288.3011074390618 10 2016 21.35076025339696 146.8892492716466 207.33363028053222 81.79514126228258 10 2017 45.76017176672151 117.30297532626908 129.6327146968145 58.089911137266924 10 2018 20.347026922248485 49.47079438424892 109.04879903504597 79.92503157304553 10 2019 32.59662829711888 57.6686987864789 123.46582967233664 98.39375918297662 10 2020 84.57 107.1 44.84 22.31 11 2015 32.59662829711888 57.6686987864789 123.46582967233664 98.39375918297662 11 2016 32.59662829711888 57.6686987864789 123.46582967233664 98.39375918297662 11 2017 20.35 49.47 109.05 79.93 11 2018 32.59662829711888 57.6686987864789 123.46582967233664 98.39375918297662 11 2019 32.59662829711888 57.6686987864789 123.46582967233664 98.39375918297662 11 2020 84.57 107.1 44.84 22.31 12 2015 20.35 49.47 109.05 79.93 12 2016 20.35 49.47 109.05 79.93 12 2017 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 12 2018 123.53359923171953 74.24665126255553 164.85477587992602 214.14172384909006 12 2019 132.3637338460685 69.65091084510071 .38761929783934074 63.100442298807124 12 2020 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 13 2015 20.35 49.47 109.05 79.93 13 2016 74.63789515699132 124.30004277920449 165.1795904290986 115.51744280688541 13 2017 74.4414201833654 75.86310442266561 155.19454699651158 153.77286275721133 13 2018 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 13 2019 20.35 49.47 109.05 79.93 13 2020 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 14 2015 74.50431693354076 71.67716114757557 208.32622347647367 211.15337926243888 14 2016 105.53007425852793 89.31088815094877 168.10463404074576 184.32382014832496 14 2017 99.0405344236341 73.04311089618211 220.74207807995495 246.73950160740696 14 2018 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 14 2019 66.07735012600465 60.65546894000009 262.92858459247293 268.3504657784775 14 2020 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 15 2015 20.35 49.47 109.05 79.93 15 2016 20.35 49.47 109.05 79.93 15 2017 20.35 49.47 109.05 79.93 15 2018 84.57 107.1 44.84 22.31 15 2019 20.35 49.47 109.05 79.93 15 2020 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 16 2015 84.57 107.1 44.84 22.31 16 2016 84.57 107.1 44.84 22.31 16 2017 96.06104160794676 72.49889170863416 0 23.5621498993126 16 2018 20.35 49.47 109.05 79.93 16 2019 20.35 49.47 109.05 79.93 16 2020 132.7028500589249 102.31041294987946 186.74432371039987 217.1367608194453 17 2015 84.71096973363007 134.64737635000364 552.3194564780603 502.38304986168674 17 2016 115.30553946300019 77.62892850051966 433.2098680541373 470.88647901661784 17 2017 20.35 49.47 109.05 79.93 17 2018 57.06447708816423 123.87795206078074 242.0371093956506 175.22363442303407 end
Comment