Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mrJET
-
SAS PROC SQL UPDATE
Assuming that CUST_ID and ID is enough for identifying unique rows in both tables the below SQL works fine. PROC SQL; UPDATE MASTER SET CITY = (SELECT INFILE.CITY FROM INFILE WHERE INFILE.CUST_ID = MASTER.ID) ,AMT = (SELECT...- mrJET
- Post #5
- Forum: SAS Institute, Inc. solutions
