I ran this code
PROC SQL;
CREATE TABLE SASUSER."tab1"n AS
SELECT t1.VRID,
t1.CASE,
t1.STATUS,
t1.Area,
t1.Unit,
t1.DB10,
t1.DUR10,
t1.DURS10,
t1.DB12,
t1.DBCLO,
/* DIFF1012 */
(DATDIF(t1.DB10, t1.DB12, 'ACT/ACT')) AS DIFF1012,
/* D10CLO */
(DATDIF(t1.DB10, t1.DBCLO, 'ACT/ACT')) AS D10CLO
FROM WORK.CYCLETIME5 t1;
QUIT;
and get
NOTE: Invalid argument to function DATDIF. Missing values may be generated.
NOTE: Invalid argument to function DATDIF. Missing values may be generated.
I don't see any invalid argument there. I do get results.
PROC SQL;
CREATE TABLE SASUSER."tab1"n AS
SELECT t1.VRID,
t1.CASE,
t1.STATUS,
t1.Area,
t1.Unit,
t1.DB10,
t1.DUR10,
t1.DURS10,
t1.DB12,
t1.DBCLO,
/* DIFF1012 */
(DATDIF(t1.DB10, t1.DB12, 'ACT/ACT')) AS DIFF1012,
/* D10CLO */
(DATDIF(t1.DB10, t1.DBCLO, 'ACT/ACT')) AS D10CLO
FROM WORK.CYCLETIME5 t1;
QUIT;
and get
NOTE: Invalid argument to function DATDIF. Missing values may be generated.
NOTE: Invalid argument to function DATDIF. Missing values may be generated.
I don't see any invalid argument there. I do get results.