Bill-of-Material Post-Processing Macros |
%BOMRSUW: Summarized Where-Used List
%bomrsuw ( | ROOT=root, IN=SAS-data-set, LEV=variable, COMP=variable, |
| QUANTITY=variable, QTYPROD=variable, RID=variables, |
| QTYUSED=qtyused, OUT=SAS-data-set, DROP=variables); |
constructs a summarized where-used list for a given item
referred to as the item Root, which
lists all parent items in which the item Root is directly or indirectly
used and the required quantities. Unlike the indented where-used list, it
does not list the levels of manufacture (Cox and Blackstone, J. H., Jr. 1998).
The parameters for this macro are as follows:
- ROOT=root
- specifies the part number of the item
for which the summarized where-used list is constructed.
This item is referred to as the item Root.
You must specify either a number or a quoted string for the ROOT= parameter,
depending on the type of the Component variable.
- IN=SAS-data-set
- names the Indented BOM input data set.
The default value is the most recently created SAS data set.
A null value is replaced by the default value.
- LEV=variable
- identifies the variable in the Indented BOM
data set that contains the indenture level information.
The default value is _Level_.
A null value is replaced by the default value.
- COMP=variable
- identifies the variable in the Indented BOM
data set that contains the component's part number.
This variable is referred to as the Component variable.
The default value is _Part_.
A null value is replaced by the default value.
- QUANTITY=variable
- identifies the variable in the Indented
BOM data set that contains the quantity per assembly information. This
variable is only needed in creating the default drop variables.
The default value is Qty_Per. A null value
tells the macro program not to look for the variable that
contains the quantity per assembly information.
- QTYPROD=variable
- identifies the variable in the Indented
BOM data set that contains the quantity per product information.
The default value is Qty_Prod.
A null value is replaced by the default value.
- RID=variables
- identifies variables in the Indented
BOM data set that contain product structure information and are not
specified in COMP= or QUANTITY= parameters. These variables are only
needed in creating the default drop variables.
If you do not specify this parameter or specify a null value,
the macro program assumes the Indented BOM data set contains no
RID variables.
- QTYUSED=qtyused
- specifies the name for the variable
in the output data set that contains the quantity of the item
Root used by the parent item identified by the Component variable.
The default value is Qty_Used.
A null value is replaced by the default value.
The Indented BOM data set should not contain any variables with
the name specified by the QTYUSED= parameter. Otherwise, the values
of the variable with the name specified in the QTYUSED= parameter
will be overwritten.
- OUT=SAS-data-set
- names the output data set that contains
summarized where-used list data for the item Root.
The default value is _BOMOUT_.
A null value is replaced by the default value.
- DROP=variables
- specifies all variables in the Indented
BOM data set that you do not want to be included in the output
data set. The default value is the list that contains the variables
specified in the
LEV=, QUANTITY=, QTYPROD=, and RID= parameters, in addition
to the _Parent_,
Paren_ID, Part_ID, _Prod_, Tot_Lead,
and Tot_Off variables, if they are in the Indented BOM data set.
A null value tells the macro program to write all the
variables in the Indented BOM data set to the output data set.
The input data set of this macro is the Indented BOM data set
described in the section "Input Data Sets". The following parameters
specify the variables in the input data set that are required
by the %BOMRSUW macro.
- COMP=
- A character or numeric variable that contains the part
number of the component.
- LEV=
- A numeric variable that contains the indenture level
information.
- QTYPROD=
- A numeric variable that contains the quantity per product
information.
The following parameters specify the variables in the Indented BOM
input data set that are used by the macro, if they can be found in
the data set.
- QUANTITY=
- A numeric variable that contains the quantity per
assembly information. This variable is only needed
in creating the default drop variables.
- RID=
- Variables that contain product structure information,
except for those specified in the COMP= or
QUANTITY= parameters. These variables are only needed
in creating the default drop variables.
- DROP=
- Variables that you do not want to be included in the
output data set. These variables are optional.
The output data set contains the summarized where-used list for the item
Root. This data set has the same variables
as the Indented BOM data set, except for
the variables specified in the DROP= parameter. The output
data set contains a new variable with the name specified by the following
parameter:
- QTYUSED=
- A numeric variable that contains the total quantities of
the item Root used, directly or
indirectly, in the item identified by the Component variable.
Upon completion, this macro defines a macro variable, _BOMRSUW_,
which contains a character string that indicates the status of the
macro execution. See the section "Macro Variables" for the possible values
of this macro variable.
The following statement constructs a summarized where-used list for the item
'1400' from the Summarized BOM data set as displayed in
Figure 3.1.
%bomrsuw(root='1400', in=IndBOM, quantity=QtyPer,
qtyused=QtyUsed, rid=SDate EDate LTOff Fscrap,
out=BomOut6);
The summarized where-used list for the item '1400' is displayed
in Figure 3.7. Note that a summarized where-used lists a parent
item only once for the total quantity of the given component (the item
'1400' in this example) used
by the parent item. For example, the item
'LA01' uses 6 units of the item '1400', 4 units for
making the item 'B100' and 2 for making '1500'. However,
the summarized where-used list displayed in Figure 3.7 shows that
the item '1500' uses 4 units of '1400'. This is because
another 2 units are used in the bill of material for the end item
'A101'.
1500 |
Steel holder |
Each |
2 |
4 |
A100 |
One-way socket assem. |
Each |
1 |
2 |
A101 |
Three-way socket assem. |
Each |
1 |
2 |
B100 |
Base assembly |
Each |
1 |
4 |
LA01 |
Lamp LA |
Each |
2 |
6 |
|
Figure 3.7: Summarized Where-Used List for Item 1400 (BomOut6)
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.