Dataex
input float(machine u_i control u_ij replicate e_ijk IUg mach1 MC MCR) byte(_Imach1_1 _Icontrol_2 _Icontrol_3) float(a var_la rc_m1 rc_m2 machinegrp)
1 -.3613595 1 -2.2488241 9 -.34144485 3.5483716 1 101 9 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 1 -.6411527 3.248664 1 101 1 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 19 -.58134747 3.308469 1 101 19 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 13 -.8380272 3.051789 1 101 13 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 6 .4125426 4.302359 1 101 6 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 2 .014746565 3.904563 1 101 2 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 3 .017024461 3.906841 1 101 3 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 5 .10919923 3.9990156 1 101 5 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 17 .03203565 3.921852 1 101 17 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 14 .11436301 4.0041795 1 101 14 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 20 -1.4966143 2.393202 1 101 20 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 16 .25872865 4.148545 1 101 16 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 10 .13302933 4.0228457 1 101 10 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 12 .41068405 4.3005004 1 101 12 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 7 .2817334 4.17155 1 101 7 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 15 -.804688 3.085128 1 101 15 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 4 -.3305253 3.559291 1 101 4 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 11 .7779937 4.66781 1 101 11 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 18 -.3523701 3.537446 1 101 18 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
1 -.3613595 1 -2.2488241 8 .6450449 4.534861 1 101 8 1 0 0 -4.5388346 3.2264705 6.456529 6.456529 1
2 -.8005237 1 1.2279482 18 -.8221366 6.105288 0 1 78 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 14 -.588227 6.339198 0 1 74 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 9 .409399 7.336823 0 1 69 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 3 .1546188 7.082043 0 1 63 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 4 .3929867 7.320411 0 1 64 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 1 .29526672 7.222691 0 1 61 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 17 -.6704054 6.257019 0 1 77 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 8 .24562158 7.173046 0 1 68 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 10 .2442663 7.171691 0 1 70 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 6 -.1846837 6.742741 0 1 66 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 7 -.25193992 6.675485 0 1 67 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 12 -.5701977 6.357227 0 1 72 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 13 -.16610135 6.761323 0 1 73 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 2 .13275076 7.060175 0 1 62 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 5 -1.1223474 5.805077 0 1 65 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 15 .226643 7.154068 0 1 75 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 20 -.00982337 6.917601 0 1 80 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 11 -.7381899 6.189235 0 1 71 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 16 .261753 7.189178 0 1 76 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
2 -.8005237 1 1.2279482 19 .26213056 7.189555 0 1 79 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 2
3 1.9111975 1 2.657073 5 -.09035812 10.977912 0 1 125 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 9 -.4456822 10.622588 0 1 129 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 3 .7760997 11.84437 0 1 123 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 16 -.6665464 10.401724 0 1 136 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 14 .013667544 11.081938 0 1 134 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 10 .5527822 11.621053 0 1 130 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 7 .6674706 11.73574 0 1 127 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 8 .22014633 11.288417 0 1 128 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 6 -.6031309 10.46514 0 1 126 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 11 -.543506 10.524764 0 1 131 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 1 -.1187402 10.94953 0 1 121 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 4 .08123399 11.149505 0 1 124 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 15 -.4460899 10.62218 0 1 135 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 20 .18556054 11.25383 0 1 140 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 17 .26644492 11.334715 0 1 137 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 18 .1688436 11.237114 0 1 138 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 12 .20416117 11.27243 0 1 132 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 19 -.53024733 10.538023 0 1 139 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 2 .9077698 11.97604 0 1 122 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
3 1.9111975 1 2.657073 13 .9590517 12.027322 0 1 133 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 3
4 3.9684525 1 -.4911294 6 .20242324 10.179747 0 1 186 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 14 -.5016767 9.475646 0 1 194 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 18 .656092 10.633415 0 1 198 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 12 -.6926534 9.28467 0 1 192 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 15 -.7793793 9.197944 0 1 195 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 5 -.6293984 9.347924 0 1 185 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 7 -.03960649 9.937716 0 1 187 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 17 .05240722 10.02973 0 1 197 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 4 .6821012 10.659424 0 1 184 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 11 .6906095 10.667933 0 1 191 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 2 1.6375276 11.61485 0 1 182 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 9 .15997864 10.137301 0 1 189 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 8 -.3305845 9.646739 0 1 188 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 10 -.026655205 9.950667 0 1 190 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 3 1.398476 11.3758 0 1 183 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 20 .18935354 10.166677 0 1 200 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 19 .11395634 10.09128 0 1 199 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 1 1.0028131 10.980136 0 1 181 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 13 .18839094 10.165714 0 1 193 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
4 3.9684525 1 -.4911294 16 -.459852 9.517471 0 1 196 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 4
5 3.223963 1 1.5193216 10 .02002287 11.263308 0 1 250 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 8 -.8441362 10.399148 0 1 248 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 4 -.4457492 10.797535 0 1 244 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 12 -1.552394 9.69089 0 1 252 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 11 .9650219 12.208306 0 1 251 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 1 -.07402497 11.16926 0 1 241 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 19 -.4835758 10.759708 0 1 259 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 15 -.689981 10.553304 0 1 255 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 6 .5518559 11.79514 0 1 246 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 7 .05909928 11.302383 0 1 247 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 5 -.5836872 10.659597 0 1 245 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 16 .3020413 11.545326 0 1 256 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 18 -.52101195 10.722273 0 1 258 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 14 .3551235 11.598408 0 1 254 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 13 -.20767897 11.035605 0 1 253 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 20 -.8556312 10.387653 0 1 260 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 9 -.3721307 10.871154 0 1 249 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 17 -.8019592 10.441325 0 1 257 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 2 .6540512 11.897336 0 1 242 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
5 3.223963 1 1.5193216 3 -.00803754 11.235247 0 1 243 0 0 0 -4.5388346 3.2264705 6.456529 6.456529 5
end
[/CODE]
------------------ copy up to and including the previous line ------------------
Listed 100 out of 600 observations
Use the count() option to list more
There are 10 different machines, 3 types of controls for each machine and 20 replicates for each type of control. u_i and u_ij seems to be unique identifiers for the machine variable.
I am asked to reshape data from long to wide, so that each machine is an observation.
I do not know how to proceed with the stata code.
Related Posts with Reshaping data from long to wide form
Predict y using a different set of dataDear Statalist members, If I regress y on x1 x2 x3, is there a way I can use the estimated values t…
Summary Statistics with Esttab: Don't display valuesHi. I am making a simple table with summary statistics where I want to show the mean and median for…
destringDear Statalist experts, I have the following dataset, all variables are strings, my question is, how…
Two stage least squareHello, please I need the command to make 2SLS . …
Randomizing years and statesHi , I have a variable of interest which is an indicator variable (LAW) that equals 1 if a firm is …
Subscribe to:
Post Comments (Atom)
0 Response to Reshaping data from long to wide form
Post a Comment