Comprehensive Tools for Bill-of-Material Processing

The BOM procedure performs bill-of-material processing. It reads all product structure records from a product structure data file and all part "master" records from a part master file, and composes the combined information into indented bills of material.

The output of PROC BOM can be viewed in a variety of formats. The simplest format is the single-level bill of material. It consists of a list of all components that are directly used in a parent item. It shows only the relationships one level down. On the other hand, a multilevel bill of material provides a display of all components that are directly or indirectly used in a parent item. When an item is a subcomponent, blend, intermediate, etc., then all of its components are also exhibited, down to purchased parts and raw materials. In the multilevel option, one can choose the indented or the summarized version.

Input data

Output data

PROC BOM generates single-level, Indented BOM or Summarized parts output data according to the option chosen. This data set is organized in such a manner that it can be easily retrieved and manipulated to generate reports, and can also be used by other SAS procedures to perform additional analysis.

Bill-of-Material Post-Processing Macros

In addition to PROC BOM, there is a collection of SAS macros that uses the Indented BOM data set as input data to create reports or perform specialized transactions for maintaining the bills of material. Based on their functionality they are broadly classified as "Reporting" macros and "Transactional" macros.

The reports generated by "Reporting" macros include

Some of the specialized transactions available through "Transactional" macros include

If used correctly these macros can go a long way in simplyfying the process of updating the bills of material for a product, product line, plant, or company.