I have not been able to find the correct syntax for updating multiple fields in my 'master' data set with information from my 'infile' data set. I tried this in vain:
PROC SQL;
UPDATE MASTER
SET CITY = IN.CITY
,AMT = IN.AMT
,etc. more fields
FROM MASTER MS
LEFT JOIN
INFILE IN
ON MS.ID = IN.CUST_ID
AND MS.NAME = IN.CUST_NAME
AND etc...more fields
;
QUIT;
The join variables in INFILE are not the same name as those in MASTER and the user doesn't want the names changed. That prohibits a data step MERGE solution and, besides, isn't this what PROC SQL is here for? Needless to say I've Googled hard and long. Thanks for anyone's help.
PROC SQL;
UPDATE MASTER
SET CITY = IN.CITY
,AMT = IN.AMT
,etc. more fields
FROM MASTER MS
LEFT JOIN
INFILE IN
ON MS.ID = IN.CUST_ID
AND MS.NAME = IN.CUST_NAME
AND etc...more fields
;
QUIT;
The join variables in INFILE are not the same name as those in MASTER and the user doesn't want the names changed. That prohibits a data step MERGE solution and, besides, isn't this what PROC SQL is here for? Needless to say I've Googled hard and long. Thanks for anyone's help.