In this case, the description doesn't necessarily match the Terms in the rule. The rule ensures that your datetime variable has a FORMAT of DATETIME only. I tested it with DATETIME7, DATETIME13 and both are valid. We plan on removing these validations next release since all ADAM dates,datetimes and time variables are stored number (type="Num"). How the sas .xpt file displays them visually to the user is not important to the actual analysis. if the same file were sent as a text file, this rule would not run.
ID
Type
Variable
Terms
Message
Description
AD0041
Error
FORMAT
YYMMDD,MMDDYY
* DT does not have …. required SAS Date format
SAS format ... must be YYYYMMDD. or YYMMDD10.
AD0042
Error
FORMAT
TIME
* TM does not have ... required SAS time format
SAS format … must be HH:MM:SS.SS.
AD0043
Error
FORMAT
DATETIME
* DTM does not have ... required SAS Datetime format
SAS format … must be YYYYMMDDHH:MM:SS.SS. or YYMMDD10HH:MM:SS.SS
SAS Display FORMAT AD0041, AD0042, AD0043
Hi Lehrkam. thanks for the feedback. We received similar comments on rule 41 and agree that this is an issue. http://www.opencdisc.org/projects/validator/rules/ad0041
Short answer = DATETIME
In this case, the description doesn't necessarily match the Terms in the rule. The rule ensures that your datetime variable has a FORMAT of DATETIME only. I tested it with DATETIME7, DATETIME13 and both are valid. We plan on removing these validations next release since all ADAM dates,datetimes and time variables are stored number (type="Num"). How the sas .xpt file displays them visually to the user is not important to the actual analysis. if the same file were sent as a text file, this rule would not run.
Thanks
Many thanks for your quick reply. I prefer to use the is8601dt format ( YYYY-MM-DDTHH:MM:SS.SS) as used in SDTM.