Looking for members with over X$ claims in 2014 This query is pulling the members but is not filtering only to 2014, do I not have the date in the correct place? proc sql; create table TOTAL_PAID as SELECT DISTINCT MBR_SYS_ID, SUM(SRC_PD_AMT) as TOTAL_CLAIMS FROM DB2.INS_CLAIM A WHERE A.CLM_PD_DT >= '01JAN2014'd and A.SRVC_CURR_IND = 'Y' and A.ENCTR_CD NOT IN('3','4','U') and A.TRANS_CD ='00' group by MBR_SYS_ID having TOTAL_CLAIMS > 100000; quit;
... View more