https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/569688#M160580 Your shown input data only has LENGTH, no WEIGHT values. The answer is the same as the one to your previous question, a double transpose or multiple transposes + merging the results. Fri, 28 Jun 2019 03:02:17 GMT Reeza 2019-06-28T03:02:17Z https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/569686#M160578 <P>I have a data set like this&nbsp;</P> <PRE> 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 . </PRE> <P>I want it to be like this&nbsp;</P> <PRE> L o L W L W L W L W c e e e e e e e e a n i n i n i n i t D g g g g g g g g i a t h t h t h t h o t h t h t h t h t n e 1 1 2 2 3 3 4 4 Cole Pond 02JUN95 31 0.25 32 0.30 32 0.25 33 0.30 Cole Pond 03JUL95 33 0.32 34 0.41 37 0.48 32 0.28 Cole Pond 04AUG95 29 0.23 30 0.25 34 0.47 32 0.30 Eagle Lake 02JUN95 32 0.35 32 0.25 33 0.30 . . Eagle Lake 03JUL95 30 0.20 36 0.45 . . . . Eagle Lake 04AUG95 33 0.30 33 0.28 34 0.42 . . </PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><FONT size="1 2 3 4 5 6 7"><EM>edit: via Reeza - fix misspelling in the subject line</EM></FONT>&nbsp;</P> Fri, 28 Jun 2019 03:03:21 GMT https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/569686#M160578 Dhana18 2019-06-28T03:03:21Z https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/569688#M160580 Your shown input data only has LENGTH, no WEIGHT values. The answer is the same as the one to your previous question, a double transpose or multiple transposes + merging the results. Fri, 28 Jun 2019 03:02:17 GMT https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/569688#M160580 Reeza 2019-06-28T03:02:17Z https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/570209#M160775 not exactly. one of answer (from grand advisor) seems working. Thank you Grand Advisor. Mon, 01 Jul 2019 12:45:32 GMT https://communities.sas.com/t5/SAS-Programming/complex-transpose/m-p/570209#M160775 Dhana18 2019-07-01T12:45:32Z