Dear RamKumar, find below the answer: 1- for transpose the following example for your data: data test; input cust $ account $ balance:comma12.2; cards; Smith checking $1,000.00 Smith Savings $4,000.00 Smith mortgage $150,000.00 Smith credit_card $500.00 Jones checking $973.78 Jones savings $2,613 Jones Mortgage . Jones credit_card $140.48 ; run; PROC SORT DATA=WORK.TEST(KEEP=balance account cust) OUT=WORK.SORTTempTableSorted ; BY cust; RUN; PROC TRANSPOSE DATA=WORK.SORTTempTableSorted OUT=WORK.TRNSTransposedTEST(LABEL="Transposed WORK.TEST") LET NAME=Source LABEL=Label ; BY cust; ID account; VAR balance; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT; 2- Proc Cor is the best procedure to calculate the correlation as you need.
... View more