When they say, “This timing variable has to be in numeric format” in SAS.

  • Post author:
  • Post category:SAS

In the CDISC Analysis Data Model Implementation Guide, when it comes to the timing variable, it says:

“Numeric date, time, and datetime variables should be formatted, so as to be human-readable with no loss of precision. “

So how do we actually accomplish this in SAS?

Taking the dataset from LB (Laboratory Test Results) as an example, the LBDTC (Date/Time of Specimen Collection) is populated in the format 2023-05-05T09:40.

Try the following code; the length of LBDTC has to be taken into consideration.

ADT=input(subset(lbdtc,1,10),yymmdd10.);

if length(lbdtc)>10 then atm=input(subset(lbdtc,12,5),time8.);

else atm=.;

if length(lbdtc)>10 then adtm=input(strip(lbdtc)||’:00′,e8601dt.);

else adtm=.;