Syntax error in Proc SQL

[saspert]

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

                                  79

                                  76

  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.

[Doc_Duke]

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.

[PGStats]

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

PG