08-24-2012 03:11 PM
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.
08-24-2012 03:42 PM
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.