I made a program that I hope will help solve your problem. data exemplo; input Date $ 1-7 Y1 $ 8-13 Y2 $ 14-19 Y3 $ 20-25 Y4 $ 26-26 Y5 $ 27-33; datalines; 1Apr09 1.85 0.8 4.62 5.46 2Apr09 2.12 9.8 7.09 1.61 6Apr09 -3.14 2.5 11.63 10.48 8Apr09 1.76 4.39 -0.97 -4.23 9Apr09 -0.68 11.09 2.22 2.69 13Apr09 0.75 2.63 1.76 1.34 15Apr09 3.85 4.22 7.12 4.25 16Apr09 0.36 -5.08 -5.17 -4.33 17Apr09 -0.9 2.74 0.17 -1.18 20Apr09 1.25 -0.53 0.17 0.71 21Apr09 -0.82 3.74 2.78 0.24 22Apr09 5.26 -3.52 1.03 2.4 23Apr09 0.3 -0.15 6.44 0.6 24Apr09 4.88 0 14.55 3.36 27Apr09 -2.98 0.77 -4.29 -3.61 28Apr09 -2.32 -3.92 -7.17 -5.24 29Apr09 1.44 2.95 6.54 4.61 4May09 0.38 3.22 9.99 4.88 5May09 -0.21 -0.8 -2.37 1.53 6May09 -2.09 0.09 -1.31 -2.1 7May09 -2.44 0.09 1.03 2 8May09 -3.55 -2.33 -4.47 0.77 ; data teste (drop= i Y1-Y5); set work.exemplo; array X{5} X1-X5; array Y{5} Y1-Y5; do i=1 to 5; X{i}=Y{i}*1; end; RUN;
... View more