Various computed columns attempted and results shown above. DT SUBSTRI(t1.data,1,10) DT2 INPUT(SCAN(t1.date,1," "),ANYDTDTE.) DT3 (output matches slicing via SUBSTR) SCAN(t1.date,1," ") DT4 INPUT(SCAN(t1.date,1" "),DDMMYYw.) DT5 INPUT(SUBSTR(t1.date,1,10),DDMMYYw.) DT6 PUT(INPUT(SCAN(t1.date,1" "),DDMMYYw.)YYMMDD10.)
... View more