I am trying to find how many days occurred between datebegin_14 and April 30, 2017. This generates no error but also no results for the field duration I am trying to use to do this. I assume I am specifying the data April 30 2017 wrong, but I do not know the right answer.
PROC SQL;
CREATE TABLE SASUSER.out3 AS
SELECT t1.CUSTOMERID,
t1.CASENUMBER,
t1._TEMG001,
t1.COUNSELOR_PRI,
t1.DATEBEGIN_14,
/* Duration */
(INTCK('day',t1.DATEBEGIN_14, '30APR2017'd)) LABEL="Duration" AS Duration,
t1.STATUSCASE,
t1.DISTRICT_PRI,
t1.UNITID_PRI,
t1.INDIVIDUALLNAME,
t1.INDIVIDUALFNAME,
t1.STAFFLNAME,
t1.STAFFFNAME
FROM SASUSER.OUT2 t1;
QUIT;
PROC SQL;
CREATE TABLE SASUSER.out3 AS
SELECT t1.CUSTOMERID,
t1.CASENUMBER,
t1._TEMG001,
t1.COUNSELOR_PRI,
t1.DATEBEGIN_14,
/* Duration */
(INTCK('day',t1.DATEBEGIN_14, '30APR2017'd)) LABEL="Duration" AS Duration,
t1.STATUSCASE,
t1.DISTRICT_PRI,
t1.UNITID_PRI,
t1.INDIVIDUALLNAME,
t1.INDIVIDUALFNAME,
t1.STAFFLNAME,
t1.STAFFFNAME
FROM SASUSER.OUT2 t1;
QUIT;