BookmarkSubscribeRSS Feed
simrut
Calcite | Level 5

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.

6 REPLIES 6
PeterClemmensen
Tourmaline | Level 20

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

 

 Udklip.PNG

simrut
Calcite | Level 5

It is just an example on what I am working on explained in the below steps.

  1. B is another table existing in database and I am creating a table A selecting data from B.
  2. Then creating another table C selecting data from table A created in the previous step

 

PeterClemmensen
Tourmaline | Level 20

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 🙂

simrut
Calcite | Level 5
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:)
Kurt_Bremser
Super User

@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.

ballardw
Super User

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 937 views
  • 0 likes
  • 4 in conversation