Wide to long formate

[Muhammad Ramzan]

Hi

I want to convert my data from wide to long format. how I can do that, please I want to have four columns , Lat Longitude Month Year Please

* Example generated by -dataex-. To install: ssc install dataex
clear
input double(lat longitude Jan Feb Mar April May June July Aug Sep Oct Nov Dec) float year
-179.75  71.25 -25.5   -26 -20.9 -17.2  -7.9    .7   2.7    .7   -.3  -4.9 -13.3 -19.3 1984
-179.75  68.75 -28.8 -30.8 -24.4 -19.7  -9.7    .1   3.2    .2  -1.7  -6.8 -15.9 -22.9 1984
-179.75  68.25 -29.4 -31.4 -25.1 -20.1 -10.5     0   3.5    .2  -2.2  -7.7 -16.6 -23.7 1984
-179.75  67.75   -28 -30.1 -23.9 -18.6  -9.4   2.3   6.6   2.6   -.9  -7.4 -15.9 -22.9 1984
-179.75  67.25 -29.8 -32.2 -26.4 -20.5 -11.4   1.8     7   2.2  -2.7 -10.8 -18.7 -25.7 1984
-179.75  66.75 -25.7   -27 -21.9   -16  -8.6   3.7   9.2   4.9     0  -7.5 -14.2 -21.2 1984
-179.75  66.25 -21.3 -21.4 -16.3 -11.6  -5.9     4   9.6   6.2   2.1  -3.7  -9.4 -16.1 1984
-179.75  65.75 -21.1 -21.3 -16.7 -10.7  -5.9   4.5  10.7   7.7   3.6  -2.9  -8.9 -14.6 1984
-179.75  65.25 -22.1 -22.7 -17.6 -11.3  -6.3   4.2  11.2   7.9     4  -3.7  -9.9 -14.8 1984
-179.75 -16.75  27.8  27.9  28.2  28.4  27.4    27    26  26.3  26.7  27.7  28.8  29.2 1984
-179.75 -84.75 -19.7 -24.2 -37.9 -48.1 -43.2 -34.2 -45.3 -46.7 -49.8   -38 -26.9 -18.7 1984
-179.75 -85.25 -24.7 -30.6 -44.6 -54.5 -49.7 -41.8 -51.8 -52.7 -55.9 -44.6 -32.7 -24.1 1984
-179.75 -85.75 -23.6 -30.8 -44.7 -54.6 -49.8 -42.9 -51.8 -52.6 -55.6 -44.7 -32.2 -23.2 1984
-179.75 -86.25   -25 -33.2 -47.3 -56.9 -52.3 -46.1 -54.1   -55 -57.7 -47.5 -34.1 -24.8 1984
-179.75 -86.75 -26.2   -35 -49.2 -58.6 -54.3 -48.8 -55.7 -56.9 -59.3 -49.5 -35.4 -26.1 1984
-179.75 -87.25 -26.9 -36.1 -50.4 -59.6 -55.5 -50.7 -56.7 -58.4 -60.3 -50.8 -36.2 -26.7 1984
-179.75 -87.75 -27.3   -37 -51.4 -60.5 -56.6 -52.5 -57.6 -59.7   -61 -51.8 -36.9 -27.3 1984
-179.75 -88.25 -27.9   -38 -52.5 -61.6 -57.8 -54.3 -58.7 -61.1 -61.8 -53.1 -37.7   -28 1984
-179.75 -88.75 -27.9 -38.7   -53 -62.1 -58.3 -55.4 -59.1 -62.1 -62.4 -53.8 -37.9 -28.3 1984
-179.75 -89.25 -27.6 -39.1 -53.1 -62.2 -58.5 -55.9 -59.3 -62.6 -62.7 -54.2 -37.7   -28 1984
-179.75 -89.75 -27.1 -39.6 -53.1 -62.4 -58.7 -55.8 -59.4 -63.1 -63.1 -54.4 -37.3 -27.8 1984
-179.25  71.25 -25.8 -26.2 -21.2 -17.5  -8.1    .4   2.5    .6   -.5  -5.1 -13.6 -19.6 1984
-179.25  68.75 -27.6 -29.5 -22.9 -18.3  -8.5   1.5   4.7   1.7   -.2  -5.3 -14.4 -21.4 1984
-179.25  68.25 -29.4 -31.4   -25 -20.1 -10.4    .1   3.6    .2  -2.2  -7.7 -16.5 -23.7 1984
-179.25  67.75   -29 -31.1 -24.9 -19.6 -10.2   1.5   5.7   1.8  -1.9  -8.4 -16.8 -23.9 1984
-179.25  67.25 -28.2 -30.8 -24.8   -19  -9.4   4.1   9.3   4.3   -.8  -9.3 -17.3 -24.4 1984
-179.25  66.75 -27.2 -28.9 -23.5 -17.8  -9.9   2.8   8.4   3.8  -1.2  -9.2   -16 -23.1 1984
-179.25 -84.75 -18.7 -23.2 -36.8   -47 -42.1 -33.2 -44.3 -45.7 -48.7   -37   -26 -17.8 1984
-179.25 -85.25 -24.6 -30.5 -44.4 -54.3 -49.4 -41.6 -51.5 -52.5 -55.6 -44.4 -32.7 -23.9 1984
-179.25 -85.75 -23.4 -30.5 -44.5 -54.3 -49.5 -42.6 -51.5 -52.3 -55.3 -44.5   -32   -23 1984
-179.25 -86.25   -25 -33.2 -47.2 -56.8 -52.2 -46.1   -54 -54.9 -57.6 -47.4   -34 -24.8 1984
-179.25 -86.75 -26.1   -35 -49.1 -58.5 -54.2 -48.7 -55.7 -56.9 -59.2 -49.4 -35.4   -26 1984
-179.25 -87.25 -26.8 -36.1 -50.4 -59.5 -55.5 -50.7 -56.7 -58.3 -60.2 -50.7 -36.1 -26.7 1984
-179.25 -87.75 -27.3 -36.9 -51.4 -60.5 -56.5 -52.5 -57.6 -59.6 -60.9 -51.8 -36.8 -27.3 1984
-179.25 -88.25 -27.9   -38 -52.5 -61.6 -57.7 -54.3 -58.7 -61.1 -61.7 -53.1 -37.7 -28.1 1984
-179.25 -88.75 -27.9 -38.6   -53 -62.1 -58.3 -55.4   -59 -62.1 -62.3 -53.8 -37.9 -28.3 1984
-179.25 -89.25 -27.5   -39 -53.1 -62.2 -58.5 -55.9 -59.2 -62.6 -62.7 -54.2 -37.7   -28 1984
-179.25 -89.75 -27.1 -39.6 -53.1 -62.4 -58.7 -55.8 -59.4 -63.1 -63.1 -54.4 -37.3 -27.8 1984
-178.75  71.25 -25.5 -25.8 -20.7 -17.1  -7.8    .8     3    .8   -.1  -4.7 -13.1 -19.2 1984
-178.75  68.25 -27.4 -29.4   -23 -18.1  -8.5     2   5.6   2.2   -.3  -5.7 -14.5 -21.8 1984
-178.75  67.75 -27.5 -29.6 -23.3 -18.1  -8.7   2.9   7.2   3.2   -.5  -6.9 -15.2 -22.4 1984
-178.75  67.25 -26.8 -29.5 -23.3 -17.5  -7.9   5.7  10.8   5.8    .7  -7.9 -15.9 -23.1 1984
-178.75  66.75 -27.9 -29.8 -24.2 -18.5 -10.2   2.6   8.1   3.5  -1.6  -9.8 -16.8 -23.9 1984
-178.75  66.25 -21.9 -22.2 -17.4 -12.4  -6.8   3.1   8.9   5.7   1.7  -4.7 -10.4 -16.4 1984
-178.75 -84.75 -21.1 -25.6   -39 -49.2 -44.4 -35.5 -46.6   -48   -51 -39.4 -28.4 -20.3 1984
-178.75 -85.25 -24.1 -29.9 -43.7 -53.6 -48.8   -41   -51 -51.9 -54.9 -43.8 -32.1 -23.5 1984
-178.75 -85.75 -23.2 -30.3 -44.2   -54 -49.2 -42.3 -51.2   -52   -55 -44.2 -31.7 -22.8 1984
-178.75 -86.25   -25 -33.1 -47.2 -56.7 -52.2 -46.1 -53.9 -54.8 -57.6 -47.3   -34 -24.8 1984
-178.75 -86.75 -26.1 -34.9   -49 -58.4 -54.1 -48.6 -55.6 -56.8 -59.1 -49.3 -35.3   -26 1984
-178.75 -87.25 -26.8   -36 -50.3 -59.4 -55.4 -50.6 -56.6 -58.2 -60.1 -50.6 -36.1 -26.7 1984
-178.75 -87.75 -27.2 -36.9 -51.4 -60.5 -56.5 -52.4 -57.6 -59.6 -60.9 -51.7 -36.8 -27.3 1984
-178.75 -88.25 -27.9   -38 -52.4 -61.6 -57.7 -54.3 -58.7 -61.1 -61.7 -53.1 -37.7 -28.1 1984
-178.75 -88.75 -27.9 -38.6   -53 -62.1 -58.3 -55.3   -59 -62.1 -62.3 -53.8 -37.9 -28.2 1984
-178.75 -89.25 -27.5   -39 -53.1 -62.1 -58.5 -55.9 -59.2 -62.6 -62.8 -54.2 -37.7   -28 1984
-178.75 -89.75 -27.1 -39.6 -53.1 -62.4 -58.7 -55.8 -59.4 -63.1 -63.1 -54.4 -37.3 -27.8 1984
-178.25  71.25 -25.6 -26.2 -21.1 -17.5  -8.3    .3   2.5    .5   -.5  -5.1 -13.4 -19.6 1984
-178.25  68.25 -28.1   -30 -23.5 -18.7  -9.1   1.3     5   1.5    -1  -6.3 -14.9 -22.3 1984
-178.25  67.75 -26.6 -28.7 -22.2 -17.2    -8   3.5   7.8   3.8    .3  -5.8   -14 -21.5 1984
-178.25  67.25 -27.9 -30.3   -24 -18.4  -9.1     4     9   4.3   -.6  -8.5 -16.4 -23.7 1984
-178.25  66.75 -28.1 -29.8 -24.1 -18.6 -10.4   2.2   7.7   3.2  -1.7  -9.8 -16.7 -23.8 1984
-178.25  66.25 -21.3 -21.9 -16.7 -11.8  -5.7   5.1  10.9   7.4   3.2  -3.7  -9.6   -16 1984
-178.25  65.75 -21.5 -21.9 -16.9 -11.4  -6.1   4.9  10.8   7.5   3.3  -3.6  -9.6 -15.4 1984
-178.25 -84.75 -21.2 -25.6 -39.1 -49.3 -44.5 -35.5 -46.6   -48   -51 -39.4 -28.6 -20.4 1984
-178.25 -85.25 -22.1 -27.9 -41.6 -51.6 -46.7   -39 -48.9 -49.8 -52.9 -41.8 -30.1 -21.5 1984
-178.25 -85.75 -23.1 -30.2   -44 -53.8   -49 -42.1 -51.1 -51.8 -54.8   -44 -31.7 -22.8 1984
-178.25 -86.25 -24.9   -33   -47 -56.6   -52 -45.9 -53.8 -54.7 -57.4 -47.2   -34 -24.7 1984
-178.25 -86.75   -26 -34.8 -48.9 -58.3   -54 -48.5 -55.5 -56.7   -59 -49.2 -35.3 -25.9 1984
-178.25 -87.25 -26.8   -36 -50.2 -59.4 -55.3 -50.5 -56.6 -58.2   -60 -50.6   -36 -26.6 1984
-178.25 -87.75 -27.2 -36.9 -51.3 -60.4 -56.4 -52.4 -57.5 -59.6 -60.9 -51.7 -36.8 -27.3 1984
-178.25 -88.25 -27.9   -38 -52.4 -61.6 -57.7 -54.3 -58.7 -61.1 -61.7 -53.1 -37.7 -28.1 1984
-178.25 -88.75 -27.9 -38.6   -53   -62 -58.3 -55.3   -59   -62 -62.3 -53.7 -37.9 -28.2 1984
-178.25 -89.25 -27.5   -39   -53 -62.1 -58.5 -55.8 -59.2 -62.6 -62.8 -54.1 -37.7   -28 1984
-178.25 -89.75 -27.1 -39.6 -53.1 -62.4 -58.7 -55.8 -59.4 -63.1 -63.1 -54.4 -37.3 -27.8 1984
-177.75  71.25 -24.7 -25.4 -20.2 -16.8  -7.6   1.1   3.2   1.2    .2  -4.3 -12.6 -18.8 1984
-177.75  68.25 -26.9 -28.7 -22.2 -17.4    -8   2.3     6   2.6    .2    -5 -13.5   -21 1984
-177.75  67.75 -26.9 -28.8 -22.1 -17.4  -8.3   2.9   7.1   3.2     0  -5.8 -13.8 -21.3 1984
-177.75  67.25 -26.3 -28.4 -21.9 -16.8  -7.8   4.7   9.5   5.1    .7  -6.4 -14.3 -21.7 1984
-177.75  66.75 -27.7 -29.4 -23.4 -18.3   -10   2.3   7.7   3.2  -1.4  -9.1   -16 -23.3 1984
-177.75  66.25 -23.6 -24.5 -18.9   -14  -7.6   3.8   9.4   5.7   1.5  -5.6 -11.8 -18.4 1984
-177.75  65.75 -22.6 -23.2 -17.8 -12.6  -7.1   4.1   9.9   6.5   2.2  -4.7 -10.7 -16.9 1984
-177.75 -84.75 -20.3 -24.6   -38 -48.3 -43.4 -34.6 -45.6   -47   -50 -38.5 -27.6 -19.5 1984
-177.75 -85.25 -20.1 -25.9 -39.6 -49.5 -44.6 -36.9 -46.8 -47.8 -50.8 -39.8 -28.2 -19.6 1984
-177.75 -85.75   -23 -30.1 -43.8 -53.6 -48.8   -42   -51 -51.7 -54.7   -44 -31.6 -22.8 1984
-177.75 -86.25 -24.7 -32.7 -46.5 -56.1 -51.5 -45.5 -53.4 -54.3   -57 -46.8 -33.7 -24.6 1984
-177.75 -86.75   -26 -34.7 -48.9 -58.2 -53.9 -48.4 -55.4 -56.6 -58.9 -49.1 -35.2 -25.9 1984
-177.75 -87.25 -26.7 -35.9 -50.1 -59.3 -55.2 -50.4 -56.5 -58.1 -59.9 -50.5   -36 -26.6 1984
-177.75 -87.75 -27.2 -36.8 -51.3 -60.4 -56.4 -52.3 -57.5 -59.5 -60.8 -51.7 -36.8 -27.3 1984
-177.75 -88.25 -27.9   -38 -52.4 -61.6 -57.7 -54.3 -58.6 -61.1 -61.7 -53.1 -37.7 -28.1 1984
-177.75 -88.75 -27.9 -38.6   -53   -62 -58.3 -55.3   -59   -62 -62.3 -53.7 -37.9 -28.2 1984
-177.75 -89.25 -27.5   -39   -53 -62.1 -58.4 -55.7 -59.2 -62.6 -62.8 -54.1 -37.7   -28 1984
-177.75 -89.75 -27.1 -39.6 -53.1 -62.4 -58.7 -55.8 -59.4 -63.1 -63.1 -54.4 -37.3 -27.8 1984
-177.25  67.75 -26.5 -28.2 -21.5 -16.9    -8   2.8     7   3.2    .3  -4.8 -12.7 -20.5 1984
-177.25  67.25 -26.1   -28 -21.1 -16.7  -7.9   4.1   8.7   4.4    .6  -5.7 -13.3   -21 1984
-177.25  66.75   -25 -26.6   -20 -15.6  -7.6   4.6   9.7   5.4   1.3  -5.7 -12.8 -20.3 1984
-177.25  66.25 -24.8 -25.9 -19.6 -15.2  -8.5   3.3   8.7   4.9    .8  -6.3 -12.6 -19.7 1984
-177.25  65.75 -22.6 -23.4 -17.6 -12.8  -6.9   4.2   9.7   6.3   2.1  -4.9 -10.7 -17.3 1984
-177.25  51.75   -.4   -.6   2.9   2.9   3.4     6   8.7   8.8   7.7   4.9   2.9   1.2 1984
-177.25 -84.75 -18.7 -23.1 -36.4 -46.5 -41.7 -32.9   -44 -45.2 -48.3 -36.8 -25.9 -17.8 1984
-177.25 -85.25 -18.5 -24.3 -37.8 -47.7 -42.8 -35.2 -45.2   -46   -49   -38 -26.5 -17.9 1984
-177.25 -85.75 -23.1 -30.1 -43.8 -53.6 -48.8 -42.1   -51 -51.7 -54.6   -44 -31.7 -22.8 1984
end

[William Lisowski]

The following may start you in a useful direction.

rename (Jan Feb Mar April May June July Aug Sep Oct Nov Dec) (data#), addnumber
reshape long data, i(lat longitude year) j(month)
generate date = ym(year,month), after(month)
format %tm date
list in 1/12, clean abbreviate(16)

. list in 1/12, clean abbreviate(16)

           lat   longitude   year   month      date    data  
  1.   -179.75      -89.75   1984       1    1984m1   -27.1  
  2.   -179.75      -89.75   1984       2    1984m2   -39.6  
  3.   -179.75      -89.75   1984       3    1984m3   -53.1  
  4.   -179.75      -89.75   1984       4    1984m4   -62.4  
  5.   -179.75      -89.75   1984       5    1984m5   -58.7  
  6.   -179.75      -89.75   1984       6    1984m6   -55.8  
  7.   -179.75      -89.75   1984       7    1984m7   -59.4  
  8.   -179.75      -89.75   1984       8    1984m8   -63.1  
  9.   -179.75      -89.75   1984       9    1984m9   -63.1  
 10.   -179.75      -89.75   1984      10   1984m10   -54.4  
 11.   -179.75      -89.75   1984      11   1984m11   -37.3  
 12.   -179.75      -89.75   1984      12   1984m12   -27.8