topic How do you select a cell in dataset using their row and column? in New SAS User

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

lila_lmp — Sat, 01 Jan 2022 08:19:19 GMT

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?

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

Patrick — Sat, 01 Jan 2022 08:48:30 GMT

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;

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

lila_lmp — Sat, 01 Jan 2022 09:25:17 GMT

Thank you Patrick !!!

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

Ksharp — Sat, 01 Jan 2022 09:36:27 GMT

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;