topic Re: SAS Macro | Iterative Processing in SAS Studio

SAS Macro | Iterative Processing

Sanchit — Wed, 29 Jun 2016 09:02:59 GMT

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 — Wed, 29 Jun 2016 09:59:03 GMT

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 — Wed, 29 Jun 2016 10:35:33 GMT

Many Thanks!