topic Re: Access Table created in SAS in SAS Programming

Access Table created in SAS

simrut — Wed, 05 Apr 2017 10:59:51 GMT

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.

Re: Access Table created in SAS

PeterClemmensen — Wed, 05 Apr 2017 11:05:07 GMT

Your code seems to be working on the following simple test data?

data B;
input var1 var2;
datalines;
1 2
3 4
5 6
;

Proc SQL;
CREATE TABLE A AS SELECT * from B;
quit;

PROC SQL;
CREATE TABLE C AS SELECT * from A;
quit;

See log below

Re: Access Table created in SAS

simrut — Wed, 05 Apr 2017 11:07:35 GMT

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

Re: Access Table created in SAS

PeterClemmensen — Wed, 05 Apr 2017 11:15:03 GMT

Can you provide some sample data or some of the actual code you are using, because nothing is wrong in the code you have posted above 🙂

Re: Access Table created in SAS

simrut — Wed, 05 Apr 2017 11:29:03 GMT

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:)

Re: Access Table created in SAS

Kurt_Bremser — Wed, 05 Apr 2017 12:25:47 GMT

@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:)

Post the log of both of those steps when running them in immediate succession.

Re: Access Table created in SAS

ballardw — Wed, 05 Apr 2017 14:41:08 GMT

@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:)