SD0059: Define.xml/dataset variable type mismatch

m Marianne

on June 21, 2013

Hi,

In our sponsor defined domains/sponsor defined added variables we get this error telling that the type does not match between the dataset and the define.xml. As far as we can see it does, but are there something other than just type/length this check does?

KR Marianne Carames

Forums: SDTM

s Sergiy

on June 21, 2013

Hi Marianne, It's difficult

Hi Marianne,

It's difficult to do diagnostics without knowing all details on your issue.

However the most common reason for SD0059 error is a usage of SAS variable types "Num" and "Char" instead of ODM expected values like "text", "integer", "float" and "datetime".

Please note that the define.xml standard is case-sensitive, and it leads to another most common source of such errors. E.g., "text" and "Text" are two different values.

Kind Regards,

Sergiy

f Fang

on September 18, 2013

SD0059

Sergiy,

Is it true that SD0059 is expecting that the Define.XML to use the ODM type, and not use the SAS var type?

Thanks,

-FD

s Sergiy

on September 19, 2013

Hi Fang, Yes, it's correct.

Hi Fang,

Yes, it's correct. Define.xml structure and content should be compliant with ODM standard. It means, that you have to specify variable types in terms of "text", "datetime", "float", "integer", etc., rather than to use SAS var type values directly.

Kind Regards,

Sergiy