need help with TEAE flag logic

sasg — Tue, 20 Feb 2018 00:00:12 GMT

Hi All,

I need to create flag for below logic in SAS SDTM AE Domain. Could you please help me with the logic.

if aestdtc<rfstdtc and patient has another record with same AEDECOD and AETERM , and AESEV increased need to flag as Y.

I'm new to sas need a sample code for this logic.

Thanks in advance!!!

Re: need help with TEAE flag logic

Astounding — Tue, 20 Feb 2018 01:05:25 GMT

Presumably you have a variable representing the date. You would need to put the data in the proper order first:

proc sort data=have;

by patient aedecod aeterm date;

run;

Then check your conditions:

data want;

set have;

by patient aedecod aeterm;

prior_severity = lag(aesev);

if first.aeterm=0 and (aesev > prior_severity) and (aestdtc < rfstdtc) then flag='Y';

drop prior_severity;

run;

As someone relatively new to SAS, there are several topics you will need to learn, to understand the program. Start with the addition of a BY statement following the SET statement. It's something you will use regularly.

First, however, see if this flags the observations that you are hoping to flag.

topic need help with TEAE flag logic in SAS Health and Life Sciences

need help with TEAE flag logic

Re: need help with TEAE flag logic