SAS/Warehouse Administrator Metadata API- P20: The operating system and SAS version that are associated with a given host are now available through the WHHOST property. For example, you can write a SAS/Warehouse Administrator add-in that reads the host metadata that is associated with a given data store and then uses these values to generate code that is appropriate for the operating system and SAS version. | 92 WHDATTBL A Chapter 3 Using WHCTRNFM Add Update Delete No Yes Yes WHCTRNFM is a dependent type. To understand how it relates to other types see the column mapping models in Relationships Among Metadata Types on page 53. WHDATTBL Metadata type for data tables Category Object Types Explorer Parent WHTABLE on page 254 Overview WHDATTBL models the metadata for data tables in SAS Warehouse Administrator. A data table is a multipurpose table. You can use it as a detail data store a summary data store a look-up table included as part of a join or a table that holds information that does not fit anywhere else. A data table can be a SAS table or view or a DBMS table or view. To add a data table with the SAS Warehouse Administrator Explorer 1 Select a data group with the right mouse button. 2 Select Add Item data table 3 Select the data table with the right mouse button. 4 Select Properties. 5 Enter the data table information. Properties The following table lists all of the properties for WHDATTBL and indicates how you can use each property with metadata API methods. In the table you can pass properties with a Yes in the Add column to the _ADD_METADATA_ method. Use this method to add a new object. You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method. Use this method to update properties of an existing object. Req indicates that the property is required you must provide a value for this property when you use a given method. Default indicates that the system will provide a default value for that property if you do not provide one. SAS Warehouse Administrator Metadata Types A WHDATTBL 93 Properties with a Yes in the Read Method Expand Parm column are valid with the expand parameter of the _GET_METADATA_ method. This method enables you to get detailed metadata about a property and its associated objects through a single method call. Properties Type Add Method Update Method Read Method Expand Parm. Access Same As Physical N Yes Yes No .
