I am trying to modify a value in a field in one data set based on criteria for this and another data set. Here is my current code, which doesn't work. My code should change the hazard code from MO to WM in table B where the claim number is the same between the two tables and there are values in the first table for both loss causes WM and WI. proc sql; UPDATE TABLE_B AS B HAZARD_CODE_INDICATOR = 'WM' FROM TABLE_A AS A where A.CLM_NBR = B.CLM_NBR AND A.LOSS_CAUSE = 'MO' AND (B.HAZARD_CODE_INDICATOR = 'WM' AND B.VALUES <> 0) AND (B.HAZARD_CODE_INDICATOR = 'WI' AND B.VALUES <> 0)); quit; Here are the error messages I receive: 23 proc sql; 24 UPDATE TABLE_B AS B 25 HAZARD_CODE_INDICATOR = 'WM' _____________________ 79 26 FROM FROM TABLE_A AS A ____ __ 22 76 202 ERROR 79-322: Expecting a SET. 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. 26 ! FROM FROM TABLE_A AS A __ 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, ^, ^=, |, ||, ~, ~=. Thank you for any help you can provide, Christine
... View more