1777 Sentry Parkway West
Building 17, Suite 405
Blue Bell, PA 19422
+1 (888) 507-2270
AD0043: SAS Format in *DTM variables
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.
| 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 |
Which SAS format fullfill the check AD0043? (date/time format = YYYYMMDDHH:MM:SS.SS. or YYMMDD10HH:MM:SS.SS)