Substring in inner join with contains sas

Asked Mar 01 '17 at 14:22

Active Mar 01 '17 at 16:17

Viewed 981 times

I'm trying to run the following code

PROC SQL; 
    CREATE TABLE _check AS 
    SELECT DISTINCT * FROM table1 as a 
        INNER JOIN  table2 as b
          ON ON UPCASE(b.Cname) contains UPCASE(SUBSTRING(CNAMN, 1, 4))
    ;
quit;

but I get the error

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.

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

any clues? What is the correct syntax to handle substrings in a contains?

Thanks in advance

edited Mar 01 '17 at 16:17

Joe

62,789
6
49
67

asked Mar 01 '17 at 14:22

bettingdelo

2

You typed `ON` two times – Robert Soszyński Mar 01 '17 at 14:25
You may also want to reference table `a` in the `substring` statement. – J_Lard Mar 01 '17 at 14:26
`SUBSTRING` is also not the name of the `SUBSTR` function in SAS. – Joe Mar 01 '17 at 16:17

Substring in inner join with contains sas

0 Answers0