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