Previous Page

|

Next Page

Input Data Sets

All SAS macros described in this chapter use a SAS input data set that contains the indented bills of material for all end items of the product line, plant, or company. This data set is referred to as the Indented BOM data set. It is typically the Indented BOM output data set created by PROC BOM. See the section "Indented BOM Data Set" in Chapter 2 for details about the variables and special structure of this SAS data set. Not every variable in the Indented BOM data set is needed in all macros. The variables required by each macro depend on the requirements of the macro, and are listed in the corresponding section describing each macro. Note that the macros depend heavily on the form of the Indented BOM data set that

• contains the complete indented bill of material for each end item.
• lists the components of each indented bill of material in the depth-first order.

Refer to Aho, Hopcroft, and Ullman (1983) for details about depth-first ordering. See also the section "Indented BOM Data Set" in Chapter 2 for details regarding the records in this data set.

A simple Indented BOM data set, IndBOM, is displayed in Figure 3.1. It contains two indented bills of material, one for the item 'A101' and the other for the item 'LA01'. You can easily check that each indented bill of material in this data set lists its components in depth-first order. The data set IndBOM is used as the Indented BOM input data set in all examples in this chapter. You specify the name of the Indented BOM data set using the IN= parameter. If you do not provide a name when calling a post-processing macro, the macro uses the most recently created SAS data set as the Indented BOM data set.

One SAS macro, %BOMTCNP, requires an additional data set that contains the product structure record for the new parent-component relationship that will be created while performing the copy-and-paste transaction. This data set is referred to as the Product Structure data set. See the section "Product Structure Data Set" in Chapter 2 for details about this SAS data set.

Another SAS macro, %BOMTSAE, requires another data set that contains the part master record for the item specified in the ROOT= parameter of the macro. This data set is referred to as the Part Master data set. See the section "Part Master Data Set" in Chapter 2 for details about this SAS data set.