Example Analysis of Table Link proc sql
This article shares with you the content of a sample analysis of table linking proc sql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.
/ * 21.1.1 simple connection * / proc sql;select * from resdat.china, resdat.usa;quit/*21.1.3 internal connection * / proc sql;select * from resdat.china, resdat.usawhere china.level=usa.level;quit;/*21.1.3.1 uses the alias of the table * / proc sql;select * from resdat.china as a, resdat.usa as bwhere a. Levellevelb.levelquitoes * * 21.1.3.2 use aliases for self-join of tables * / proc sql Select * from resdat.china a, resdat.china bwhere a.level
