VERSION 4.3 So i am pretty sure the language here is wrong, remember i am new to this, any kind help would be appreciated! if I select a field from one of my tables/another field ex: (t1.NCOVD_CHRG_AMT/t1.TOT_CHRG) i get error 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 OPTION DEBUG=DBMS_SELECT SQL_IP_TRACE=(NOTE, SOURCE); 4 PROC SQL NOEXEC; 5 SELECT (t1.NCOVD_CHRG_AMT/t1.TOT_CHRG) AS CALCULATION 6 FROM TABLE1.MEDA_ADJUD_CLM_HDR t1, TABLE2.MEDA_ADJUD_CLM_RSN t2, TABLE3.MEDA_ADJUD_REVN_LN t3 7 QUIT; ______ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ',', GROUP, HAVING, ORDER, WHERE. ERROR 76-322: Syntax error, statementw ill be ignored. 8 %PUT SQL IPTRACE_RESULT=&SYS_SQL_IP_ALL; SQL_IPTRACE_RESULT=-1 9 OPTIONS SQL_IP_TRACE=(NONE); 10 11 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 11 ! RUN; 12 ????????? What would i need to use for the advanced expression to receive a percentage without an error - PROC SQL NOEXEC; SELECT (t1.NCOVD_CHRG_AMT/t1.TOT_CHRG) AS CALCULATION FROM TABLE1.MEDA_ADJUD_CLM_HDR t1, TABLE2.MEDA_ADJUD_CLM_RSN t2, TABLE3.MEDA_ADJUD_REVN_LN t3 QUIT
... View more