topic Re: Creating dummy variable with three values in SAS Programming

Creating dummy variable with three values

amsa1996 — Mon, 27 Apr 2020 12:20:58 GMT

Hi!

I have created a dummy variable as my target variable where 0 indicates that the event "payment handled" has not occured, and 1 that is have occured. Furthermore, i want to add a value "2" in my target variable indicating that the event "payment handled" has not occured due to another event called "decleration rejected". This means that the event has to have a value <0 at decleration rejected, and 0 at payment handled. Both events are extracted from the same column named, activity_id.

Can someone help?

Re: Creating dummy variable with three values

amsa1996 — Mon, 27 Apr 2020 10:19:26 GMT

It has to have a value >0 at decleration rejected**

Re: Creating dummy variable with three values

Shmuel — Mon, 27 Apr 2020 10:55:08 GMT

If I understand you correctly than add a line:

sum(activity_id="decleration rejected")  as rejected /* new dummy */

then add a new step:

data tuetravelexpenses_cases;
 set tuetravelexpenses_cases;
       if rejected > 0 then target_variable=2;
      *drop rejected;
run;

Re: Creating dummy variable with three values

amsa1996 — Mon, 27 Apr 2020 12:19:56 GMT

Almost!

The value "2" requires that "payment handled" is 0, and "declaration rejected" > 0, and not only that "declaration rejected" > 0.

But i managed that by adding "and". Thanks for the help!