Build a lookup table by using multidimensional arrays

[Reeza]

You should also add the IDLabel so the station names look 'nice' in reports:

proc transpose data=have out=want;

by mon;

id stations;

idlabel stations;

var mthavg;

run;

[KachiM]

It is difficult to get your SAS data set. Better for me is the ASCII file.