https://communities.sas.com/t5/SAS-Studio/please-see-the-error/m-p/543764#M7215 <P>distinct (smb.PRODUCT_ID)<BR />,smb.Year<BR />,smb.AON<BR />,smb.CELL_CALL_CNT_M1<BR />,smb.CELL_CALL_CNT_M2<BR />,smb.CELL_CALL_CNT_M3<BR />,smb.CELL_CALL_CNT_M4<BR />,smb.CELL_CALL_CNT_M5<BR />,smb.CELL_CALL_CNT_M6<BR />,smb.CELL_CALL_SEC_M1<BR />,smb.CELL_CALL_SEC_M2<BR />,smb.CELL_CALL_SEC_M3<BR />,smb.CELL_CALL_SEC_M4<BR />,smb.CELL_CALL_SEC_M5<BR />,smb.CELL_CALL_SEC_M6<BR />,smb.CELL_CALL_avg_dur_M1<BR />,smb.CELL_CALL_avg_dur_M2<BR />,smb.CELL_CALL_avg_dur_M3<BR />,smb.CELL_CALL_avg_dur_M4<BR />,smb.CELL_CALL_avg_dur_M5<BR />,smb.CELL_CALL_avg_dur_M6<BR />,smb.CELL_USAGE_CHARGE_AMT_M1<BR />,smb.CELL_USAGE_CHARGE_AMT_M2<BR />,smb.CELL_USAGE_CHARGE_AMT_M3<BR />,smb.CELL_USAGE_CHARGE_AMT_M4<BR />,smb.CELL_USAGE_CHARGE_AMT_M5<BR />,smb.CELL_USAGE_CHARGE_AMT_M6<BR />,smb.DATA_CALL_CNT_M1<BR />,smb.DATA_CALL_CNT_M2<BR />,smb.DATA_CALL_CNT_M3<BR />,smb.DATA_CALL_CNT_M4<BR />,smb.DATA_CALL_CNT_M5<BR />,smb.DATA_CALL_CNT_M6<BR />,smb.DATA_CALL_SEC_M1<BR />,smb.DATA_CALL_SEC_M2<BR />,smb.DATA_CALL_SEC_M3<BR />,smb.DATA_CALL_SEC_M4<BR />,smb.DATA_CALL_SEC_M5<BR />,smb.DATA_CALL_SEC_M6<BR />,smb.DATA_CALL_avg_dur_M1<BR />,smb.DATA_CALL_avg_dur_M2<BR />,smb.DATA_CALL_avg_dur_M3<BR />,smb.DATA_CALL_avg_dur_M4<BR />,smb.DATA_CALL_avg_dur_M5<BR />,smb.DATA_CALL_avg_dur_M6<BR />,smb.DATA_USAGE_CHARGE_AMT_M1<BR />,smb.DATA_USAGE_CHARGE_AMT_M2<BR />,smb.DATA_USAGE_CHARGE_AMT_M3<BR />,smb.DATA_USAGE_CHARGE_AMT_M4<BR />,smb.DATA_USAGE_CHARGE_AMT_M5<BR />,smb.DATA_USAGE_CHARGE_AMT_M6<BR />,smb.INT_CALL_CNT_M1<BR />,smb.INT_CALL_CNT_M2<BR />,smb.INT_CALL_CNT_M3<BR />,smb.INT_CALL_CNT_M4<BR />,smb.INT_CALL_CNT_M5<BR />,smb.INT_CALL_CNT_M6<BR />,smb.INT_CALL_SEC_M1<BR />,smb.INT_CALL_SEC_M2<BR />,smb.INT_CALL_SEC_M3<BR />,smb.INT_CALL_SEC_M4<BR />,smb.INT_CALL_SEC_M5<BR />,smb.INT_CALL_SEC_M6<BR />,smb.INT_CALL_avg_dur_M1<BR />,smb.INT_CALL_avg_dur_M2<BR />,smb.INT_CALL_avg_dur_M3<BR />,smb.INT_CALL_avg_dur_M4<BR />,smb.INT_CALL_avg_dur_M5<BR />,smb.INT_CALL_avg_dur_M6<BR />,smb.INT_USAGE_CHARGE_AMT_M1<BR />,smb.INT_USAGE_CHARGE_AMT_M2<BR />,smb.INT_USAGE_CHARGE_AMT_M3<BR />,smb.INT_USAGE_CHARGE_AMT_M4<BR />,smb.INT_USAGE_CHARGE_AMT_M5<BR />,smb.INT_USAGE_CHARGE_AMT_M6<BR />,smb.LOCAL_CALL_CNT_M1<BR />,smb.LOCAL_CALL_CNT_M2<BR />,smb.LOCAL_CALL_CNT_M3<BR />,smb.LOCAL_CALL_CNT_M4<BR />,smb.LOCAL_CALL_CNT_M5<BR />,smb.LOCAL_CALL_CNT_M6<BR />,smb.LOCAL_CALL_SEC_M1<BR />,smb.LOCAL_CALL_SEC_M2<BR />,smb.LOCAL_CALL_SEC_M3<BR />,smb.LOCAL_CALL_SEC_M4<BR />,smb.LOCAL_CALL_SEC_M5<BR />,smb.LOCAL_CALL_SEC_M6<BR />,smb.LOCAL_CAL_avg_dur_M1<BR />,smb.LOCAL_CAL_avg_dur_M2<BR />,smb.LOCAL_CAL_avg_dur_M3<BR />,smb.LOCAL_CAL_avg_dur_M4<BR />,smb.LOCAL_CAL_avg_dur_M5<BR />,smb.LOCAL_CAL_avg_dur_M6<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M1<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M2<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M3<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M4<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M5<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M6<BR />,smb.NAT_CALL_CNT_M1<BR />,smb.NAT_CALL_CNT_M2<BR />,smb.NAT_CALL_CNT_M3<BR />,smb.NAT_CALL_CNT_M4<BR />,smb.NAT_CALL_CNT_M5<BR />,smb.NAT_CALL_CNT_M6<BR />,smb.NAT_CALL_SEC_M1<BR />,smb.NAT_CALL_SEC_M2<BR />,smb.NAT_CALL_SEC_M3<BR />,smb.NAT_CALL_SEC_M4<BR />,smb.NAT_CALL_SEC_M5<BR />,smb.NAT_CALL_SEC_M6<BR />,smb.NAT_CALL_avg_dur_M1<BR />,smb.NAT_CALL_avg_dur_M2<BR />,smb.NAT_CALL_avg_dur_M3<BR />,smb.NAT_CALL_avg_dur_M4<BR />,smb.NAT_CALL_avg_dur_M5<BR />,smb.NAT_CALL_avg_dur_M6<BR />,smb.NAT_USAGE_CHARGE_AMT_M1<BR />,smb.NAT_USAGE_CHARGE_AMT_M2<BR />,smb.NAT_USAGE_CHARGE_AMT_M3<BR />,smb.NAT_USAGE_CHARGE_AMT_M4<BR />,smb.NAT_USAGE_CHARGE_AMT_M5<BR />,smb.NAT_USAGE_CHARGE_AMT_M6<BR />,smb.ONE_TIME_CHARGE_AMT_M1<BR />,smb.ONE_TIME_CHARGE_AMT_M2<BR />,smb.ONE_TIME_CHARGE_AMT_M3<BR />,smb.ONE_TIME_CHARGE_AMT_M4<BR />,smb.ONE_TIME_CHARGE_AMT_M5<BR />,smb.ONE_TIME_CHARGE_AMT_M6<BR />,smb.OTHER_CALL_CNT_M1<BR />,smb.OTHER_CALL_CNT_M2<BR />,smb.OTHER_CALL_CNT_M3<BR />,smb.OTHER_CALL_CNT_M4<BR />,smb.OTHER_CALL_CNT_M5<BR />,smb.OTHER_CALL_CNT_M6<BR />,smb.OTHER_CALL_SEC_M1<BR />,smb.OTHER_CALL_SEC_M2<BR />,smb.OTHER_CALL_SEC_M3<BR />,smb.OTHER_CALL_SEC_M4<BR />,smb.OTHER_CALL_SEC_M5<BR />,smb.OTHER_CALL_SEC_M6<BR />,smb.OTHER_CAL_avg_dur_M1<BR />,smb.OTHER_CAL_avg_dur_M2<BR />,smb.OTHER_CAL_avg_dur_M3<BR />,smb.OTHER_CAL_avg_dur_M4<BR />,smb.OTHER_CAL_avg_dur_M5<BR />,smb.OTHER_CAL_avg_dur_M6<BR />,smb.OTHER_USAGE_CHARGE_AMT_M1<BR />,smb.OTHER_USAGE_CHARGE_AMT_M2<BR />,smb.OTHER_USAGE_CHARGE_AMT_M3<BR />,smb.OTHER_USAGE_CHARGE_AMT_M4<BR />,smb.OTHER_USAGE_CHARGE_AMT_M5<BR />,smb.OTHER_USAGE_CHARGE_AMT_M6<BR />,smb.OVR_CALL_AVG_DURATION_M1<BR />,smb.OVR_CALL_AVG_DURATION_M2<BR />,smb.OVR_CALL_AVG_DURATION_M3<BR />,smb.OVR_CALL_AVG_DURATION_M4<BR />,smb.OVR_CALL_AVG_DURATION_M5<BR />,smb.OVR_CALL_AVG_DURATION_M6<BR />,smb.RECURRING_CHARGE_AMT_M1<BR />,smb.RECURRING_CHARGE_AMT_M2<BR />,smb.RECURRING_CHARGE_AMT_M3<BR />,smb.RECURRING_CHARGE_AMT_M4<BR />,smb.RECURRING_CHARGE_AMT_M5<BR />,smb.RECURRING_CHARGE_AMT_M6<BR />,smb.SPEND_AMT_M1<BR />,smb.SPEND_AMT_M2<BR />,smb.SPEND_AMT_M3<BR />,smb.SPEND_AMT_M4<BR />,smb.SPEND_AMT_M5<BR />,smb.SPEND_AMT_M6<BR />,smb.TOT_CALL_CNT_M1<BR />,smb.TOT_CALL_CNT_M2<BR />,smb.TOT_CALL_CNT_M3<BR />,smb.TOT_CALL_CNT_M4<BR />,smb.TOT_CALL_CNT_M5<BR />,smb.TOT_CALL_CNT_M6<BR />,smb.TOT_CALL_SEC_M1<BR />,smb.TOT_CALL_SEC_M2<BR />,smb.TOT_CALL_SEC_M3<BR />,smb.TOT_CALL_SEC_M4<BR />,smb.TOT_CALL_SEC_M5<BR />,smb.TOT_CALL_SEC_M6<BR />,smb.TOT_CHARGE_AMT_M1<BR />,smb.TOT_CHARGE_AMT_M2<BR />,smb.TOT_CHARGE_AMT_M3<BR />,smb.TOT_CHARGE_AMT_M4<BR />,smb.TOT_CHARGE_AMT_M5<BR />,smb.TOT_CHARGE_AMT_M6<BR />,smb.USAGE_CHARGE_AMT_M1<BR />,smb.USAGE_CHARGE_AMT_M2<BR />,smb.USAGE_CHARGE_AMT_M3<BR />,smb.USAGE_CHARGE_AMT_M4<BR />,smb.USAGE_CHARGE_AMT_M5<BR />,smb.USAGE_CHARGE_AMT_M6<BR />,smb.TCL_DLM<BR />,smb.TCL_DL2M<BR />,smb.TCL_DL3M<BR />,smb.TCH_DLM<BR />,smb.TCH_DL2M<BR />,smb.TCH_DL3M<BR />,smb.LCL_DLM<BR />,smb.LCL_DL2M<BR />,smb.LCL_DL3M<BR />,smb.NCL_DLM<BR />,smb.NCL_DL2M<BR />,smb.NCL_DL3M<BR />,smb.CELL_CALL_SEC_Avg6<BR />,smb.CELL_CALL_avg_dur_Avg6<BR />,smb.CELL_USAGE_CHARGE_AMT_Avg6<BR />,smb.DATA_CALL_CNT_Avg6<BR />,smb.DATA_CALL_SEC_Avg6<BR />,smb.DATA_CALL_avg_dur_Avg6<BR />,smb.DATA_USAGE_CHARGE_AMT_Avg6<BR />,smb.INT_CALL_CNT_Avg6<BR />,smb.INT_CALL_SEC_Avg6<BR />,smb.INT_CALL_avg_dur_Avg6<BR />,smb.INT_USAGE_CHARGE_AMT_Avg6<BR />,smb.LOCAL_CALL_CNT_Avg6<BR />,smb.LOCAL_CALL_SEC_Avg6<BR />,smb.LOCAL_CAL_avg_dur_Avg6<BR />,smb.LOCAL_USAGE_CHARGE_AMT_Avg6<BR />,smb.NAT_CALL_CNT_Avg6<BR />,smb.NAT_CALL_SEC_Avg6<BR />,smb.NAT_CALL_avg_dur_Avg6<BR />,smb.NAT_USAGE_CHARGE_AMT_Avg6<BR />,smb.ONE_TIME_CHARGE_AMT_Avg6<BR />,smb.OTHER_CALL_CNT_Avg6<BR />,smb.OTHER_CALL_SEC_Avg6<BR />,smb.OTHER_CAL_avg_dur_Avg6<BR />,smb.OTHER_USAGE_CHARGE_AMT_Avg6<BR />,smb.OVR_CALL_AVG_DURATION_Avg6<BR />,smb.RECURRING_CHARGE_AMT_Avg6<BR />,smb.SPEND_AMT_Avg6<BR />,smb.TOT_CALL_CNT_Avg6<BR />,smb.TOT_CALL_SEC_Avg6<BR />,smb.TOT_CHARGE_AMT_Avg6<BR />,smb.USAGE_CHARGE_AMT_Avg6<BR />,smb.CELL_CALL_SEC_Avg3<BR />,smb.CELL_CALL_avg_dur_Avg3<BR />,smb.CELL_USAGE_CHARGE_AMT_Avg3<BR />,smb.DATA_CALL_CNT_Avg3<BR />,smb.DATA_CALL_SEC_Avg3<BR />,smb.DATA_CALL_avg_dur_Avg3<BR />,smb.DATA_USAGE_CHARGE_AMT_Avg3<BR />,smb.INT_CALL_CNT_Avg3<BR />,smb.INT_CALL_SEC_Avg3<BR />,smb.INT_CALL_avg_dur_Avg3<BR />,smb.INT_USAGE_CHARGE_AMT_Avg3<BR />,smb.LOCAL_CALL_CNT_Avg3<BR />,smb.LOCAL_CALL_SEC_Avg3<BR />,smb.LOCAL_CAL_avg_dur_Avg3<BR />,smb.LOCAL_USAGE_CHARGE_AMT_Avg3<BR />,smb.NAT_CALL_CNT_Avg3<BR />,smb.NAT_CALL_SEC_Avg3<BR />,smb.NAT_CALL_avg_dur_Avg3<BR />,smb.NAT_USAGE_CHARGE_AMT_Avg3<BR />,smb.ONE_TIME_CHARGE_AMT_Avg3<BR />,smb.OTHER_CALL_CNT_Avg3<BR />,smb.OTHER_CALL_SEC_Avg3<BR />,smb.OTHER_CAL_avg_dur_Avg3<BR />,smb.OTHER_USAGE_CHARGE_AMT_Avg3<BR />,smb.OVR_CALL_AVG_DURATION_Avg3<BR />,smb.RECURRING_CHARGE_AMT_Avg3<BR />,smb.SPEND_AMT_Avg3<BR />,smb.TOT_CALL_CNT_Avg3<BR />,smb.TOT_CALL_SEC_Avg3<BR />,smb.TOT_CHARGE_AMT_Avg3<BR />,smb.USAGE_CHARGE_AMT_Avg3<BR />,smb.CELL_CALL_CNT_DEC2_1<BR />,smb.CELL_CALL_CNT_DEC3_2<BR />,smb.CELL_CALL_CNT_DEC4_3<BR />,smb.CELL_CALL_CNT_DEC5_4<BR />,smb.CELL_CALL_CNT_DEC6_5<BR />,smb.CELL_CALL_SEC_DEC2_1<BR />,smb.CELL_CALL_SEC_DEC3_2<BR />,smb.CELL_CALL_SEC_DEC4_3<BR />,smb.CELL_CALL_SEC_DEC5_4<BR />,smb.CELL_CALL_SEC_DEC6_5<BR />,smb.CELL_CALL_avg_dur_DEC2_1<BR />,smb.CELL_CALL_avg_dur_DEC3_2<BR />,smb.CELL_CALL_avg_dur_DEC4_3<BR />,smb.CELL_CALL_avg_dur_DEC5_4<BR />,smb.CELL_CALL_avg_dur_DEC6_5<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.INT_CALL_CNT_DEC2_1<BR />,smb.INT_CALL_CNT_DEC3_2<BR />,smb.INT_CALL_CNT_DEC4_3<BR />,smb.INT_CALL_CNT_DEC5_4<BR />,smb.INT_CALL_CNT_DEC6_5<BR />,smb.INT_CALL_SEC_DEC2_1<BR />,smb.INT_CALL_SEC_DEC3_2<BR />,smb.INT_CALL_SEC_DEC4_3<BR />,smb.INT_CALL_SEC_DEC5_4<BR />,smb.INT_CALL_SEC_DEC6_5<BR />,smb.INT_CALL_avg_dur_DEC2_1<BR />,smb.INT_CALL_avg_dur_DEC3_2<BR />,smb.INT_CALL_avg_dur_DEC4_3<BR />,smb.INT_CALL_avg_dur_DEC5_4<BR />,smb.INT_CALL_avg_dur_DEC6_5<BR />,smb.INT_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.INT_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.INT_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.INT_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.INT_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.LOCAL_CALL_CNT_DEC2_1<BR />,smb.LOCAL_CALL_CNT_DEC3_2<BR />,smb.LOCAL_CALL_CNT_DEC4_3<BR />,smb.LOCAL_CALL_CNT_DEC5_4<BR />,smb.LOCAL_CALL_CNT_DEC6_5<BR />,smb.LOCAL_CALL_SEC_DEC2_1<BR />,smb.LOCAL_CALL_SEC_DEC3_2<BR />,smb.LOCAL_CALL_SEC_DEC4_3<BR />,smb.LOCAL_CALL_SEC_DEC5_4<BR />,smb.LOCAL_CALL_SEC_DEC6_5<BR />,smb.LOCAL_CAL_avg_dur_DEC2_1<BR />,smb.LOCAL_CAL_avg_dur_DEC3_2<BR />,smb.LOCAL_CAL_avg_dur_DEC4_3<BR />,smb.LOCAL_CAL_avg_dur_DEC5_4<BR />,smb.LOCAL_CAL_avg_dur_DEC6_5<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.NAT_CALL_CNT_DEC2_1<BR />,smb.NAT_CALL_CNT_DEC3_2<BR />,smb.NAT_CALL_CNT_DEC4_3<BR />,smb.NAT_CALL_CNT_DEC5_4<BR />,smb.NAT_CALL_CNT_DEC6_5<BR />,smb.NAT_CALL_SEC_DEC2_1<BR />,smb.NAT_CALL_SEC_DEC3_2<BR />,smb.NAT_CALL_SEC_DEC4_3<BR />,smb.NAT_CALL_SEC_DEC5_4<BR />,smb.NAT_CALL_SEC_DEC6_5<BR />,smb.NAT_CALL_avg_dur_DEC2_1<BR />,smb.NAT_CALL_avg_dur_DEC3_2<BR />,smb.NAT_CALL_avg_dur_DEC4_3<BR />,smb.NAT_CALL_avg_dur_DEC5_4<BR />,smb.NAT_CALL_avg_dur_DEC6_5<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.SPEND_AMT_DEC2_1<BR />,smb.SPEND_AMT_DEC3_2<BR />,smb.SPEND_AMT_DEC4_3<BR />,smb.SPEND_AMT_DEC5_4<BR />,smb.SPEND_AMT_DEC6_5<BR />,smb.TOT_CALL_CNT_DEC2_1<BR />,smb.TOT_CALL_CNT_DEC3_2<BR />,smb.TOT_CALL_CNT_DEC4_3<BR />,smb.TOT_CALL_CNT_DEC5_4<BR />,smb.TOT_CALL_CNT_DEC6_5<BR />,smb.TOT_CALL_SEC_DEC2_1<BR />,smb.TOT_CALL_SEC_DEC3_2<BR />,smb.TOT_CALL_SEC_DEC4_3<BR />,smb.TOT_CALL_SEC_DEC5_4<BR />,smb.TOT_CALL_SEC_DEC6_5<BR />,smb.TOT_CHARGE_AMT_DEC2_1<BR />,smb.TOT_CHARGE_AMT_DEC3_2<BR />,smb.TOT_CHARGE_AMT_DEC4_3<BR />,smb.TOT_CHARGE_AMT_DEC5_4<BR />,smb.TOT_CHARGE_AMT_DEC6_5<BR />,smb.USAGE_CHARGE_AMT_DEC2_1<BR />,smb.USAGE_CHARGE_AMT_DEC3_2<BR />,smb.USAGE_CHARGE_AMT_DEC4_3<BR />,smb.USAGE_CHARGE_AMT_DEC5_4<BR />,smb.USAGE_CHARGE_AMT_DEC6_5<BR />,smb.Avg_DEC_6M_CELL_CALL_CNT<BR />,smb.Avg_DEC_6M_CELL_CALL_SEC<BR />,smb.Avg_DEC_6M_CELL_CALL_avg_dur<BR />,smb.Avg_DEC_6M_CELL_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_6M_INT_CALL_CNT<BR />,smb.Avg_DEC_6M_INT_CALL_SEC<BR />,smb.Avg_DEC_6M_INT_CALL_avg_dur<BR />,smb.Avg_DEC_6M_INT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_6M_LOCAL_CALL_CNT<BR />,smb.Avg_DEC_6M_LOCAL_CALL_SEC<BR />,smb.Avg_DEC_6M_LOCAL_CAL_avg_dur<BR />,smb.Avg_DEC_6M_LOC_USAGE_CHRG_AMT<BR />,smb.Avg_DEC_6M_NAT_CALL_CNT<BR />,smb.Avg_DEC_6M_NAT_CALL_SEC<BR />,smb.Avg_DEC_6M_NAT_CALL_avg_dur<BR />,smb.Avg_DEC_6M_NAT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_6M_SPEND_AMT<BR />,smb.Avg_DEC_6M_TOT_CALL_CNT<BR />,smb.Avg_DEC_6M_TOT_CALL_SEC<BR />,smb.Avg_DEC_6M_TOT_CHARGE_AMT<BR />,smb.Avg_DEC_6M_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_CELL_CALL_CNT<BR />,smb.Avg_DEC_3M_CELL_CALL_SEC<BR />,smb.Avg_DEC_3M_CELL_CALL_avg_dur<BR />,smb.Avg_DEC_3M_CELL_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_INT_CALL_CNT<BR />,smb.Avg_DEC_3M_INT_CALL_SEC<BR />,smb.Avg_DEC_3M_INT_CALL_avg_dur<BR />,smb.Avg_DEC_3M_INT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_LOCAL_CALL_CNT<BR />,smb.Avg_DEC_3M_LOCAL_CALL_SEC<BR />,smb.Avg_DEC_3M_LOCAL_CAL_avg_dur<BR />,smb.Avg_DEC_3M_LOC_USAGE_CHRG_AMT<BR />,smb.Avg_DEC_3M_NAT_CALL_CNT<BR />,smb.Avg_DEC_3M_NAT_CALL_SEC<BR />,smb.Avg_DEC_3M_NAT_CALL_avg_dur<BR />,smb.Avg_DEC_3M_NAT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_SPEND_AMT<BR />,smb.Avg_DEC_3M_TOT_CALL_CNT<BR />,smb.Avg_DEC_3M_TOT_CALL_SEC<BR />,smb.Avg_DEC_3M_TOT_CHARGE_AMT<BR />,smb.Avg_DEC_3M_USAGE_CHARGE_AMT</P><P>from class1.smb<BR />left join from work.test<BR />on smb.product_id=test.product_id;<BR />quit;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>error:-</P><DIV class="sasSource">489 ,smb.Avg_DEC_3M_USAGE_CHARGE_AMT</DIV><DIV class="sasSource">490 from class1.smb</DIV><DIV class="sasSource">491 left join from work.test</DIV><DIV class="sasError">_</DIV><DIV class="sasError">73</DIV><DIV class="sasError">76</DIV><DIV class="sasError">ERROR 73-322: Expecting an ON.</DIV><DIV class="sasSource">&nbsp;</DIV><DIV class="sasError">ERROR 76-322: Syntax error, statement will be ignored.</DIV><DIV class="sasSource">&nbsp;</DIV><DIV class="sasSource">492 on smb.product_id=test.product_id;</DIV><DIV class="sasNote">NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.</DIV><DIV class="sasSource">493 quit;</DIV> Sun, 17 Mar 2019 05:19:28 GMT Shrutibhatnagar 2019-03-17T05:19:28Z https://communities.sas.com/t5/SAS-Studio/please-see-the-error/m-p/543764#M7215 <P>distinct (smb.PRODUCT_ID)<BR />,smb.Year<BR />,smb.AON<BR />,smb.CELL_CALL_CNT_M1<BR />,smb.CELL_CALL_CNT_M2<BR />,smb.CELL_CALL_CNT_M3<BR />,smb.CELL_CALL_CNT_M4<BR />,smb.CELL_CALL_CNT_M5<BR />,smb.CELL_CALL_CNT_M6<BR />,smb.CELL_CALL_SEC_M1<BR />,smb.CELL_CALL_SEC_M2<BR />,smb.CELL_CALL_SEC_M3<BR />,smb.CELL_CALL_SEC_M4<BR />,smb.CELL_CALL_SEC_M5<BR />,smb.CELL_CALL_SEC_M6<BR />,smb.CELL_CALL_avg_dur_M1<BR />,smb.CELL_CALL_avg_dur_M2<BR />,smb.CELL_CALL_avg_dur_M3<BR />,smb.CELL_CALL_avg_dur_M4<BR />,smb.CELL_CALL_avg_dur_M5<BR />,smb.CELL_CALL_avg_dur_M6<BR />,smb.CELL_USAGE_CHARGE_AMT_M1<BR />,smb.CELL_USAGE_CHARGE_AMT_M2<BR />,smb.CELL_USAGE_CHARGE_AMT_M3<BR />,smb.CELL_USAGE_CHARGE_AMT_M4<BR />,smb.CELL_USAGE_CHARGE_AMT_M5<BR />,smb.CELL_USAGE_CHARGE_AMT_M6<BR />,smb.DATA_CALL_CNT_M1<BR />,smb.DATA_CALL_CNT_M2<BR />,smb.DATA_CALL_CNT_M3<BR />,smb.DATA_CALL_CNT_M4<BR />,smb.DATA_CALL_CNT_M5<BR />,smb.DATA_CALL_CNT_M6<BR />,smb.DATA_CALL_SEC_M1<BR />,smb.DATA_CALL_SEC_M2<BR />,smb.DATA_CALL_SEC_M3<BR />,smb.DATA_CALL_SEC_M4<BR />,smb.DATA_CALL_SEC_M5<BR />,smb.DATA_CALL_SEC_M6<BR />,smb.DATA_CALL_avg_dur_M1<BR />,smb.DATA_CALL_avg_dur_M2<BR />,smb.DATA_CALL_avg_dur_M3<BR />,smb.DATA_CALL_avg_dur_M4<BR />,smb.DATA_CALL_avg_dur_M5<BR />,smb.DATA_CALL_avg_dur_M6<BR />,smb.DATA_USAGE_CHARGE_AMT_M1<BR />,smb.DATA_USAGE_CHARGE_AMT_M2<BR />,smb.DATA_USAGE_CHARGE_AMT_M3<BR />,smb.DATA_USAGE_CHARGE_AMT_M4<BR />,smb.DATA_USAGE_CHARGE_AMT_M5<BR />,smb.DATA_USAGE_CHARGE_AMT_M6<BR />,smb.INT_CALL_CNT_M1<BR />,smb.INT_CALL_CNT_M2<BR />,smb.INT_CALL_CNT_M3<BR />,smb.INT_CALL_CNT_M4<BR />,smb.INT_CALL_CNT_M5<BR />,smb.INT_CALL_CNT_M6<BR />,smb.INT_CALL_SEC_M1<BR />,smb.INT_CALL_SEC_M2<BR />,smb.INT_CALL_SEC_M3<BR />,smb.INT_CALL_SEC_M4<BR />,smb.INT_CALL_SEC_M5<BR />,smb.INT_CALL_SEC_M6<BR />,smb.INT_CALL_avg_dur_M1<BR />,smb.INT_CALL_avg_dur_M2<BR />,smb.INT_CALL_avg_dur_M3<BR />,smb.INT_CALL_avg_dur_M4<BR />,smb.INT_CALL_avg_dur_M5<BR />,smb.INT_CALL_avg_dur_M6<BR />,smb.INT_USAGE_CHARGE_AMT_M1<BR />,smb.INT_USAGE_CHARGE_AMT_M2<BR />,smb.INT_USAGE_CHARGE_AMT_M3<BR />,smb.INT_USAGE_CHARGE_AMT_M4<BR />,smb.INT_USAGE_CHARGE_AMT_M5<BR />,smb.INT_USAGE_CHARGE_AMT_M6<BR />,smb.LOCAL_CALL_CNT_M1<BR />,smb.LOCAL_CALL_CNT_M2<BR />,smb.LOCAL_CALL_CNT_M3<BR />,smb.LOCAL_CALL_CNT_M4<BR />,smb.LOCAL_CALL_CNT_M5<BR />,smb.LOCAL_CALL_CNT_M6<BR />,smb.LOCAL_CALL_SEC_M1<BR />,smb.LOCAL_CALL_SEC_M2<BR />,smb.LOCAL_CALL_SEC_M3<BR />,smb.LOCAL_CALL_SEC_M4<BR />,smb.LOCAL_CALL_SEC_M5<BR />,smb.LOCAL_CALL_SEC_M6<BR />,smb.LOCAL_CAL_avg_dur_M1<BR />,smb.LOCAL_CAL_avg_dur_M2<BR />,smb.LOCAL_CAL_avg_dur_M3<BR />,smb.LOCAL_CAL_avg_dur_M4<BR />,smb.LOCAL_CAL_avg_dur_M5<BR />,smb.LOCAL_CAL_avg_dur_M6<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M1<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M2<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M3<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M4<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M5<BR />,smb.LOCAL_USAGE_CHARGE_AMT_M6<BR />,smb.NAT_CALL_CNT_M1<BR />,smb.NAT_CALL_CNT_M2<BR />,smb.NAT_CALL_CNT_M3<BR />,smb.NAT_CALL_CNT_M4<BR />,smb.NAT_CALL_CNT_M5<BR />,smb.NAT_CALL_CNT_M6<BR />,smb.NAT_CALL_SEC_M1<BR />,smb.NAT_CALL_SEC_M2<BR />,smb.NAT_CALL_SEC_M3<BR />,smb.NAT_CALL_SEC_M4<BR />,smb.NAT_CALL_SEC_M5<BR />,smb.NAT_CALL_SEC_M6<BR />,smb.NAT_CALL_avg_dur_M1<BR />,smb.NAT_CALL_avg_dur_M2<BR />,smb.NAT_CALL_avg_dur_M3<BR />,smb.NAT_CALL_avg_dur_M4<BR />,smb.NAT_CALL_avg_dur_M5<BR />,smb.NAT_CALL_avg_dur_M6<BR />,smb.NAT_USAGE_CHARGE_AMT_M1<BR />,smb.NAT_USAGE_CHARGE_AMT_M2<BR />,smb.NAT_USAGE_CHARGE_AMT_M3<BR />,smb.NAT_USAGE_CHARGE_AMT_M4<BR />,smb.NAT_USAGE_CHARGE_AMT_M5<BR />,smb.NAT_USAGE_CHARGE_AMT_M6<BR />,smb.ONE_TIME_CHARGE_AMT_M1<BR />,smb.ONE_TIME_CHARGE_AMT_M2<BR />,smb.ONE_TIME_CHARGE_AMT_M3<BR />,smb.ONE_TIME_CHARGE_AMT_M4<BR />,smb.ONE_TIME_CHARGE_AMT_M5<BR />,smb.ONE_TIME_CHARGE_AMT_M6<BR />,smb.OTHER_CALL_CNT_M1<BR />,smb.OTHER_CALL_CNT_M2<BR />,smb.OTHER_CALL_CNT_M3<BR />,smb.OTHER_CALL_CNT_M4<BR />,smb.OTHER_CALL_CNT_M5<BR />,smb.OTHER_CALL_CNT_M6<BR />,smb.OTHER_CALL_SEC_M1<BR />,smb.OTHER_CALL_SEC_M2<BR />,smb.OTHER_CALL_SEC_M3<BR />,smb.OTHER_CALL_SEC_M4<BR />,smb.OTHER_CALL_SEC_M5<BR />,smb.OTHER_CALL_SEC_M6<BR />,smb.OTHER_CAL_avg_dur_M1<BR />,smb.OTHER_CAL_avg_dur_M2<BR />,smb.OTHER_CAL_avg_dur_M3<BR />,smb.OTHER_CAL_avg_dur_M4<BR />,smb.OTHER_CAL_avg_dur_M5<BR />,smb.OTHER_CAL_avg_dur_M6<BR />,smb.OTHER_USAGE_CHARGE_AMT_M1<BR />,smb.OTHER_USAGE_CHARGE_AMT_M2<BR />,smb.OTHER_USAGE_CHARGE_AMT_M3<BR />,smb.OTHER_USAGE_CHARGE_AMT_M4<BR />,smb.OTHER_USAGE_CHARGE_AMT_M5<BR />,smb.OTHER_USAGE_CHARGE_AMT_M6<BR />,smb.OVR_CALL_AVG_DURATION_M1<BR />,smb.OVR_CALL_AVG_DURATION_M2<BR />,smb.OVR_CALL_AVG_DURATION_M3<BR />,smb.OVR_CALL_AVG_DURATION_M4<BR />,smb.OVR_CALL_AVG_DURATION_M5<BR />,smb.OVR_CALL_AVG_DURATION_M6<BR />,smb.RECURRING_CHARGE_AMT_M1<BR />,smb.RECURRING_CHARGE_AMT_M2<BR />,smb.RECURRING_CHARGE_AMT_M3<BR />,smb.RECURRING_CHARGE_AMT_M4<BR />,smb.RECURRING_CHARGE_AMT_M5<BR />,smb.RECURRING_CHARGE_AMT_M6<BR />,smb.SPEND_AMT_M1<BR />,smb.SPEND_AMT_M2<BR />,smb.SPEND_AMT_M3<BR />,smb.SPEND_AMT_M4<BR />,smb.SPEND_AMT_M5<BR />,smb.SPEND_AMT_M6<BR />,smb.TOT_CALL_CNT_M1<BR />,smb.TOT_CALL_CNT_M2<BR />,smb.TOT_CALL_CNT_M3<BR />,smb.TOT_CALL_CNT_M4<BR />,smb.TOT_CALL_CNT_M5<BR />,smb.TOT_CALL_CNT_M6<BR />,smb.TOT_CALL_SEC_M1<BR />,smb.TOT_CALL_SEC_M2<BR />,smb.TOT_CALL_SEC_M3<BR />,smb.TOT_CALL_SEC_M4<BR />,smb.TOT_CALL_SEC_M5<BR />,smb.TOT_CALL_SEC_M6<BR />,smb.TOT_CHARGE_AMT_M1<BR />,smb.TOT_CHARGE_AMT_M2<BR />,smb.TOT_CHARGE_AMT_M3<BR />,smb.TOT_CHARGE_AMT_M4<BR />,smb.TOT_CHARGE_AMT_M5<BR />,smb.TOT_CHARGE_AMT_M6<BR />,smb.USAGE_CHARGE_AMT_M1<BR />,smb.USAGE_CHARGE_AMT_M2<BR />,smb.USAGE_CHARGE_AMT_M3<BR />,smb.USAGE_CHARGE_AMT_M4<BR />,smb.USAGE_CHARGE_AMT_M5<BR />,smb.USAGE_CHARGE_AMT_M6<BR />,smb.TCL_DLM<BR />,smb.TCL_DL2M<BR />,smb.TCL_DL3M<BR />,smb.TCH_DLM<BR />,smb.TCH_DL2M<BR />,smb.TCH_DL3M<BR />,smb.LCL_DLM<BR />,smb.LCL_DL2M<BR />,smb.LCL_DL3M<BR />,smb.NCL_DLM<BR />,smb.NCL_DL2M<BR />,smb.NCL_DL3M<BR />,smb.CELL_CALL_SEC_Avg6<BR />,smb.CELL_CALL_avg_dur_Avg6<BR />,smb.CELL_USAGE_CHARGE_AMT_Avg6<BR />,smb.DATA_CALL_CNT_Avg6<BR />,smb.DATA_CALL_SEC_Avg6<BR />,smb.DATA_CALL_avg_dur_Avg6<BR />,smb.DATA_USAGE_CHARGE_AMT_Avg6<BR />,smb.INT_CALL_CNT_Avg6<BR />,smb.INT_CALL_SEC_Avg6<BR />,smb.INT_CALL_avg_dur_Avg6<BR />,smb.INT_USAGE_CHARGE_AMT_Avg6<BR />,smb.LOCAL_CALL_CNT_Avg6<BR />,smb.LOCAL_CALL_SEC_Avg6<BR />,smb.LOCAL_CAL_avg_dur_Avg6<BR />,smb.LOCAL_USAGE_CHARGE_AMT_Avg6<BR />,smb.NAT_CALL_CNT_Avg6<BR />,smb.NAT_CALL_SEC_Avg6<BR />,smb.NAT_CALL_avg_dur_Avg6<BR />,smb.NAT_USAGE_CHARGE_AMT_Avg6<BR />,smb.ONE_TIME_CHARGE_AMT_Avg6<BR />,smb.OTHER_CALL_CNT_Avg6<BR />,smb.OTHER_CALL_SEC_Avg6<BR />,smb.OTHER_CAL_avg_dur_Avg6<BR />,smb.OTHER_USAGE_CHARGE_AMT_Avg6<BR />,smb.OVR_CALL_AVG_DURATION_Avg6<BR />,smb.RECURRING_CHARGE_AMT_Avg6<BR />,smb.SPEND_AMT_Avg6<BR />,smb.TOT_CALL_CNT_Avg6<BR />,smb.TOT_CALL_SEC_Avg6<BR />,smb.TOT_CHARGE_AMT_Avg6<BR />,smb.USAGE_CHARGE_AMT_Avg6<BR />,smb.CELL_CALL_SEC_Avg3<BR />,smb.CELL_CALL_avg_dur_Avg3<BR />,smb.CELL_USAGE_CHARGE_AMT_Avg3<BR />,smb.DATA_CALL_CNT_Avg3<BR />,smb.DATA_CALL_SEC_Avg3<BR />,smb.DATA_CALL_avg_dur_Avg3<BR />,smb.DATA_USAGE_CHARGE_AMT_Avg3<BR />,smb.INT_CALL_CNT_Avg3<BR />,smb.INT_CALL_SEC_Avg3<BR />,smb.INT_CALL_avg_dur_Avg3<BR />,smb.INT_USAGE_CHARGE_AMT_Avg3<BR />,smb.LOCAL_CALL_CNT_Avg3<BR />,smb.LOCAL_CALL_SEC_Avg3<BR />,smb.LOCAL_CAL_avg_dur_Avg3<BR />,smb.LOCAL_USAGE_CHARGE_AMT_Avg3<BR />,smb.NAT_CALL_CNT_Avg3<BR />,smb.NAT_CALL_SEC_Avg3<BR />,smb.NAT_CALL_avg_dur_Avg3<BR />,smb.NAT_USAGE_CHARGE_AMT_Avg3<BR />,smb.ONE_TIME_CHARGE_AMT_Avg3<BR />,smb.OTHER_CALL_CNT_Avg3<BR />,smb.OTHER_CALL_SEC_Avg3<BR />,smb.OTHER_CAL_avg_dur_Avg3<BR />,smb.OTHER_USAGE_CHARGE_AMT_Avg3<BR />,smb.OVR_CALL_AVG_DURATION_Avg3<BR />,smb.RECURRING_CHARGE_AMT_Avg3<BR />,smb.SPEND_AMT_Avg3<BR />,smb.TOT_CALL_CNT_Avg3<BR />,smb.TOT_CALL_SEC_Avg3<BR />,smb.TOT_CHARGE_AMT_Avg3<BR />,smb.USAGE_CHARGE_AMT_Avg3<BR />,smb.CELL_CALL_CNT_DEC2_1<BR />,smb.CELL_CALL_CNT_DEC3_2<BR />,smb.CELL_CALL_CNT_DEC4_3<BR />,smb.CELL_CALL_CNT_DEC5_4<BR />,smb.CELL_CALL_CNT_DEC6_5<BR />,smb.CELL_CALL_SEC_DEC2_1<BR />,smb.CELL_CALL_SEC_DEC3_2<BR />,smb.CELL_CALL_SEC_DEC4_3<BR />,smb.CELL_CALL_SEC_DEC5_4<BR />,smb.CELL_CALL_SEC_DEC6_5<BR />,smb.CELL_CALL_avg_dur_DEC2_1<BR />,smb.CELL_CALL_avg_dur_DEC3_2<BR />,smb.CELL_CALL_avg_dur_DEC4_3<BR />,smb.CELL_CALL_avg_dur_DEC5_4<BR />,smb.CELL_CALL_avg_dur_DEC6_5<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.CELL_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.INT_CALL_CNT_DEC2_1<BR />,smb.INT_CALL_CNT_DEC3_2<BR />,smb.INT_CALL_CNT_DEC4_3<BR />,smb.INT_CALL_CNT_DEC5_4<BR />,smb.INT_CALL_CNT_DEC6_5<BR />,smb.INT_CALL_SEC_DEC2_1<BR />,smb.INT_CALL_SEC_DEC3_2<BR />,smb.INT_CALL_SEC_DEC4_3<BR />,smb.INT_CALL_SEC_DEC5_4<BR />,smb.INT_CALL_SEC_DEC6_5<BR />,smb.INT_CALL_avg_dur_DEC2_1<BR />,smb.INT_CALL_avg_dur_DEC3_2<BR />,smb.INT_CALL_avg_dur_DEC4_3<BR />,smb.INT_CALL_avg_dur_DEC5_4<BR />,smb.INT_CALL_avg_dur_DEC6_5<BR />,smb.INT_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.INT_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.INT_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.INT_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.INT_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.LOCAL_CALL_CNT_DEC2_1<BR />,smb.LOCAL_CALL_CNT_DEC3_2<BR />,smb.LOCAL_CALL_CNT_DEC4_3<BR />,smb.LOCAL_CALL_CNT_DEC5_4<BR />,smb.LOCAL_CALL_CNT_DEC6_5<BR />,smb.LOCAL_CALL_SEC_DEC2_1<BR />,smb.LOCAL_CALL_SEC_DEC3_2<BR />,smb.LOCAL_CALL_SEC_DEC4_3<BR />,smb.LOCAL_CALL_SEC_DEC5_4<BR />,smb.LOCAL_CALL_SEC_DEC6_5<BR />,smb.LOCAL_CAL_avg_dur_DEC2_1<BR />,smb.LOCAL_CAL_avg_dur_DEC3_2<BR />,smb.LOCAL_CAL_avg_dur_DEC4_3<BR />,smb.LOCAL_CAL_avg_dur_DEC5_4<BR />,smb.LOCAL_CAL_avg_dur_DEC6_5<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.LOCAL_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.NAT_CALL_CNT_DEC2_1<BR />,smb.NAT_CALL_CNT_DEC3_2<BR />,smb.NAT_CALL_CNT_DEC4_3<BR />,smb.NAT_CALL_CNT_DEC5_4<BR />,smb.NAT_CALL_CNT_DEC6_5<BR />,smb.NAT_CALL_SEC_DEC2_1<BR />,smb.NAT_CALL_SEC_DEC3_2<BR />,smb.NAT_CALL_SEC_DEC4_3<BR />,smb.NAT_CALL_SEC_DEC5_4<BR />,smb.NAT_CALL_SEC_DEC6_5<BR />,smb.NAT_CALL_avg_dur_DEC2_1<BR />,smb.NAT_CALL_avg_dur_DEC3_2<BR />,smb.NAT_CALL_avg_dur_DEC4_3<BR />,smb.NAT_CALL_avg_dur_DEC5_4<BR />,smb.NAT_CALL_avg_dur_DEC6_5<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC2_1<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC3_2<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC4_3<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC5_4<BR />,smb.NAT_USAGE_CHARGE_AMT_DEC6_5<BR />,smb.SPEND_AMT_DEC2_1<BR />,smb.SPEND_AMT_DEC3_2<BR />,smb.SPEND_AMT_DEC4_3<BR />,smb.SPEND_AMT_DEC5_4<BR />,smb.SPEND_AMT_DEC6_5<BR />,smb.TOT_CALL_CNT_DEC2_1<BR />,smb.TOT_CALL_CNT_DEC3_2<BR />,smb.TOT_CALL_CNT_DEC4_3<BR />,smb.TOT_CALL_CNT_DEC5_4<BR />,smb.TOT_CALL_CNT_DEC6_5<BR />,smb.TOT_CALL_SEC_DEC2_1<BR />,smb.TOT_CALL_SEC_DEC3_2<BR />,smb.TOT_CALL_SEC_DEC4_3<BR />,smb.TOT_CALL_SEC_DEC5_4<BR />,smb.TOT_CALL_SEC_DEC6_5<BR />,smb.TOT_CHARGE_AMT_DEC2_1<BR />,smb.TOT_CHARGE_AMT_DEC3_2<BR />,smb.TOT_CHARGE_AMT_DEC4_3<BR />,smb.TOT_CHARGE_AMT_DEC5_4<BR />,smb.TOT_CHARGE_AMT_DEC6_5<BR />,smb.USAGE_CHARGE_AMT_DEC2_1<BR />,smb.USAGE_CHARGE_AMT_DEC3_2<BR />,smb.USAGE_CHARGE_AMT_DEC4_3<BR />,smb.USAGE_CHARGE_AMT_DEC5_4<BR />,smb.USAGE_CHARGE_AMT_DEC6_5<BR />,smb.Avg_DEC_6M_CELL_CALL_CNT<BR />,smb.Avg_DEC_6M_CELL_CALL_SEC<BR />,smb.Avg_DEC_6M_CELL_CALL_avg_dur<BR />,smb.Avg_DEC_6M_CELL_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_6M_INT_CALL_CNT<BR />,smb.Avg_DEC_6M_INT_CALL_SEC<BR />,smb.Avg_DEC_6M_INT_CALL_avg_dur<BR />,smb.Avg_DEC_6M_INT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_6M_LOCAL_CALL_CNT<BR />,smb.Avg_DEC_6M_LOCAL_CALL_SEC<BR />,smb.Avg_DEC_6M_LOCAL_CAL_avg_dur<BR />,smb.Avg_DEC_6M_LOC_USAGE_CHRG_AMT<BR />,smb.Avg_DEC_6M_NAT_CALL_CNT<BR />,smb.Avg_DEC_6M_NAT_CALL_SEC<BR />,smb.Avg_DEC_6M_NAT_CALL_avg_dur<BR />,smb.Avg_DEC_6M_NAT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_6M_SPEND_AMT<BR />,smb.Avg_DEC_6M_TOT_CALL_CNT<BR />,smb.Avg_DEC_6M_TOT_CALL_SEC<BR />,smb.Avg_DEC_6M_TOT_CHARGE_AMT<BR />,smb.Avg_DEC_6M_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_CELL_CALL_CNT<BR />,smb.Avg_DEC_3M_CELL_CALL_SEC<BR />,smb.Avg_DEC_3M_CELL_CALL_avg_dur<BR />,smb.Avg_DEC_3M_CELL_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_INT_CALL_CNT<BR />,smb.Avg_DEC_3M_INT_CALL_SEC<BR />,smb.Avg_DEC_3M_INT_CALL_avg_dur<BR />,smb.Avg_DEC_3M_INT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_LOCAL_CALL_CNT<BR />,smb.Avg_DEC_3M_LOCAL_CALL_SEC<BR />,smb.Avg_DEC_3M_LOCAL_CAL_avg_dur<BR />,smb.Avg_DEC_3M_LOC_USAGE_CHRG_AMT<BR />,smb.Avg_DEC_3M_NAT_CALL_CNT<BR />,smb.Avg_DEC_3M_NAT_CALL_SEC<BR />,smb.Avg_DEC_3M_NAT_CALL_avg_dur<BR />,smb.Avg_DEC_3M_NAT_USAGE_CHARGE_AMT<BR />,smb.Avg_DEC_3M_SPEND_AMT<BR />,smb.Avg_DEC_3M_TOT_CALL_CNT<BR />,smb.Avg_DEC_3M_TOT_CALL_SEC<BR />,smb.Avg_DEC_3M_TOT_CHARGE_AMT<BR />,smb.Avg_DEC_3M_USAGE_CHARGE_AMT</P><P>from class1.smb<BR />left join from work.test<BR />on smb.product_id=test.product_id;<BR />quit;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>error:-</P><DIV class="sasSource">489 ,smb.Avg_DEC_3M_USAGE_CHARGE_AMT</DIV><DIV class="sasSource">490 from class1.smb</DIV><DIV class="sasSource">491 left join from work.test</DIV><DIV class="sasError">_</DIV><DIV class="sasError">73</DIV><DIV class="sasError">76</DIV><DIV class="sasError">ERROR 73-322: Expecting an ON.</DIV><DIV class="sasSource">&nbsp;</DIV><DIV class="sasError">ERROR 76-322: Syntax error, statement will be ignored.</DIV><DIV class="sasSource">&nbsp;</DIV><DIV class="sasSource">492 on smb.product_id=test.product_id;</DIV><DIV class="sasNote">NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.</DIV><DIV class="sasSource">493 quit;</DIV> Sun, 17 Mar 2019 05:19:28 GMT https://communities.sas.com/t5/SAS-Studio/please-see-the-error/m-p/543764#M7215 Shrutibhatnagar 2019-03-17T05:19:28Z https://communities.sas.com/t5/SAS-Studio/please-see-the-error/m-p/543765#M7216 <P>There must be only one "from" in a SQL select. Look at the join examples in the SAS SQL documentation.</P> Sun, 17 Mar 2019 06:15:51 GMT https://communities.sas.com/t5/SAS-Studio/please-see-the-error/m-p/543765#M7216 Kurt_Bremser 2019-03-17T06:15:51Z