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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.