Input Data Sets

All SAS macros described in this chapter use a SAS input data set that contains the indented bill 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 Indented BOM Data Set in Chapter 3 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 Indented BOM Data Set in Chapter 3 for details regarding the records in this data set.

A simple Indented BOM data set, IndBOM, is displayed in Figure 4.1. It contains two indented bill 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 postprocessing 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 Product Structure Data Set in Chapter 3 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 Part Master Data Set in Chapter 3 for details about this SAS data set.

Figure 4.1: Indented BOM Data Set (IndBOM)

ABC Lamp Company
 
Indented Bill of Material

Obs _Level_ _Parent_ Paren_ID _Part_ Part_ID Desc QtyPer Fscrap Qty_Prod Unit LeadTime Tot_Lead LTOff Tot_Off SDate EDate _Prod_
1 0   . A101 0 Three-way socket assem. . . 1 Each 1 1 . 0 . . A101
2 1 A101 0 1500 1 Steel holder 1 0.0 1 Each 2 3 0 0 . . A101
3 2 1500 1 1400 2 1/4-20 Screw 2 0.0 2 Each 1 4 0 0 . . A101
4 1 A101 0 1601 3 Three-way socket 1 0.0 1 Each 2 3 0 0 . . A101
5 1 A101 0 1700 4 Wiring assembly 1 0.0 1 Each 1 2 0 0 . . A101
6 2 1700 4 2200 5 16-Gauge lamp cord 12 0.1 12 Feet 2 4 0 0 . 07APR2001 A101
7 2 1700 4 2210 6 14-Gauge lamp cord 12 0.1 12 Feet 2 4 0 0 08APR2001 . A101
8 2 1700 4 2300 7 Standard plug terminal 1 0.0 1 Each 1 3 0 0 . . A101
9 0   . LA01 8 Lamp LA . . 1 Each 2 2 . 0 . . LA01
10 1 LA01 8 A100 9 One-way socket assem. 1 0.0 1 Each 1 3 2 2 . . LA01
11 2 A100 9 1500 10 Steel holder 1 0.0 1 Each 2 5 0 2 . . LA01
12 3 1500 10 1400 11 1/4-20 Screw 2 0.0 2 Each 1 6 0 2 . . LA01
13 2 A100 9 1600 12 One-way socket 1 0.0 1 Each 2 5 0 2 . . LA01
14 2 A100 9 1700 13 Wiring assembly 1 0.0 1 Each 1 4 0 2 . . LA01
15 3 1700 13 2200 14 16-Gauge lamp cord 12 0.1 12 Feet 2 6 0 2 . 07APR2001 LA01
16 3 1700 13 2210 15 14-Gauge lamp cord 12 0.1 12 Feet 2 6 0 2 08APR2001 . LA01
17 3 1700 13 2300 16 Standard plug terminal 1 0.0 1 Each 1 5 0 2 . . LA01
18 1 LA01 8 B100 17 Base assembly 1 0.0 1 Each 1 3 0 0 . . LA01
19 2 B100 17 1100 18 Finished shaft 1 0.0 1 Each 2 5 0 0 . . LA01
20 3 1100 18 2100 19 3/8 Steel tubing 26 0.2 26 Inches 3 8 0 0 . . LA01
21 2 B100 17 1200 20 6-Diameter steel plate 1 0.0 1 Each 3 6 0 0 . . LA01
22 2 B100 17 1300 21 Hub 1 0.0 1 Each 2 5 1 1 . . LA01
23 2 B100 17 1400 22 1/4-20 Screw 4 0.0 4 Each 1 4 3 3 . . LA01
24 1 LA01 8 S100 23 Black shade 1 0.0 1 Each 2 4 0 0 . . LA01