try this and you might find your data easier to work with:
data foo;
input id y_1601 y_1602 y_1603 y_1604 y_1605 y_1606 y_1607 y_1608 y_1609 y_1610 y_1611 y_1612;
datalines;
1 111 111 111 111 . . . . . . . .
2 23 . 111 111 111 . . . . . 111 111
3 52 111 111 111 111 87 87 111 111 111 111 111
run;
PROC SQL;
CREATE VIEW WORK.SORTTempTableSorted AS
SELECT T.y_1601, T.y_1602, T.y_1603, T.y_1604, T.y_1605, T.y_1606, T.y_1607, T.y_1608, T.y_1609, T.y_1610, T.y_1611, T.y_1612
FROM WORK.FOO as T
;
QUIT;
PROC TRANSPOSE DATA=WORK.SORTTempTableSorted
OUT=WORK.TRNSTransposed(LABEL="Transposed WORK.FOO")
PREFIX=Column
NAME=Source
LABEL=Label
;
VAR y_1601 y_1602 y_1603 y_1604 y_1605 y_1606 y_1607 y_1608 y_1609 y_1610 y_1611 y_1612;
RUN; QUIT;
... View more
