Hi, Thanks for your time. There were errors in the code so I modified it a bit before it worked: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc freq data=agents_exp(where=(sum(of a1-a4)=0))); __ _ 22 200 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, GE, GT, LE, LIKE, LT, NE, OR, ^=, |, ||, ~=. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 73 ! proc freq data=agents_exp(where=(sum(of a1-a4)=0))); _ 22 ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: ;, COMPRESS, DATA, FC, FORMCHAR, NLEVELS, NOPRINT, ORDER, PAGE. 74 table lung; 75 76 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 88 I modified as: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc freq data=agents_exp(where=(sum(a1,a2,a3,a4)=0)); 74 table lung; 75 run; NOTE: There were 4 observations read from the data set WORK.AGENTS_EXP. WHERE SUM(a1, a2, a3, a4)=0; NOTE: PROCEDURE FREQ used (Total process time): real time 0.25 seconds cpu time 0.24 seconds 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89 Thanks. ak.
... View more