SAS Macro | Iterative Processing

[Sanchit]

Need help with the following problem statement:

A macro to create the following dataset

var_1 var_2 ........var_9 var_10

1 4 ........81 100

1 8 ......729 1000

Thanks in Advance!

[Kurt_Bremser · Accepted solution]

No macro needed, just a data step with loops and an array:

data want;
array vars{*} var1-var10;
do n = 2 to 3;
  var1 = 1;
  do i = 2 to dim(vars);
    vars{i} = i ** n;
  end;
  output;
end;
drop i n;
run;

[Sanchit]

Many Thanks!