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.
| 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 |