Staff_id Product Pts_Earned
182715 EPE 150
182825 EASB 22200
182825 EIKPA 1056
182825 EKD 810
182825 EPE 2400
182825 ESM 30
From the above dataset, i got the following answer.
Staff_id EASB EIKPA EKD EPE ESM
182715 150
182825 22200 1056 810 2400 30
What happend to 182715, it supposed to be EPE, not EASB?
Can anyone help?
My code:
PROC TRANSPOSE DATA=I OUT=TEST(RENAME=(COL1=EASB COL2=EIKPA COL3=EKD COL4=EPE COL5=ESM)) NAME=PRODUCT;
BY STAFF_ID;
VAR PTS_EARNED;
LABEL PRODUCT = 'PRODUCT';
RUN;
... View more