topic Re: Novice needs help with IF a=xx and/or b=yy and/or c=zz then ny_var=1, othervise ny_var=0 --> in SAS Enterprise Guide

Novice needs help with IF a=xx and/or b=yy and/or c=zz then ny_var=1, othervise ny_var=0 --> table

Mmignon — Sat, 17 Feb 2018 15:08:51 GMT

Hello

I am pretty much novice in SAS Enterprise Guide and I am facing a problem which I cannot resolve by myself.

I wrote this code:

data test_new; set test;
if a=1 or b=1 or c=1 then MI=1;

If MI=. or MI<1 then MI=0;
run;

proc freq data=MI;
tables
MI*randomisation_code/chisq;
run;

But when I run the code, I only get the table with MI=0.

Actually, I need the result for this:
if a=1 and/or b=1 and/or c=1 then MI=1; (at least two of the variables should mach together)

but cannot get it to work.

I hope some of you can help me with advice what to do, in a step-by-step manner 🙂

TIA
Mmignon

Re: Novice needs help with IF a=xx and/or b=yy and/or c=zz then ny_var=1, othervise ny_var=0 -->

Astounding — Sat, 17 Feb 2018 15:27:32 GMT

First step, run a PROC FREQ on the variables a, b, and c to be sure that you actually have the values you expect. Your logic for creating MI depends on those, and looks like it should work.

A nice shortcut for the result you really want:

MI = (a + b + c) >= 2;

But that is dependent on the logic being right ... a, b, and c should be variables with values of 0 or 1 only.

Re: Novice needs help with IF a=xx and/or b=yy and/or c=zz then ny_var=1, othervise ny_var=0 -->

Mmignon — Fri, 23 Feb 2018 15:52:14 GMT

Thank you very much for the shortcut 🙂
I found the solution by myself, but it's more elegant with your shortcut!

Sincerely
Mmignon