SD0080: AE start date is after the latest Disposition date

a Ajay

on November 26, 2018

Hi,

We are getting SD0080 warning when Disposition date is 13MAR2018 and AE start date is 2018.

I was wondering how P21 handle the partial date in this case. Is it considering 2018 as 31DEC2018?

We had also tested with AE start date=2017 and the warning was not present.

Any guidance will be helpful here.

Thanks

Ajay Gupta

Forums: SDTM

s Sergiy

on November 26, 2018

Dates must follow ISO 8601 format

Hi Ajay,

Dates must follow ISO 8601 format. For example, "2018-03-13" instead of "13MAR2018" in your example.

Kind Regards,

Sergiy

a Ajay

on December 12, 2018

Hi Sergiy, The date is in…

Hi Sergiy,

The date is in ISO format e.g. 2018-03-13. But, we are still getting above warning.

Any guidance will be helpful.

Thanks

Ajay

s Sergiy

on December 12, 2018

Only a part of Date/Time present in both variables is used

Hi Ajay,

In case of partially missing Date/Time, SD0080 check compares only a part of Date/Time values which is populated in both variables. For example, if "2018-03-13" and "2018" values are present in two domains, only a Year portion of the first value is used for comparison.

Implementation of this check is quite challenging due to conflicting preferences from different users.

Some people want to avoid false-negative results and request SD0080 to be modified producing Warning messages in the example above.
Other people want to avoid false-negative messages and keep a current algorithm for SD0080 rule.

Kind Regards,

Sergiy

a Ajay

on January 15, 2019