topic CREATE TABLE statement in SAS Programming

CREATE TABLE statement

GreggB — Tue, 20 Jun 2017 13:19:27 GMT

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;

Re: CREATE TABLE statement

PeterClemmensen — Tue, 20 Jun 2017 13:26:44 GMT

1 is enough

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