如何用proc sql创建多张表

shiyiming

RT；
如何想data step那样同时创建多个数据集？谢谢！

shiyiming

OPTIONS MLOGIC MPRINT SYMBOLGEN;

%MACRO MULTITABLES;
%DO I = 1 %TO 5;
        PROC SQL;
        CREATE TABLE TAB&I (ID CHAR(8), NAME_&I CHAR(3));
        QUIT;
%END;
%MEND MULTITABLES;

%MULTITABLES; RUN;

shiyiming

我刚想说PROC SQL主要是连结表用的，貌似没有创建多张表，结果一看，还真有。

PROC SQL <option(s)>;
CREATE TABLE table-name  (column-specification<, ...column-specification | constraint-specification>)  
;  
CREATE TABLE table-name LIKE table-name2;  
CREATE TABLE table-name AS query-expression  <ORDER BY order-by-item<, ... order-by-item>>;  

CREATE VIEW proc-sql-view AS query-expression  <ORDER BY order-by-item<, ... order-by-item>>  
<USING libname-clause<, ... libname-clause>> ;  

学到了

shiyiming

Proc SQL 是SAS里面的SQL,基本功能都有，包含：

Data Manipulation Language:Insert, update, delete
Data Definition Language:创建表create，修改表alter，删除表drop.