code help

[rashmirao99]

Hi

I have a vital signs raw data. I have a date column and vital signs test column. there are 5 tests per subject. There is only one date is given for one test. I need to fill the same date for all the tests per subject. Need help with this logic.

the data looks like this:

date                       test

11/07/2017            

          .                   Height

          .                  DBP

           .                  SBP

                             PULSE

                             TEMP  

Thanks.

Rashmi.

[Reeza]

*Try using Retain to keep the variable across the rows and assigning it when new;

data want;

set have;

retain new_date;

if not missing(date) then new_date = date;

run;

---

@rashmirao99 wrote:

Hi

I have a vital signs raw data. I have a date column and vital signs test column. there are 5 tests per subject. There is only one date is given for one test. I need to fill the same date for all the tests per subject. Need help with this logic.

the data looks like this:

date                       test

11/07/2017            

          .                   Height

          .                  DBP

           .                  SBP

                             PULSE

                             TEMP  

Thanks.

Rashmi.

---

[novinosrin]

where is the subject column?

data want;

set have;

by subject;

retain _date;

if first.subject then call missing(_date);

if not missing(date) then _date=date;

else date=_date;

run;