CREATE TABLE statement

[GreggB]

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;

[PeterClemmensen · Accepted solution]

1 is enough

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