topic Re: Macro variable - Urgent Help in SAS Programming

Macro variable - Urgent Help

1234567 — Wed, 22 Jul 2009 01:48:37 GMT

Proc optmodel run 20 different optimizations and results were saved in sas dataset. I want to save c1 and c2 from the previous results as a macro variable and then pass them back to PROC OPTMODEL for the next optimization. So by doing this the previous results of c1 and c2 will be used as starting values for the next run. Thanks..

Re: Macro variable - Urgent Help

1234567 — Wed, 22 Jul 2009 01:54:30 GMT

proc optmodel ;
var c1 init - 3 >= - 3 <= 2.93;
var c2 init - 3 >= - 3 <= 8.86;
number a; set R= 1..20; number aval{i in R} = i/20; number c1val{i in R}, c2val{i in R}, c3val{i in R}; number sensval{i in R};
max Sensitivity = 1-probbnrm((c1-1.43)/.5,(c2-2.86)/2, 0);
con FPF: 1-probbnrm((c1-0)/1,(c2-0)/1, 0) <= a;
for {i in R} do;
a = aval;
solve with IPNLP / MAXTIME=14400 MAXITER=100000 printfreq = 0 ;
c1val = c1;
c2val = c2;
sensval = Sensitivity;
end;
create data mrocBP from FPR=aval c1=c1val c2=c2val MTPR=sensval ;
quit ;

Re: Macro variable - Urgent Help

1234567 — Wed, 22 Jul 2009 01:56:28 GMT

Can't put all the sas code!

Re: Macro variable - Urgent Help

1234567 — Wed, 22 Jul 2009 02:04:41 GMT

Chris@NewZealand
and
Daniel Santos

Please your help

Re: Macro variable - Urgent Help

DanielSantos — Wed, 22 Jul 2009 07:35:13 GMT

Hello.

I'm not sure I got this right...

You just need to call proc optmodel several times (at leas 2 times) feeding the output of the previous iterations (CREATE DATA OUT) to the input of the next (READ DATA IN). Is this right?

How is your code structured? Are we talking about a single script?
And is it a single call to the optmodel procedure per script, or is it possible to have more than one call in same script?

Finally, how many iterations do need?

Cheers from Portugal.

Daniel Santos @ www.cgd.pt.

Re: Macro variable - Urgent Help

sbb — Wed, 22 Jul 2009 14:18:18 GMT

An intermediate DATA step using CALL SYMPUT will allow you to capture a SAS variable value and place it in a SAS global/local macro variable, for later use. If you are working with a macro and a %DO / %END loop, you can declare the macro variable up-front using %LOCAL or %GLOBAL, and then use an %IF %THEN testing the %LENGTH() to determine the first execution and then don't do something on the first DO loop execution (there are also other techniques as well).

Scott Barry
SBBWorks, Inc.