SAS/Warehouse Administrator Metadata API- P14: 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. | 62 Reading Process Flow Metadata A Chapter 3 a separate job Customer ODD Job. Customer ODD is an input to the Customer Detail Job. In the previous display note that one event has been defined for the Toy Store Whouse. An event is a metadata record that specifies a condition for controlling a job such as checking for certain return codes or verifying the existence of a file. To use events you must create them include them in a job flow and then write a metadata API program that reads the job flow and generates code for it. Job flows are displayed in the Job View of the Process Editor. In order to switch from the Process View to the Job View in the right panel of the Process Editor click the right mouse button in the background and select Job View from the pop-up menu. The right panel in the following display illustrates a job flow that has been defined for the Customer Detail Job. Display Process Editor Job Hierarchy and Job View Reading Process Flow Metadata In SAS Warehouse Administrator a process is a metadata record that is used to generate or retrieve a routine that creates warehouse data stores or one that extracts data transforms data or loads data into data stores. You can link these tables together to form a process flow. The Process Editor in SAS Warehouse Administrator is used to create process flows such as the one shown in the following figure. SAS Warehouse Administrator Metadata Types A Reading Process Flow Metadata 63 Figure Process Flow in SAS Warehouse Administrator Process Editor Cre Data Table Mapping I i ODD I In the previous figure information moves from the bottom up from the ODD named ODD 1 to a mapping step to the Credit data table. The icons shown in the figure ODD 1 and Credit data table represent loadable tables. A loadable table can be a source such as ODD 1 in the figure a target such as Credit data table or both a target and a source. The Mapping box that is shown in the figure represents an intermediate output table the .
