For the below table, I need the first combination of "A, 194 and 2" to be duplicated or repeated 23 times and the second combination to be duplicated or repeated 14 times. This code worked on another example but failed on this one. Any help? do _N_= 1 to Domain; output; end;   Error: "Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid."   NAME BR_CODE BKT Domain A 194 2 23 A 194 3 14 A 194 4 8   Repeated 23 times...   BR_CODE BKT Domain A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 23 A 194 2 …. A 194 2 …. A 194 2 …. A 194 2 …. ... View more

The first "M" array gets the average of all numeric variables in the dataset. There's a total of 74 variables: X,Y,Z,V,P,L...etc However, I would like to get the average of only that last 6 variables, i.e. from 69 - 74th variable. I tried creating another array "L" where I identified the do statement to start from (i=69 to i+5). The average function does not work still. Any help? data XXX; Set YYYY; array M(*) _numeric_; do i=1 to dim(M); TOTAVG=mean(of M(*)); drop i; end;   array L(*) _numeric_; i=69; do n=i to i+5; AVG2=mean(of L[n]); end; run; ... View more