SAS PROC SQL基础操作语句

SAS OnDemand for Academics

​​​​

CREATE 创建表

PROC SQL;
CREATE TABLE AUTHOR
(AUTHOR_NO INTEGER Primary Key,
FIRST_NAME VARCHAR (60),
LAST_NAME VARCHAR (60));

ADD 添加字段

proc sql;
alter table AUTHOR
ADD PHONE INTEGER,
ADDRESS VARCHAR(60);
QUIT;

DROP(1) 删除表

PROC SQL;
DROP TABLE AUTHOR;
QUIT;

(2) 删除字段

PROC SQL;
ALTER TABLE AUTHOR
DROP PHONE,ADDRESS;
QUIT;

INSERT 插入记录值

PROC SQL;
INSERT INTO AUTHOR(AUTHOR_NO,FIRST_NAME,LAST_NAME)
VALUES(1,'Archer','Jeffrey')
VALUES(2,'Christie','Agatha')
VALUES(3,'Clark','Arthur C');

SELECT (1) 基础查询

PROC SQL;
SELECT FIRST_NAME,LAST_NAME
FROM AUTHOR;

SELECT (2) 排序

PROC SQL;
SELECT FIRST_NAME,LAST_NAME
FROM AUTHOR
order by last_name desc;

SELECT (3) 条件查询

PROC SQL;
SELECT * from AUTHOR
where FIRST_NAME = 'Clark'
;
quit;

SELECT (4) 查询表记录数

PROC SQL;
SELECT count(*) FROM AUTHOR;
QUIT;

SELECT (5) 查询最值

PROC SQL;
select min(book_price) from book;
QUIT;

UPDATE 更新

proc sql;
update AUTHOR
set 
LAST_NAME = 'W';
quit;

 LIKE

PROC SQL; 
CREATE TABLE STORE 
LIKE BOOKSTORE;