topic Re: BASE sas in SAS Programming

Create column from last non-missing value

Bhargav_Movva — Sat, 30 Jun 2018 01:34:21 GMT

Re: BASE sas

Bhargav_Movva — Thu, 28 Jun 2018 09:40:22 GMT

please make a correction -->fourth record from last should contain 44 as base value instead of 120

Re: BASE sas

RW9 — Thu, 28 Jun 2018 09:49:55 GMT

So its just retaining the row with the word screening? Then its simple:

data want;
  set lab;
  retain base;
  if visit="screening" then base=lbstresn;
run;

However I suspect its more complicated than that. I assume your creating an ADaM dataset, so want a baseline flag. To do this first create a dataset with all the baseline values, then merge this back to your original data. E.g.

data base (keep=subjid lbtest base_val (rename=(lbstresn=base_val));
  set lab;
  where visit="screening";
run;

data want;
  merge lb base;
  by subjid lbtest;
run;

You can then alter that to keep other variables, do more compicated baseline calculations, LOCF etc.

Re: BASE sas

Astounding — Thu, 28 Jun 2018 11:02:27 GMT

Since you need to inspect both the baseline and predose values, two loops can do the trick:

data want;

do until (last.subjid);

set have;

by subjid;

if visit in ('screening', 'predose') and lbstresn > . then base = lbstresn;

end;

do until (last.subjid);

set have;

by subjid;

output;

end;

run;

Re: BASE sas

Bhargav_Movva — Thu, 28 Jun 2018 17:18:42 GMT

hey thank you so much it worked.But still i didnt understood the trick of two loops .please explain.Thanks

Re: BASE sas

Astounding — Thu, 28 Jun 2018 17:34:11 GMT

The top loop reads through all the observations for a subject. Whenever it finds a nonmissing value (for selected visit types) it updates BASE. So BASE is established at that point.

Then the bottom DO loop reads exactly the same observations. (When a DATA step contains multiple SET statements, each one operates independently of the other.) It outputs those observations, along with the previously calculated value for BASE.

If you want to find more examples like this, you can search for DOW loops.