@simrut wrote: PROC SQL; Create Table Employee AS SELECT A.NAME,A.SALARY,B.DEPT FROM EMP1 A LEFT JOIN DEPARTMENT B ON A.EMP_ID= B.EMP_ID ; QUIT; /***************************************************/ PROC SQL; CREATE TEMPLE TEMP AS SELECT * FROM EMPLOYEE; QUIT; I am getting error 'Employee not found' Hope this helps:)
... View more