https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780315#M31620 <P>Hi,</P><P>I can't get this simple Where statement to work</P><P>&nbsp;</P><P>data output.PCE_meds;<BR />set output.RXClaims;<BR />Where SYSCORTFlag ='Y' or BRONCHOFlag 'Y';<BR />run;</P><P>&nbsp;</P><P>This is the error that I get when running to the above code:</P><P>SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES<BR />SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE<BR />31<BR />32 data output.PCE_meds;<BR />33 set output.RXClaims;<BR />34 Where SYSCORTFlag ='Y' or BRONCHOFlag 'Y';<BR />___<BR />22<BR />76<BR />ERROR: Syntax error while parsing WHERE clause.<BR />ERROR 22-322: Syntax error, expecting one of the following: !, !!, &amp;, *, **, +, -, /, &lt;, &lt;=, &lt;&gt;, =, &gt;, &gt;=, ?, AND, CONTAINS, EQ,<BR />GE, GT, LE, LIKE, LT, NE, OR, ^=, |, ||, ~=.</P><P>ERROR 76-322: Syntax error, statement will be ignored.</P> Mon, 15 Nov 2021 23:04:47 GMT Jesusismygrace 2021-11-15T23:04:47Z https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780315#M31620 <P>Hi,</P><P>I can't get this simple Where statement to work</P><P>&nbsp;</P><P>data output.PCE_meds;<BR />set output.RXClaims;<BR />Where SYSCORTFlag ='Y' or BRONCHOFlag 'Y';<BR />run;</P><P>&nbsp;</P><P>This is the error that I get when running to the above code:</P><P>SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES<BR />SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE<BR />31<BR />32 data output.PCE_meds;<BR />33 set output.RXClaims;<BR />34 Where SYSCORTFlag ='Y' or BRONCHOFlag 'Y';<BR />___<BR />22<BR />76<BR />ERROR: Syntax error while parsing WHERE clause.<BR />ERROR 22-322: Syntax error, expecting one of the following: !, !!, &amp;, *, **, +, -, /, &lt;, &lt;=, &lt;&gt;, =, &gt;, &gt;=, ?, AND, CONTAINS, EQ,<BR />GE, GT, LE, LIKE, LT, NE, OR, ^=, |, ||, ~=.</P><P>ERROR 76-322: Syntax error, statement will be ignored.</P> Mon, 15 Nov 2021 23:04:47 GMT https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780315#M31620 Jesusismygrace 2021-11-15T23:04:47Z https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780316#M31621 <P><SPAN>Where SYSCORTFlag ='Y' or BRONCHOFlag = 'Y';</SPAN></P> <P>&nbsp;</P> <P><SPAN>Add an equal sign in front of the second 'Y'.</SPAN></P> Mon, 15 Nov 2021 23:09:56 GMT https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780316#M31621 WarrenKuhfeld 2021-11-15T23:09:56Z https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780317#M31622 Thank you!!! Mon, 15 Nov 2021 23:11:42 GMT https://communities.sas.com/t5/New-SAS-User/Can-t-get-Simple-Where-Statement-to-work/m-p/780317#M31622 Jesusismygrace 2021-11-15T23:11:42Z