I checked the version that I have on my local computer which was 9.03.01M1P110211 for Base SAS and the one that is running on UNIX server: 9.03.01M2P080112 . Although the one that runs on the server is more recent but the library error appears on this version but not the old version on my local. ... View more

Unfortunately I can't share the details but it involved several proc sqls and data steps to generate the output profit (SUM_PROFIT2) using the given inputs:     %MACRO Profit(seg=,....); proc sql; .... quit; proc sql; .... quit; proc sql; .... quit; proc sql; .... quit; proc sql; .... quit; /*Summarize the costs*/ proc sql; .... quit; /*application costs*/ proc sql; .... quit; data APP_COST; ... run; /*Out_Profit*/ /*%let mydataid=%sysfunc(open(Out_Profit, i));*/ data _NULL_; %GLOBAL SUM_PROFIT2; set OUT_PROFIT; call SYMPUT('SUM_PROFIT2',sum_profit); run; %let result = &SUM_PROFIT2; %MEND Profit;   ... View more

Hi, Thanks for the response. As I explained the proc fcmp is working well with proc optmodel on my Windows PC but the error appears when I run it on UNIX server using rsubmit. I believe the problem is not generated from proc optmodel but it's only from the remote submit of proc fcmp since when I run the following code I get the same error (ERROR: Cannot find a library containing subroutine RUN_MACRO.). rsubmit ; proc fcmp outlib=xwork.ds.functions; function Tot_profit(V5YC, F1YC, F2YC, F3YC, F4YC, F5YC,seg $,peak,Num_comp_periods,Num_pay_period_year,Discount_rate,Free_Appr_cost,Amex_Point_Cost,cash_back_cost); rc = run_macro('Profit',V5YC, F1YC, F2YC, F3YC, F4YC, F5YC,seg,peak,Num_comp_periods,Num_pay_period_year,Discount_rate,Free_Appr_cost,Amex_Point_Cost,cash_back_cost,Sum_profit2,NII2,Vol2); if rc eq 0 then return(Sum_profit2); else return(.); endsub; endrsubmit; The reason that I'm using proc fcmp (called "Tot_profit") to create a function which calls a macro function (called "Proft"). The Tot_profit function is later called from proc optmodel to calculate the objective function and the input arguments to that function is the optimization variables and the outcome is the objective value which is supposed to be maximized. If I just call the macro function directly from the proc optmodel without utilizing the function created by proc fcmp then I get the following error message for any line of code I add after calling the macro function. ERROR 180-322: Statement is not valid or it is used out of proper order. So please let me know your thoughts about the first error message from remote submit of proc fcmp and also if you have any suggestion for calling a macro function during optimization directly from proc optmodel without utilizing proc fcmp. Thanks, Farshid ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Thanks for the response.   It should be noted that the macro statement works fine if I use a constant numeric value as the input argument but the problem is with sending a variable as the input and use it's values inside the macro statement.   Can you clarify why the print (&price +1) runs without any problem and adds 1 to the value of A which is 3.1 but the Term_Rate=(&price +1) considers &price as a letter A instead of the numeric value? And how can I use the value of the variable A in the data step instead of the variable name? ... View more

I think the problem I have is with the communication between the optimizer variable and macro statement. Suppose I change the code as the following:   data Rate; input A B ; datalines; 3.1 3.2 ;   data Rate2; input Product_Term $6. Term_Rate 5.; datalines; A 3.1 B 3.2 C 3.3 ;     proc optmodel; VAR A, B ; read data Rate into A B ; %Profit(price=A); quit;   %Macro profit(price=); print (&price+1); /*again this shows the correct value*/   data step; set Rate2; if Product_Term='A:V5YC' then Term_Rate=(&price+1 ); run; %Mend profit;   So the outcome of this process will be the following table: Product_Term Term_Rate A A     B 3.2   C 3.3       But it is not clear why a seperate column named "A" is created and why the Term_Rate in the first row is empty instead of 4.1? ... View more

Thanks for the response. Do you know how to use arrays in data step as a single value variable? ... View more