SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Examples: SQL Procedure

Example 1: Creating a Table and Inserting Data into It

Features: CREATE TABLE statement

column-modifier

INSERT statement

VALUES clause

SELECT clause

FROM clause

Table name: Proclib.Paylist

This example creates the table Proclib.Paylist and inserts data into it.

Program

libname proclib 'SAS-library';

proc sql;

create table proclib.paylist

(IdNum char(4),

Gender char(1),

Jobcode char(3),

Salary num,

Birth num informat=date7.

format=date7.,

Hired num informat=date7.

format=date7.);

insert into proclib.paylist

values('1639','F','TA1',42260,'26JUN70'd,'28JAN91'd)

values('1065','M','ME3',38090,'26JAN54'd,'07JAN92'd)

values('1400','M','ME1',29769.'05NOV67'd,'16OCT90'd) ...