This data set is the output data set, FISHLENGTH. For each BY group in the original data set, PROC TRANSPOSE creates four observations, one for each variable that it is transposing. Missing values appear for the variable Measurement (renamed from COL1) when the variables that are being transposed have no value in the input data set for that BY group. Several observations have a missing value for Measurement. For example, in the last observation, a missing value appears because the input data contained no value for Length4 on 04AUG95 at Eagle Lake.
Fish Length Data for Each Location and Date 1
Location Date _NAME_ Measurement
Cole Pond 02JUN95 Length1 31
Cole Pond 02JUN95 Length2 32
Cole Pond 02JUN95 Length3 32
Cole Pond 02JUN95 Length4 33
Cole Pond 03JUL95 Length1 33
Cole Pond 03JUL95 Length2 34
Cole Pond 03JUL95 Length3 37
Cole Pond 03JUL95 Length4 32
Cole Pond 04AUG95 Length1 29
Cole Pond 04AUG95 Length2 30
Cole Pond 04AUG95 Length3 34
Cole Pond 04AUG95 Length4 32
Eagle Lake 02JUN95 Length1 32
Eagle Lake 02JUN95 Length2 32
Eagle Lake 02JUN95 Length3 33
Eagle Lake 02JUN95 Length4 .
Eagle Lake 03JUL95 Length1 30
Eagle Lake 03JUL95 Length2 36
Eagle Lake 03JUL95 Length3 .
Eagle Lake 03JUL95 Length4 .
Eagle Lake 04AUG95 Length1 33
Eagle Lake 04AUG95 Length2 33
Eagle Lake 04AUG95 Length3 34
Eagle Lake 04AUG95 Length4 .
|