Calcite | Level 5

PROC OPTMODEL - Data Envelope Analysis - Return Input and Output Slacks

How can I return the input and output slacks using the DEA example from the SAS/OR(R) 12.1 User's Guide?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
SAS Super FREQ

Re: PROC OPTMODEL - Data Envelope Analysis - Return Input and Output Slacks

If I understand correctly, the following changes should do what you want:

``````   num input_slack  {GARAGES, INPUTS};
num output_slack {GARAGES, OUTPUTS};
do k = GARAGES;
solve;
efficiency_number[k] = 1 / Inefficiency.sol;
for {j in GARAGES}
weight_sol[k,j] = (if Weight[j].sol > 1e-6 then Weight[j].sol else .);
for {i in INPUTS}
input_slack[k,i] = round(Input_con[i].ub - Input_con[i].body, 1e-6);
for {i in OUTPUTS}
output_slack[k,i] = round(Output_con[i].body - Output_con[i].lb, 1e-6);
end;

set EFFICIENT_GARAGES = {j in GARAGES: efficiency_number[j] >= 1 - 1e-6};
set INEFFICIENT_GARAGES = GARAGES diff EFFICIENT_GARAGES;

create data slack_data from [garage]=INEFFICIENT_GARAGES garage_name efficiency_number
{i in INPUTS} <col(i)=input_slack[garage,i]>
{i in OUTPUTS} <col(i)=output_slack[garage,i]>;``````

4 REPLIES 4
SAS Super FREQ

Re: PROC OPTMODEL - Data Envelope Analysis - Return Input and Output Slacks

By slacks, do you mean the differences between the two sides of the inequalities?

``````input[i,k] - sum {j in GARAGES} input[i,j] * Weight[j]

sum {j in GARAGES} output[i,j] * Weight[j] - output[i,k] * Inefficiency``````

And do you want to print the values or save them to a data set?

Calcite | Level 5

Re: PROC OPTMODEL - Data Envelope Analysis - Return Input and Output Slacks

By slacks, I'm trying to get specific potential input and output variable improvements for the inefficient garages.  My understanding is the slacks show the further increases in output or reduction in input that could be gained beyond that from the radial projection (equal increase in all outputs, or decrease in all inputs) or a radial efficiency score equal to 1.  I'd like to save it to a data set.

I hope this helps.  Thanks for your time.

SAS Super FREQ

Re: PROC OPTMODEL - Data Envelope Analysis - Return Input and Output Slacks

If I understand correctly, the following changes should do what you want:

``````   num input_slack  {GARAGES, INPUTS};
num output_slack {GARAGES, OUTPUTS};
do k = GARAGES;
solve;
efficiency_number[k] = 1 / Inefficiency.sol;
for {j in GARAGES}
weight_sol[k,j] = (if Weight[j].sol > 1e-6 then Weight[j].sol else .);
for {i in INPUTS}
input_slack[k,i] = round(Input_con[i].ub - Input_con[i].body, 1e-6);
for {i in OUTPUTS}
output_slack[k,i] = round(Output_con[i].body - Output_con[i].lb, 1e-6);
end;

set EFFICIENT_GARAGES = {j in GARAGES: efficiency_number[j] >= 1 - 1e-6};
set INEFFICIENT_GARAGES = GARAGES diff EFFICIENT_GARAGES;

create data slack_data from [garage]=INEFFICIENT_GARAGES garage_name efficiency_number
{i in INPUTS} <col(i)=input_slack[garage,i]>
{i in OUTPUTS} <col(i)=output_slack[garage,i]>;``````

Calcite | Level 5

Re: PROC OPTMODEL - Data Envelope Analysis - Return Input and Output Slacks

That is exactly what I was after.  Thank you so much for your time and the fast response!

Discussion stats
• 4 replies
• 654 views
• 1 like
• 2 in conversation