Thank you for walking me through that, I had thought that was what was going on but I was not sure. Below is my sample code and sample data. I attached a screen capture of the output as well. data sample_data;
input email1 $ email1_email_opened $ email1_email_clicked $;
datalines;
N N N
Y N N
Y Y N
Y Y Y
;
proc print data=sample_data;
run;
data sample_data2;
set sample_data;
if email1 = 'Y' then email1_Dummy = 1;
else do;
email1_Dummy = 0;
call missing(email1_email_opened_dummy, email1_click_dum);
end;
email1_EMAIL_OPENED_dummy = (email1_EMAIL_OPENED = 'Y');
if email1_EMAIL_OPENED_dummy = 0 then call missing(email1_click_dum);
if email1_EMAIL_CLICKED = 'Y' then email1_click_dum = 1;
run; l
... View more