Link to home
Start Free TrialLog in
Avatar of shieldsco
shieldscoFlag for United States of America

asked on

SAS 9.4 Query Between Dates

I'm using the SAS query however it's not returning the records between the two dates.
All records are returned.


Select TASKAPL .0FC_Nf1, TASKS .MMBR_FULL_NM , TASKS.SUPRYSR_FULL_NM,
TASKAPL.ALJ_APL_NUM, TASKS.TASK_ASGNED_DT, TASKS.INI T IATED_DT,
TASKS.CMPLTD_DT, TASKS.TASK_TYPE_NM. TASKS.TASK_STATUS_NM,
TASKAPL.WRKFLM_S TA TE_NM, TASKAPL.PRCSG_M THD_NM,
TASKAPL.CMPL T_RQS T_RCUD_D T, TASKAPL.CRNT_AGE,
TASKAPL.FY_CMPLT_REQ_RCVD_DT, TASKAPL.APLNT_FULL_NM, TASKAPL.BENE_CNT, TASKAPL.CLM_CNT, TASKAPL.DLM_DT, TASKAPL.COMB INED_ID,
TASKAPL.COMB INED_NAME, TASKAPL.COMB INED_APL_PAREN T_IND,
TASKAPL.FY_RQST_RCUD_DT, TASKAPL.FY_DLM_DT from TASKS.TASKAPL LEFT JOIN TASKS.TASKS
ON TASKAPL. APPEALED =TASKS . APPEAL_ ID where TASKS.TASK_STATUS_NM IN( ’Closed' )
OR TASKS.TASK_STATUS_NM INC (’Not Completed' )
AND TASKS.CMPLTD_DT Between '010ct2019’d and ’30Sep2020'd;

ASKER CERTIFIED SOLUTION
Avatar of Ian
Ian
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial