topic Re: Syntax error in Proc SQL in SAS Programming

Syntax error in Proc SQL

saspert — Fri, 24 Aug 2012 19:11:16 GMT

Hi,

One of my colleagues is getting a syntax error with proc sql. The code and the error is below -

substr(a.PROV_ID,(position('~' in A.PROV_ID )+1),3) as MBR_PCP_SITE

ERROR 79-322: Expecting a SELECT.

ERROR 76-322: Syntax error, statement will be ignored.

Any suggestions would be appreciated. The DB engine is teradata.

Thanks,

saspert.

Re: Syntax error in Proc SQL

Doc_Duke — Fri, 24 Aug 2012 19:42:01 GMT

I don't think that you can use the "IN" operator from base SAS in PROC SQL; it gets confused with the "IN" condition from a SELECT statement. You can probably reframe the position function using the INDEXC function to get around the problem.

Re: Syntax error in Proc SQL

PGStats — Fri, 24 Aug 2012 19:46:36 GMT

Replace position('~' in A.PROV_ID ) by findc(A.PROV_ID, '~').