Hi,
I can't get this simple Where statement to work
data output.PCE_meds;
set output.RXClaims;
Where SYSCORTFlag ='Y' or BRONCHOFlag 'Y';
run;
This is the error that I get when running to the above code:
SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES
SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE
31
32 data output.PCE_meds;
33 set output.RXClaims;
34 Where SYSCORTFlag ='Y' or BRONCHOFlag 'Y';
___
22
76
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ,
GE, GT, LE, LIKE, LT, NE, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.