Thank you for you quick reply, I don't understand how to keep the value char, the final problem is more complex then this one, I created sample tables like that: data VData; input i v remi $ class $; datalines; 1 100 205 MA 2 300 802 MB 3 600 605 PB 4 200 604 PB 5 300 725 SI 6 500 215 SI ; data PData; input i j p remi $ aop $ class $; datalines; 1 1 10 205 15 MA 2 1 11.25 802 18 MB 3 1 10 605 26 PB 4 1 11.5 604 35 PB 5 1 10.25 725 44 SI 5 2 12 725 42 SI 5 3 110.75 725 46 SI 6 1 10.25 215 87 SI 6 2 11.25 215 89 SI ;   The objective is to output the configuration of "aop" and "pcs" codes to minimize abs(f)   tot_in=sum(sum(of M:), -1 * sum(of PB:)); tot_out=sum(sum(of P:), sum(of SI:), -1 * sum(of PB:)); f=sum(tot_in, -tot_out);   NB: just the points with class "SI" got different "pcs" for the same "remi" code. ... View more

Nice solution, I have just matched this issue:   ... View more

Thank you,   Really nice solution, and if I have n variables do you think this solution will be acceptable?   data have; input cod $ vol pcs; cards; M1 100 10 M2 100 10.5 ....... Mn 150 11 S1 300 11 S1 300 11.5 S2 400 12 S2 400 . ...... Sn 200 10.5 ; run;     Where M got just one p for each observation and S different p. M and S are the variable vol. ... View more

I neet to take the values from the input table that I put in the previous post if there is a way to do it. And create arrays. ... View more

I will repost my answer, I don't know why I can't find it.   My business solution is to find the best configuration to minimize the obj function with a clp or a optmodel because with a for cycle there will be a lot of iterations   For example using these arrays in a for cycle: vol_M1: {100, 100} pcs_M1: {10, 10.5} vol_S1: {300, 300} pcs_S1: {11, 11.5} vol_S2: {400, 400} pcs_S2: {12}   Min |f| = vol_M1_i * pcs_M1_i – [(vol_s1_j * pcs_S1_j) + (vol_S2_k * pcs_S2_k)]   1. 100*10 - [(300*11) + (400*12)] = -7100 2. 100*10.5 - [(300*11) + (400*12)] = -7050 3. 100*10 - [(300*11.5) + (400*12)] =  - 7250 4. 100*10.5 - [(300*11.5) + (400*12)]  = -7200   The best configuration will be the 2. because is a minimum local (next to zero)   ... View more

Thank you, I will focus on my real problem.   1. I have two different types of data inputs and I want to determine which one is better for my objective function.   2. Next, I would like to create different arrays from the input in the procedure as follows (maybe using read data into): - vol_M1: {100, 100} - pcs_M1: {10, 10.5} - vol_S1: {300, 300} - pcs_S1: {11, 11.5} - vol_S2: {400, 400} - pcs_S2: {12}   3. After that, I need to determine the best configuration using all combinations to minimize the absolute value of 'f'.   The minimum absolute value of 'f' is calculated as follows: Min |f| = vol_M1_i * pcs_M1_i – [(vol_s1_j * pcs_S1_j) + (vol_S2_k * pcs_S2_k)] Where: - i ranges from 1 to the dimension of pcs_M1 - j ranges from 1 to the dimension of pcs_S1 - k ranges from 1 to the dimension of pcs_S2   4. How can I implement this in Proc OPTMODEL? This is a sample, but I have 7000 different "cod" items. @RobPratt @Ksharp  ... View more

Hello,    I would like to understand if there is a way to find the best configuration to minimize a function over a given domain of variables x, y, z:   For example using default values: xij like and list of arrays {3 , 4 ,5}, y {6, 7 , 8}, z{1, 2 , 3} Vi {100, 200, 300} min f(x) = sum (xij*Vi)   The best configuration will be 3*100 + 6*200 + 1*300    I am staring to check the CLP and the OPTMODEL, do you have real example for this kind of problem? Thank you ... View more

I think this is not a Sas problem anymore, I don't know maybe is the virtual container the problem.   ... View more

Yes I am trying to install c++ in the container also compile the code in static mode. Should I put the local path like this? C:/C/bld/libgross.so ... View more

Did you mean that the main problem is the c++ doesn't work in the container?  Linux shell Container shell   ... View more

Should I use this command from the docker shell, in the container where sas pro is installed? ... View more

In the linux shell I can run the code.  This is my output:   My problem is that in the shell in the Docker and in sas studio I can't run this program. I have to say that I uploaded all the directories c++ from docker desktop in the virtual path because I can't find it in my local machine. From the docker shell (white one) I can see sasdemo user, but from my linux shell (black one) not.           ... View more

  /*test1*/ filename oscmd pipe "pwd && ./Gross_test_01 0.95419 0.00674 0.00367 0.02649 0.00645 0.00097 0.00096 0.00019 0.00015 0.00018 0 0 0 0 0 0.00001 0 0 0 0.00002 0 288.15 5701.325"; data _null_; infile oscmd; input; put _infile_; run; /* NOTE: The infile OSCMD is: Pipe command="pwd & ./Gross_test_01 0.95419 0.00674 0.00367 0.02649 0.00645 0.00097 0.00096 0.00019 0.00015 0.00018 0 0 0 0 0 0.00001 0 0 0 0.00002 0 288.15 5701.325" /tmp/C/bld ./Gross_test_01: error while loading shared libraries: libgross.so: cannot open shared object file: No such file or directory NOTE: 2 records were read from the infile OSCMD. */ /* test2*/ data _null_; call system('./Gross_test_01 0.95419 0.00674 0.00367 0.02649 0.00645 0.00097 0.00096 0.00019 0.00015 0.00018 0 0 0 0 0 0.00001 0 0 0 0.00002 0 288.15 5701.325'); call system("pwd"); call system("cd .."); call system("cd .."); call system("pwd"); call system("cd C/bld/"); call system("pwd"); call system('./Gross_test_01 0.95419 0.00674 0.00367 0.02649 0.00645 0.00097 0.00096 0.00019 0.00015 0.00018 0 0 0 0 0 0.00001 0 0 0 0.00002 0 288.15 5701.325'); run; /*NOTE: Current working directory is '/tmp/SAS_work2E8D0000128D_sas-analytics-pro/SAS_work1CCF0000128D_sas-analytics-pro'. NOTE: Current working directory is '/tmp'. NOTE: Current working directory is '/tmp/C/bld'. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds */ I tried different ways, in the first test I tried to go to the path and run the script but I got the error. In the second test I don't get any error but it doesn't make any sense because in the first command I am not in the path where the c++ is located when I run the program but I don't see any error.   @Sajid01 user id is sasdemo by default but I tried from root as well:     ... View more

Hello, here I put some variable but I don't know which differences are part of my issue.       ... View more