SAS data warehousing enables you to bring together an integrated view of your suppliers, your customers, and your entire organization, and serves as the foundation for producing strategic insights in a low-risk manner. Using this reference, you can learn how to write SAS Component Language (SCL) applications that publish HTML pages containing the current metadata for a data warehouse, change pathnames in metadata, add columns to a table, update a column attribute, add tables and other objects defined by metadata and use the API in a SAS macro to generate a LIBNAME statement. New features described in this guide include how you can add and update the PATH property for the WHEFILE type; how you can now use the metadata API to add, update, and delete process objects; how you can write OLAP objects through the metadata API; how metadata for columns that are selected using point and click in the Expression Builder and that are used in either a WHERE clause or a row selector is surfaced through the WHSUBSET and WHROWSEL types; and how you can update the EXTENDED ATTRIBUTES property and other properties in the WHCOLTIM type. This title is also available online. This title is for programmers who develop client applications that read or write the metadata for SAS/Warehouse Administrator. Supports releases 9.1 and higher of SAS software.
Description:
SAS data warehousing enables you to bring together an integrated view of your suppliers, your customers, and your entire organization, and serves as the foundation for producing strategic insights in a low-risk manner. Using this reference, you can learn how to write SAS Component Language (SCL) applications that publish HTML pages containing the current metadata for a data warehouse, change pathnames in metadata, add columns to a table, update a column attribute, add tables and other objects defined by metadata and use the API in a SAS macro to generate a LIBNAME statement. New features described in this guide include how you can add and update the PATH property for the WHEFILE type; how you can now use the metadata API to add, update, and delete process objects; how you can write OLAP objects through the metadata API; how metadata for columns that are selected using point and click in the Expression Builder and that are used in either a WHERE clause or a row selector is surfaced through the WHSUBSET and WHROWSEL types; and how you can update the EXTENDED ATTRIBUTES property and other properties in the WHCOLTIM type. This title is also available online. This title is for programmers who develop client applications that read or write the metadata for SAS/Warehouse Administrator. Supports releases 9.1 and higher of SAS software.