|
oercim wrote:
> I want join these tables such "one table below another table" using
> PROC SQL statements.
The safest way to stack tables in SQL is to use OUTER UNION CORRESPONDING.
SQL can stack upto 32 tables at a time. Various problems can occur when
same named columns in different tables have different attributes (type,
length, format, label, etc.)
--------------------------------------------
Proc SQL;
create table stacked as
select * from table1
OUTER UNION CORRESPONDING
select * from table2
...
OUTER UNION CORRESPONDING
select * from table32
;
quit;
--------------------------------------------
OUC is operationally equivalent to SET table1 table2 ... tableN;
--
Richard A. DeVenezia
http://www.devenezia.com/
| 
