Impute any value in a given range: add exceptions

[Luis_Martins]

Greetings,

I'm running a program to impute some variables and for each variable I have a macro that is used by the core imputation program to define the range of values that are going to be attributed in the imputation procedure, like this:

%macro bound_secondary_profession;
    LB=1;
    UB=9;
%mend; 

The problem is that the imputed value of this particular variable must be different from the imputed value of the primary_profession variable and I must specify this restriction within this macro. So far I managed to come up with a solution for extreme values:

%macro bound_secondary_profession;
    LB=1;
    UB=9;
    IF primary_profession=1 then LB=2;
    IF primary_profession=9 then UB=8;
%mend;

But what if primary_profession is equal, let's say 2? How can I impose that the number 2 cannot be chosen, using LB and UB? 

This is more of a logic challenge rather than a SAS programming challenge, but I've been struggling with this issue for quite some time and I still can't find a way out.

Thank you very much for your support.

Best regards

[Reeza · Accepted solution]

It depends on how you're implementing it in the next portion. If you're using temporary arrays, you can just modify the array if needed or hardcode a condition in. 

---

@Luis_Martins wrote:

Greetings,

I'm running a program to impute some variables and for each variable I have a macro that is used by the core imputation program to define the range of values that are going to be attributed in the imputation procedure, like this:

%macro bound_secondary_profession;
    LB=1;
    UB=9;
%mend; 

The problem is that the imputed value of this particular variable must be different from the imputed value of the primary_profession variable and I must specify this restriction within this macro. So far I managed to come up with a solution for extreme values:

%macro bound_secondary_profession;
    LB=1;
    UB=9;
    IF primary_profession=1 then LB=2;
    IF primary_profession=9 then UB=8;
%mend;

But what if primary_profession is equal, let's say 2? How can I impose that the number 2 cannot be chosen, using LB and UB? 

This is more of a logic challenge rather than a SAS programming challenge, but I've been struggling with this issue for quite some time and I still can't find a way out.

Thank you very much for your support.

Best regards

---