DATA Step, Macro, Functions and more

CREATE TABLE statement

Accepted Solution Solved
Reply
Super Contributor
Posts: 279
Accepted Solution

CREATE TABLE statement

Can 2 different tables be created in a single proc sql statement or does it require 2 different statements?

 

PROC SQL;
CREATE TABLE WORK.PAYROLLMASTER
AS SELECT *
FROM SASUSER.PAYROLLMASTER;
QUIT;
PROC SQL;
CREATE TABLE WORK.MARCHFLIGHTS
AS SELECT *
FROM SASUSER.MARCHFLIGHTS;
QUIT;


Accepted Solutions
Solution
‎06-20-2017 09:28 AM
PROC Star
Posts: 754

Re: CREATE TABLE statement

1 is enough

 

PROC SQL;
CREATE TABLE cars
AS SELECT *
FROM sashelp.cars;
CREATE TABLE class
AS SELECT *
FROM sashelp.class;
QUIT;

View solution in original post


All Replies
Solution
‎06-20-2017 09:28 AM
PROC Star
Posts: 754

Re: CREATE TABLE statement

1 is enough

 

PROC SQL;
CREATE TABLE cars
AS SELECT *
FROM sashelp.cars;
CREATE TABLE class
AS SELECT *
FROM sashelp.class;
QUIT;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 116 views
  • 0 likes
  • 2 in conversation