Hello All I'm trying to replicate in SAS a procedure I use in Excel. This procedure is basically an iterative solver (through a macro) that puts the variable Delta (OptVar - Ratio) to 0 by changing the values of the AuxVar (starting with null values). The input data starts like this: ID Num Ratio AuxVar OptVar Delta 1 6 0.166667 0.00% 0.00% -0.1667 2 7 0.285714 0.00% 0.00% -0.2857 3 7 0.285714 0.00% 0.00% -0.2857 4 800 0.375 0.00% 0.00% -0.3750 5 800 0.375 0.00% 0.00% -0.3750 6 744 0.387097 0.00% 0.00% -0.3871 6 744 0.387097 0.00% 0.00% -0.3871 7 2 0.5 0.00% 0.00% -0.5000 8 2 0.5 0.00% 0.00% -0.5000 - ID, Num and Ratio are inputs; - AuxVar values are generated by Excel; - OptVar is given by probit(0.975)*sqrt((AuxVar*(1-AuxVar))/Num)+AuxVar - Delta is OptVar - Ratio The solver objective function is Delta, it operates by changing AuxVar values and the constraint is AuxVar greater or equal to 0. It runs for each cell. After the Solver Macro, the output is: ID Num Ratio AuxVar OptVar Delta 1 6 0.166667 3.01% 16.67% 0.0000 2 7 0.285714 8.22% 28.57% 0.0000 3 7 0.285714 8.22% 28.57% 0.0000 4 800 0.375 34.21% 37.50% 0.0000 5 800 0.375 34.21% 37.50% 0.0000 6 744 0.387097 35.28% 38.71% 0.0000 6 744 0.387097 35.28% 38.71% 0.0000 7 2 0.5 9.45% 50.00% 0.0000 8 2 0.5 9.45% 50.00% 0.0000 Is there a way to do this in SAS? I have been trying and searching for a few days, without success. If anyone could help, it would be very appreciated. Kind Regards, Ricardo
... View more