topic Re: ERROR 79-322: WHERE CLAUSE in SAS Enterprise Guide

ERROR 79-322: WHERE CLAUSE

bhca60 — Tue, 12 Jul 2022 14:17:43 GMT

Keep getting an error when doing WHERE clause (I tried single quotes, double quotes, semi-colons, commas - still getting errors):

23         proc sql;
24         create table PPP
25         as select
26         a.pid,
27         a.pcpNPI format=20. as pcpNPI2,
28         from TABLEf as A
29         inner join num1 as B
30        on a.pid=b.pid
31         where a.pcpNPI2 in ('444444444';
                                          _
                                          79
ERROR 79-322: Expecting a ).

Re: ERROR 79-322: WHERE CLAUSE

Tom — Tue, 12 Jul 2022 14:21:47 GMT

I would try doing what the error message says and add in the closing parenthesis required when using the IN operator.

Re: ERROR 79-322: WHERE CLAUSE

bhca60 — Tue, 12 Jul 2022 14:23:25 GMT

There were parentheses on it but i thin becuase its separates by a semi-colon it's not reading it.

Re: ERROR 79-322: WHERE CLAUSE

Tom — Tue, 12 Jul 2022 14:28:02 GMT

@bhca60 wrote:
There were parentheses on it but i thin becuase its separates by a semi-colon it's not reading it.

Huh? Semicolon marks the END of the STATEMENT. If you have a list of values for the IN operator you can use a space or a comma (or a combination).

where age in (10,12,13)
where age in (14 15 16)
where name in ('Alfred' 'Alice')

Re: ERROR 79-322: WHERE CLAUSE

Kurt_Bremser — Wed, 13 Jul 2022 09:17:07 GMT

@bhca60 wrote:
There were parentheses on it but i thin becuase its separates by a semi-colon it's not reading it.

Then you did not post the complete log, something we request again and again and again. Please do so in the future.

Re: ERROR 79-322: WHERE CLAUSE

PaigeMiller — Wed, 13 Jul 2022 11:43:22 GMT

where a.pcpNPI2 in ('444444444';

SAS will always report an error when you have mis-matched or un-matched parentheses. So the error message tells you that SAS is expecting a parenthesis.

Isn't this what you really want?

where a.pcpNPI2 in ('444444444');