Seems I'm hung up here. The reference to sum(_:) is my attempt to apply the sum() function to all my variables beginning with _. For instance I may have variables: _04_11_2016 _3_26_2016 etc.... The problem is these variables are the product of a previous Proc Transpose and they will not be the same with each run of the program. Is there a way to work around my issue? 108 proc sql;
109 CREATE TABLE cal_sums AS
110 select sum(total) as total, sum(_:), sum(null)
-
22
200
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, ), *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?,
AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^,
^=, |, ||, ~, ~=.
ERROR 200-322: The symbol is not recognized and will be ignored.
111 from FinalData
112 where rule_nm = 'MATCHING + NO SCORE IMPACTING'
113 and score_impacting='N';
114 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
... View more
