Thanks, but this is the error I get now. 2866 proc sql; 2867 update db.drug_exposure as t1 2868 set drug_concept_id = t2.drug_cid 2869 From dtext.txtmatch as t2 ---- -- 22 76 202 ERROR 22-322: Syntax error, expecting one of the following: ;, !!, *, **, +, ',', -, /, WHERE, ||. ERROR 76-322: Syntax error, statement will be ignored. ERROR 202-322: The option or parameter is not recognized and will be ignored. 2869! From dtext.txtmatch as t2 -- 22 ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. 2870 Where t1.drug_exposure_id=t2.drug_exposure_id; 2871 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.03 seconds
... View more