1 The SAS System 08:54 Monday, October 29, 2018 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 OPTION DEBUG=DBMS_SELECT SQL_IP_TRACE=(NOTE, SOURCE); 4 PROC SQL NOEXEC; 5 SELECT (NUM= input( COMPRESS(t1.NON_WAREHOUSE_UOM, ,'dk') , 32.)) AS CALCULATION 6 FROM WORK.QUERY_FOR_PURCHASING_0000 t1; ERROR: The following columns were not found in the contributing tables: NUM. 7 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 8 %PUT SQL_IPTRACE_RESULT=&SYS_SQL_IP_ALL; SQL_IPTRACE_RESULT=-1 9 OPTIONS SQL_IP_TRACE=(NONE); 10 QUIT; RUN; 11
... View more
