sas - Optmodel create data with 2 key-columns Optmodel -

-

i have vector x 3 sets [origin, destination, product] has value, , want create table has key columns origin , destination , every product column saying how transport.

so like:

origin dest. producta productb...

a.........ab.......10......0

a.........ac.......5.......4

i'm trying this, in optmodel:

create data ctrl3.transport      [origin destination] = {fab, cities}     {k in product} <col('product_'||k) = x[origin, destination, k]>; run;

but sas doesn't seem it

tldr;

the fix use {fi in fab, ci in cities} instead of {fab,cities}. use fi , ci instead of origin , destination. comments in code below explain further. more details after code.

code example

proc optmodel;     set fab                   init /rdu/;     set cities                init /bcn mel/;     set product               init /planes trains automobiles/;     num x{fab,cities,product} init [ /* bcn */ 3 4 5   /* mel */ 6 7 8];     put x[*]=; /* verify declarations */      /* efficient solution.         in columns, use fi , ci, not origin , destination */     create data work.transport          [origin destination] = {fi in fab, ci in cities}         {k in product} <col('product_'||k) = x[fi, ci, k]>     ;     /* works because key-set set expression, confusingly,        not same index set expression.        difference important: version creates redundant set        of arity 2. */     create data work.works_but_is_inneficient          [origin destination] = ({fab, cities})         {k in product} <col('product_'||k) = x[origin, destination, k]>     ;         /* original approach.         fails because when key-set index set expression,        optmodel looks there dummy parameters.      create data work.op          [origin destination] = {fab, cities}         {k in product} <col('product_'||k) = x[origin, destination, k]>     ; */    quit;

details

for efficiency, optmodel has 2 similar types of expressions confuse advanced users:

  • set expression, evaluates code , returns set
  • index set expression, returns set of expressions.

you can associate dummy variables index set expression. in create data statement, when optmodel sees index set expression, uses dummy variables instead of names in square brackets. since in op there no such dummy variables, error.


Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more