I am trying to flag multiple intermediate products as end items for proc bom. My final products start with (the character) "8", my intermediate products in question start out with a "2", the raw materials start with "4".
How can one specify multiple parts from the part master that start with a certain character in the proc bom statement - if it is possible at all?
The available examples from the internet seem to be restricted to a single intermediate product (like enditem=("LA01")). What I would like to achieve is a truncated equal to (like enditem=(Part =: "L")).
Thanks for your question! We were wondering if you might be able to filter your part master data set with SQL prior to running the BOM procedure. BOM doesn't support wildcards or masking as far as I know.
Regards,
Lindsey
SAS/OR Development
I think I have to use some post-processing, because some the intermediate products (4*) might consist of (other) "final" (2*) products. It helps to know that a have not overlooked some standard functionality, though. Many Thanks!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.