topic Re: Dynamic variable name in SAS Programming

Dynamic variable name

Rakeon — Mon, 13 Mar 2017 18:30:01 GMT

Hi ,
I create this data set:

data temp;
 do i=1 to 5;
    a1=999;
    a2=999;
    a3=999;
    ...
   a10 =999;
   output;
 end;
run;

is there a better solution that create a second do-loop inside the first do-loop?

for example like this:

data temp;
 do i=1 to 10;
  do j=1 to 10;
   call symput("index",j);
   a&index=999;
  end;
  output;
 end;
run;

The last example, doesn't work, because it doesn't recognize the index variable.

Is there some solution?

Re: Dynamic variable name

Kurt_Bremser — Mon, 13 Mar 2017 18:33:48 GMT

data temp;
array vars {*} a1-a10;
do i = 1 to 5;
  do j = 1 to dim(vars);
    vars{j} = 999;
  end;
end;
drop j;
run;

Re: Dynamic variable name

Astounding — Mon, 13 Mar 2017 18:43:31 GMT

SInce your new variables are constant, a better solution would not nest loops:

data want;

retain a1-a10 999;

do i=1 to 5;

output;

end;

run;

To answer your original question, no there is no solution. SAS does not let you change what "a&index" resolves to, as the DATA step executes.

Re: Dynamic variable name

Rakeon — Mon, 13 Mar 2017 19:37:28 GMT

thanks!!!

Re: Dynamic variable name

Reeza — Mon, 13 Mar 2017 19:44:41 GMT

@Rakeon please mark the question as answered.

Re: Dynamic variable name

rogerjdeangelis — Mon, 13 Mar 2017 23:21:04 GMT

A slightly more interesting problem;

Generating 10 observations with a random number of variables

Minimum number of variables is 1(a1) max is 5(a1-a5)

This is trivial in IML or R.

  n <- as.integer(5*runif(1)) +1;
  runif(n);

> n <- as.integer(5*runif(1)) +1;
  runif(n);
[1] 0.13442659 0.07485726 0.22734428 0.84948492
>

HAVE a random number between 1 and 5
========================================

    n=int(5*uniform(5739)) + 1;

  Note N could be meta data

WANT  Suppose the random n is 3
===============================

Up to 40 obs from want total obs=10

Obs       A1         A2         A3

  1    0.39041    0.51861    0.19275
  2    0.13243    0.54758    0.86705
  3    0.89960    0.18865    0.46915
  4    0.62604    0.15337    0.34970
  5    0.50958    0.16918    0.61778
  6    0.81300    0.88339    0.36657
  7    0.79296    0.56760    0.66014
  8    0.37525    0.19073    0.66443
  9    0.70009    0.31034    0.72677
 10    0.56065    0.93989    0.41765

SOLUTION
========

data _null_;
  n=int(5*uniform(5739)) + 1;
  call symputx('dim',put(n,3.));
   rc=dosubl('
      data want(drop=rec i);
        array a[&dim.] a1-a&dim;
        do rec=1 to 10;
           do i=1 to &dim;
              a[i]=uniform(5733);
           end;
           output;
        end;
      run;quit;
   ');
  stop;
run;quit;