I had trouble getting any of the examples to work, so I took the easy route and did it the amateurish way just so I could get it done. I thought I would share.
Thank you to everyone for your help. Sorry for the all caps, I have to program in all CAPS here.
***************************************************************;
PROC TRANSPOSE DATA=E2 OUT=ONE;
VAR _ALL_;
RUN;
DATA TWO ; SET ONE;
_NAME_ = TRANWRD(_NAME_,'E4','E1');
_NAME_ = TRANWRD(_NAME_,'E5','E2');
_NAME_ = TRANWRD(_NAME_,'E6','E3');
DATA THREE; SET TWO;
RENAME _NAME_ = NEW;
PROC TRANSPOSE DATA=THREE OUT=FOUR;
ID NEW;
IDLABEL _LABEL_;
VAR COL1 COL2;
PROC PRINT;
RUN;
Message was edited by: statadm
Message was edited by: statadm
... View more