Hello, I`` trying to make it so a second query will only start depending on the result of a second query using %sysfunc macro. I'm getting an error message saying a parenthesis is required, but there is one so I do not understands. Using SAS Enterprise Guide Version 8.2 Here's a copy of the log: 184 185 %let Result_of_sys_check = %sysfunc(sql, SELECT count(warning_ind) FROM work.warning_check WHERE warning_ind = 1); ERROR: Expected open parenthesis after macro function name not found. 186 %if &Result_of_sys_check > 0 %then %do; ERROR: Required operator not found in expression: SELECT count(warning_ind) FROM work.warning_check WHERE warning_ind = 1) > 0 ERROR: Skipping to next %END statement. 187
... View more