Impute any value in a given range: add exceptions

Luis_Martins — Thu, 22 Nov 2018 16:13:00 GMT

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

Re: Impute any value in a given range: add exceptions

Reeza — Thu, 22 Nov 2018 16:19:57 GMT

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

topic Impute any value in a given range: add exceptions in New SAS User

Impute any value in a given range: add exceptions

Re: Impute any value in a given range: add exceptions