AD0043: SAS Format in *DTM variables

m Matthias

on February 3, 2011

Which SAS format fullfill the check AD0043? (date/time format = YYYYMMDDHH:MM:SS.SS. or YYMMDD10HH:MM:SS.SS)

Forums: ADaM

m Michael

on February 3, 2011

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