How do you select a cell in dataset using their row and column?

[lila_lmp]

Hello,

I want to ba able to use this in a loop like:

data name; set dataset1;
do n = 1 to 100 ; 
y = row n+1 value of a certain variable - row n value of that variable;
output ;
end;
run;

Please can you help me writing y?

[Patrick · Accepted solution]

Below one option how to do this.

data have;
  do i=1 to 200;
    myvar+i*i;
    output;
  end;
run;

data want;
  set have(obs=100);
  set have(firstobs=2 keep=myvar rename=(myvar=myvarPlusOne));
  y=myvarPlusOne-myvar;
run;

[lila_lmp]

Thank you Patrick !!!

[Ksharp]

data have;
 set sashelp.heart;
run;

%let col=4;
%let row=6;

data _null_;
set sashelp.vcolumn(where=(libname='WORK' and memname='HAVE' and varnum=&col.));
call execute(cat('data want;set have;if _n_= ',&row.,';keep ',name,';run;'));
run;