Sure. The actual log follows. Thanks. 1 The SAS System 10:27 Friday, January 23, 2015 1 %_eg_hidenotesandsource; 5 %_eg_hidenotesandsource; 28 29 libname L_P1 "\\SAS01\sasusers\Shared\PredictiveModeling"; NOTE: Libref L_P1 was successfully assigned as follows: Engine: V9 Physical Name: \\SAS01\sasusers\Shared\PredictiveModeling 30 31 proc sql noprint; 32 select name 33 into :vars separated by ' ' 34 from L_P1.UWR_10YRDATA 35 where libname='L_P1' and 36 upcase(memname)='UWR_10YRDATA' and 37 upcase(name) ne 'BLEND_GROSS_LOAD' and 38 type='num'; ERROR: The following columns were not found in the contributing tables: libname, memname, name, type. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 39 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.01 seconds 40 41 proc corr data = L_P1.UWR_10YRDATA; 42 var &vars.; _ 22 200 WARNING: Apparent symbolic reference VARS not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, ;, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 200-322: The symbol is not recognized and will be ignored. 43 with BLEND_GROSS_LOAD; 44 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE CORR used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 45 46 libname L_P1 clear; NOTE: Libref L_P1 has been deassigned. 47 48 49 %_eg_hidenotesandsource; 61 62 63 %_eg_hidenotesandsource; 66
... View more
