Example: Editing Load Process Properties for SAS/Warehouse Administrator Generated Code

specifies the level of code that SAS/Warehouse Administrator will use to generate the code and it also lists all possible Load process options.

Code generation level 2.0 is the level of code generated by SAS/Warehouse Administrator Release 2.0 (the current release). It uses SAS/ACCESS LIBNAME statements to read and write data in DBMS format. (SQL Pass-Through views are used for some tasks associated with DBMS tables, such as reading or writing DBMS indexes.)

Code generation level 1.1 is the level of code generated by SAS/Warehouse Administrator Releases 1.1, 1.2, and 1.3. It creates an SQL Pass-Through view to access DBMS data and uses PROC DBLOAD to load data into DBMS tables.

For more information about the levels of code, when to use one or the other, and other Load process options such as the Load Time column, click Help on a specific data store's Load Process Attributes window.