now i get new errors i referred the same 78 ,smb.Year _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, (, AS, ON. ERROR 200-322: The symbol is not recognized and will be ignored. 79 ,smb.AON 80 ,smb.CELL_CALL_CNT_M1 81 ,smb.CELL_CALL_CNT_M2 82 ,smb.CELL_CALL_CNT_M3 83 ,smb.CELL_CALL_CNT_M4 84 ,smb.CELL_CALL_CNT_M5 85 ,smb.CELL_CALL_CNT_M6 86 ,smb.CELL_CALL_SEC_M1 87 ,smb.CELL_CALL_SEC_M2 88 ,smb.CELL_CALL_SEC_M3 89 ,smb.CELL_CALL_SEC_M4 90 ,smb.CELL_CALL_SEC_M5 91 ,smb.CELL_CALL_SEC_M6 92 ,smb.CELL_CALL_avg_dur_M1 93 ,smb.CELL_CALL_avg_dur_M2 94 ,smb.CELL_CALL_avg_dur_M3 95 ,smb.CELL_CALL_avg_dur_M4 96 ,smb.CELL_CALL_avg_dur_M5 97 ,smb.CELL_CALL_avg_dur_M6 98 ,smb.CELL_USAGE_CHARGE_AMT_M1 99 ,smb.CELL_USAGE_CHARGE_AMT_M2 100 ,smb.CELL_USAGE_CHARGE_AMT_M3 101 ,smb.CELL_USAGE_CHARGE_AMT_M4 102 ,smb.CELL_USAGE_CHARGE_AMT_M5 103 ,smb.CELL_USAGE_CHARGE_AMT_M6 492 ,smb.Avg_DEC_3M_USAGE_CHARGE_AMT as t2 493 494 495 on t1.product_id=t2.product_id; __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE. ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 496 497 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.20 seconds cpu time 0.19 seconds 498 499 500 501 502 503 504 505 506 507 508 509 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 521
... View more