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
It is just an example on what I am working on explained in the below steps. B is another table existing in database and I am creating a table A selecting data from B. Then creating another table C selecting data from table A created in the previous step
... View more
Hi Team, I have created a SAS table by Proc Sql and then tried to create another table from the table created first like teh below example: Proc SQL; CREATE TABLE A AS SELECT * from B; quit; PROC SQL; CREATE TABLE C AS SELECT * from A; quit; When I try executing the second SQL query I am getting error as A not found. Kindly Help.
... View more
Hi , I am trying to create a temporary table in SAS with below code: PROC SQL; CREATE VOLATILE TABLE TEMP AS (SELECT * FROM SASHELP.AIR) ; QUIT; and I m getting the following error 'Syntax error, expecting one of the following: DISTINCT, INDEX, TABLE, UNIQUE, VIEW' KIndly help.
... View more