BookmarkSubscribeRSS Feed
user24feb
Barite | Level 11

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")).

2 REPLIES 2
lipury
SAS Employee

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

user24feb
Barite | Level 11

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!

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Multiple Linear Regression in SAS

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.

Discussion stats
  • 2 replies
  • 861 views
  • 3 likes
  • 2 in conversation