proc sql; create table work.flightdelays2 like sasuser.flightdelays;
proc sql; describe table work.flightdelays2;
NOTE: SQL table WORK.FLIGHTDELAYS2 was created like: create table WORK.FLIGHTDELAYS2( bufsize=8192 ) ( Date num format=DATE9. informat=DATE9., FlightNumber char(3), Origin char(3), Destination char(3), DelayCategory char(15), DestinationType char(15), DayOfWeek num, Delay num ); |
General form, DROP=,
and KEEP= data set options:
(DROP | KEEP =column-1< ...column-n>)
column
specifies the name
of a column to be dropped or kept. Multiple column names must be separated
by spaces. The entire option must be enclosed in parentheses.
|
proc sql;
create table work.flightdelays3
(drop=delaycategory destinationtype)
like sasuser.flightdelays;
For comparison, the
results of running the DESCRIBE TABLE statement for the original table
and the new table are shown below.
NOTE: SQL table WORK.FLIGHTDELAYS was created like: create table SASUSER.FLIGHTDELAYS( bufsize=8192 ) ( Date num format=DATE9. informat=DATE9., FlightNumber char(3), Origin char(3), Destination char(3), DelayCategory char(15), DestinationType char(15), DayOfWeek num, Delay num ); |
NOTE: SQL table WORK.FLIGHTDELAYS was created like:
create table WORK.FLIGHTDELAYS3( bufsize=4096 )
(
Date num format=DATE9. informat=DATE9.,
FlightNumber char(3),
Origin char(3),
Destination char(3),
DayOfWeek num,
Delay num
); |