Hi,   I'm not sure why I get a syntax error.  It says I'm missing an extra paren.  This is extracting data from an Oracle database, however, this same exact macro works in teradata.   This is the macro code, I'm using the %bquoute to help avoid an error about more positional parameters than defined. %macro looper(_tblname, _varnme); *-----------------------------------------------------* IDENTIFY CLAIMS/ENCOUNTERS (XCELYS PROFESSIONAL) BY ICD9 DIAGNOSIS CODES *-----------------------------------------------------*; Proc SQL; /*CONNECT to ORACLE (path= 'ISARNP.world' );*/ Create Table &_tblname as /* VARIABLE NAMES USED IN HEDIS PROGRAMMING: */ (Select Distinct /* ----------------------------------------- */ A.clm_nb /* CLM_NBR */ ,A.clm_sts_cd ,A.src_sys_cd ,A.frst_svc_dt /* SVC_B_DT */ ,A.prmy_diag_cd ,D.indvd_id_nb /* INDV_HRN */ ,E.plc_of_svc_cd /* POS_CD */ ,B.diag_lne_nb ,B.icd_diag_cd /* DIAG_CD */ From CDW.PROF_CLM_HDR A /*INNER JOIN CDW.prof_CLM_HDR_PRVDR F on A.prof_clm_ik = F.prof_clm_ik and A.rgn_cd = F.rgn_cd and A.src_sys_cd = F.src_sys_cd*/ INNER JOIN CDW.PROF_CLM_DTL C on A.prof_clm_ik = C.prof_clm_ik and A.rgn_cd = C.rgn_cd and A.src_sys_cd = C.src_sys_cd INNER JOIN CDW.PROF_CLM_INDVD D on A.prof_clm_ik = D.prof_clm_ik and A.rgn_cd = D.rgn_cd and A.src_sys_cd = D.src_sys_cd INNER JOIN CDW.PROF_CLM_PLC_OF_SVC E on A.prof_clm_ik = E.prof_clm_ik and A.rgn_cd = E.rgn_cd and A.src_sys_cd = E.src_sys_cd INNER JOIN CDW.PROF_CLM_HDR_DIAG B on A.prof_clm_ik = B.prof_clm_ik and A.rgn_cd = B.rgn_cd and A.src_sys_cd = B.src_sys_cd Where A.src_sys_cd = 'Xcelys ROC' and A.rgn_cd ='CO' and A.frst_svc_dt Between &BEGDATE AND &ENDDATE and A.most_rcnt_clm_ver_in_cd='Y' and D.indvd_role_cd = 'Patient' /*and F.prvdr_role_cd = 'Rendering - Billing'*/ and A.intrl_extl_cd = 'External' /*-- TO FILTER BY DIAGNOSIS --*/ and B.clsfn_schm_cd in ('ICD-9','ICD-10') and B.icd_diag_cd in %str(&&_varnme.) ); Quit; %mend; %looper(CHL_PROF_DIAG1, %bquote(&TBL_B_DIAG_SEXW5A_CDWX.)); ... View more

Hello,       I can't think of a solution. I'm a HEDIS measure analysis, where we have to track when a patient has been on 2 or more medications during the year. I've been able to identify the first sequence where they were on the meds, but I'm having problems getting the subsequent dates when they were on it.  I just can't seem to think of a way to get to it (having "writers block"). So,  the data looks like this:   PatID      Med         Disp dt      Run Out date     A           abilify       1/7/2014       4/17/2014     A           latuda       1/22/2014     7/5/2014     A           abilify       5/16/2014      6/17/2014     A           latuda       5/20/2014      10/17/2014     A           risp           8/1/2014      9/2/2014     B           clan          2/20/2014     5/2/2014     B           zipra         2/24/2014    4/24/2014     B           risp           5/6/2014      6/7/2014     B           clan           6/10/201      7/15/2014   The final data should have these data in it: PatID      Med         Disp dt      Run Out date     A           abilify       1/7/2014       4/17/2014     A           latuda       1/22/2014     7/5/2014     A           abilify       5/16/2014      6/17/2014     A           latuda       5/20/2014      10/17/2014     B           clan          2/20/2014     5/2/2014     B           zipra         2/24/2014    4/24/2014   The patients where they had 2 or more meds during the year and excluding where they didn't. Any ideas ?   Thank you in advance. ... View more