set<str> Ports;/* this is a set of Ports*/
set<str> IC; /* this is a set of DCs*/
num OutboundLinehaul {IC,DC}; /*This is an array of OutboundLinehaul Costs indexed over IC and DC*/
/*read data into the OutboundLinehaul parameter*/
read data PUBLIC.Outbound_Linehaul into [IC DCCode] OutboundLinehaul=Rate;
print OutboundLinehaul;
I get a warning like this. I am not sure if this is going to affect my model or should I do something to fix this. I am not sure what does invalid target indices mean.
WARNING: 18 non-missing values were discarded due to invalid target indices.
IC and DC are all strings by definition.
the variable Rate is a number
Thanks rob again. What you said is spot on. There was one missing DC that I need to take care of. AFter that it was all good.
Perfect. Thanks
An associated question about this. I have a list of 15 members in my index set. I have a binary variable that I associated with this set. I am having this as binary because i want to set some or all of the sites to be open or closed depending on specific scenario.
Can I say , %let Build ['xxx']=1; to mean that the binary variable called build for this particular 'xxx' is assigned 1 meaning it is open and on the same token %let Build ['yyy']=0; to mean that it is closed? I ran it but everything is assigned to 0. What could fix this?
Excllent. "FIX" fixed it perfect 🙂 thank u
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.