HI I have hundred of variable. I provide a smaller dataset for the illustration purpose.And I want to make it through Arrays.I want to take every third variable from the array of variables Dfm and bal series starting from first varible. Thanks in advance. Data I_have; input Dfm1$ Dfm2$ Dfm3$ Dfm4$ Dfm5$ Dfm6$ Dfm7$ Dfm8$ Dfm9$ Dfm10$ Dfm11$ Dfm12$ Dfm13$ Dfm14$ bal1 bal2 bal3 bal4 bal5 bal6 bal7 bal8 bal9 bal10 bal11 ball2 bal13 ball4; Datalines ; Y Y Y Y Y N Y N Y N Y Y N y 22 12 14 151 56 58 56 89 87 45 63 26 111 78 ; ; run; Data I_wanna; input Dfm1$ Dfm4$ Dfm7$ Dfm10$ Dfm13$ bal1 bal4 bal7 bal10 bal13; Datalines ; Y Y Y N N 22 151 56 45 111 ; run ;
... View more