WIDE form

[Olivia Emma]

Hello how I can convert the data to the WIDE form please



----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input int year byte month float(x y lon lat) str4 name float value
1998  1 72.3665 34.8139 72.3665 34.8139 "u100"   -1.25926
1998  1 72.3665 34.8139 72.3665 34.8139 "v100"  -2.232206
1998  1 72.3665 34.8139 72.3665 34.8139 "u10"   -.7999066
1998  1 72.3665 34.8139 72.3665 34.8139 "v10"   -1.827169
1998  1 72.3665 34.8139 72.3665 34.8139 "si10"   2.060407
1998  1 72.3665 34.8139 72.3665 34.8139 "blh"    55.40334
1998  2 72.3665 34.8139 72.3665 34.8139 "u100"  -1.118549
1998  2 72.3665 34.8139 72.3665 34.8139 "v100"  -1.607052
1998  2 72.3665 34.8139 72.3665 34.8139 "u10"    -.669885
1998  2 72.3665 34.8139 72.3665 34.8139 "v10"   -1.388758
1998  2 72.3665 34.8139 72.3665 34.8139 "si10"   1.634057
1998  2 72.3665 34.8139 72.3665 34.8139 "blh"    81.01574
1998  3 72.3665 34.8139 72.3665 34.8139 "u100"   -.966468
1998  3 72.3665 34.8139 72.3665 34.8139 "v100"  -1.638351
1998  3 72.3665 34.8139 72.3665 34.8139 "u10"   -.5666764
1998  3 72.3665 34.8139 72.3665 34.8139 "v10"   -1.288639
1998  3 72.3665 34.8139 72.3665 34.8139 "si10"   1.526176
1998  3 72.3665 34.8139 72.3665 34.8139 "blh"    140.1192
1998  4 72.3665 34.8139 72.3665 34.8139 "u100"  -.8479298
1998  4 72.3665 34.8139 72.3665 34.8139 "v100"  -1.170102
1998  4 72.3665 34.8139 72.3665 34.8139 "u10"   -.4938983
1998  4 72.3665 34.8139 72.3665 34.8139 "v10"   -.8757244
1998  4 72.3665 34.8139 72.3665 34.8139 "si10"   1.496092
1998  4 72.3665 34.8139 72.3665 34.8139 "blh"    402.7865
1998  5 72.3665 34.8139 72.3665 34.8139 "u100"  -.7967622
1998  5 72.3665 34.8139 72.3665 34.8139 "v100"  -.9864272
1998  5 72.3665 34.8139 72.3665 34.8139 "u10"   -.4694262
1998  5 72.3665 34.8139 72.3665 34.8139 "v10"    -.727411
1998  5 72.3665 34.8139 72.3665 34.8139 "si10"    1.62141
1998  5 72.3665 34.8139 72.3665 34.8139 "blh"    516.5601
1998  6 72.3665 34.8139 72.3665 34.8139 "u100"  -.5443355
1998  6 72.3665 34.8139 72.3665 34.8139 "v100"  -.7640402
1998  6 72.3665 34.8139 72.3665 34.8139 "u10"   -.3081228
1998  6 72.3665 34.8139 72.3665 34.8139 "v10"   -.5685259
1998  6 72.3665 34.8139 72.3665 34.8139 "si10"   1.582703
1998  6 72.3665 34.8139 72.3665 34.8139 "blh"    660.9937
1998  7 72.3665 34.8139 72.3665 34.8139 "u100"  -.1150965
1998  7 72.3665 34.8139 72.3665 34.8139 "v100"   .3796055
1998  7 72.3665 34.8139 72.3665 34.8139 "u10"  -.06042213
1998  7 72.3665 34.8139 72.3665 34.8139 "v10"    .1497217
1998  7 72.3665 34.8139 72.3665 34.8139 "si10"   1.123586
1998  7 72.3665 34.8139 72.3665 34.8139 "blh"    319.0855
1998  8 72.3665 34.8139 72.3665 34.8139 "u100"  -.0693299
1998  8 72.3665 34.8139 72.3665 34.8139 "v100"   .3235969
1998  8 72.3665 34.8139 72.3665 34.8139 "u10"  -.02041549
1998  8 72.3665 34.8139 72.3665 34.8139 "v10"   .09841827
1998  8 72.3665 34.8139 72.3665 34.8139 "si10"   1.046556
1998  8 72.3665 34.8139 72.3665 34.8139 "blh"    308.2423
1998  9 72.3665 34.8139 72.3665 34.8139 "u100"  -.1051472
1998  9 72.3665 34.8139 72.3665 34.8139 "v100"   .0847368
1998  9 72.3665 34.8139 72.3665 34.8139 "u10"  -.06510375
1998  9 72.3665 34.8139 72.3665 34.8139 "v10"   -.1276276
1998  9 72.3665 34.8139 72.3665 34.8139 "si10"   1.163634
1998  9 72.3665 34.8139 72.3665 34.8139 "blh"    333.7746
1998 10 72.3665 34.8139 72.3665 34.8139 "u100"  -.2484164
1998 10 72.3665 34.8139 72.3665 34.8139 "v100"  -.3114415
1998 10 72.3665 34.8139 72.3665 34.8139 "u10"   -.1810804
1998 10 72.3665 34.8139 72.3665 34.8139 "v10"   -.4121283
1998 10 72.3665 34.8139 72.3665 34.8139 "si10"   1.364258
1998 10 72.3665 34.8139 72.3665 34.8139 "blh"    396.6438
1998 11 72.3665 34.8139 72.3665 34.8139 "u100"  -.4257973
1998 11 72.3665 34.8139 72.3665 34.8139 "v100"  -.8138713
1998 11 72.3665 34.8139 72.3665 34.8139 "u10"   -.2891835
1998 11 72.3665 34.8139 72.3665 34.8139 "v10"   -.7323858
1998 11 72.3665 34.8139 72.3665 34.8139 "si10"   1.406223
1998 11 72.3665 34.8139 72.3665 34.8139 "blh"     272.855
1998 12 72.3665 34.8139 72.3665 34.8139 "u100"  -.4994218
1998 12 72.3665 34.8139 72.3665 34.8139 "v100"   -1.23723
1998 12 72.3665 34.8139 72.3665 34.8139 "u10"    -.407501
1998 12 72.3665 34.8139 72.3665 34.8139 "v10"   -1.016265
1998 12 72.3665 34.8139 72.3665 34.8139 "si10"   1.554918
1998 12 72.3665 34.8139 72.3665 34.8139 "blh"    186.3497
1999  1 72.3665 34.8139 72.3665 34.8139 "u100"  -.9388943
1999  1 72.3665 34.8139 72.3665 34.8139 "v100"  -1.642881
1999  1 72.3665 34.8139 72.3665 34.8139 "u10"   -.6288143
1999  1 72.3665 34.8139 72.3665 34.8139 "v10"   -1.403372
1999  1 72.3665 34.8139 72.3665 34.8139 "si10"   1.652835
1999  1 72.3665 34.8139 72.3665 34.8139 "blh"    80.69525
1999  2 72.3665 34.8139 72.3665 34.8139 "u100"  -1.245615
1999  2 72.3665 34.8139 72.3665 34.8139 "v100"  -2.363167
1999  2 72.3665 34.8139 72.3665 34.8139 "u10"   -.6611601
1999  2 72.3665 34.8139 72.3665 34.8139 "v10"   -1.531786
1999  2 72.3665 34.8139 72.3665 34.8139 "si10"   1.781986
1999  2 72.3665 34.8139 72.3665 34.8139 "blh"    158.8945
1999  3 72.3665 34.8139 72.3665 34.8139 "u100"   -1.17256
1999  3 72.3665 34.8139 72.3665 34.8139 "v100"  -1.472384
1999  3 72.3665 34.8139 72.3665 34.8139 "u10"   -.6560529
1999  3 72.3665 34.8139 72.3665 34.8139 "v10"   -1.094619
1999  3 72.3665 34.8139 72.3665 34.8139 "si10"   1.543038
1999  3 72.3665 34.8139 72.3665 34.8139 "blh"    328.9673
1999  4 72.3665 34.8139 72.3665 34.8139 "u100"  -1.248742
1999  4 72.3665 34.8139 72.3665 34.8139 "v100"  -1.689005
1999  4 72.3665 34.8139 72.3665 34.8139 "u10"   -.7198933
1999  4 72.3665 34.8139 72.3665 34.8139 "v10"   -1.165511
1999  4 72.3665 34.8139 72.3665 34.8139 "si10"   1.841962
1999  4 72.3665 34.8139 72.3665 34.8139 "blh"    540.8371
1999  5 72.3665 34.8139 72.3665 34.8139 "u100"  -.5034015
1999  5 72.3665 34.8139 72.3665 34.8139 "v100"  -.7673348
1999  5 72.3665 34.8139 72.3665 34.8139 "u10"   -.3259981
1999  5 72.3665 34.8139 72.3665 34.8139 "v10"   -.6117451
end

[Clyde Schechter]

You don't say specifically what you want to widen. Inspecting your data, the variables x, y, lat, and lon are constant within name, so there seems no need to widen those. That suggests you want one observation per name, with the value variable widened to a new variable for each date (combination of month and year). If this is what you want:

gen mdate = ym(year, month)
tostring mdate, replace format(%tmMonCCYY) force

drop year month
reshape wide value, i(name) j(mdate) string

Remember, though, that wide data sets like this are not generally useful for data management or analysis in Stata. Unless you know you will be doing things that Stata does best with wide data, you would be better off leaving the data as you have it.