I'm trying to create a flag variable for respondents that answered S3 = 1 and Q11 ne 1 and if either timer variables had <1 I've tried the following syntax, which doesn't seem to be working. proc SQL;
create table flagstemcell as
select S3, Q11, treatment_feature_Timer, treatment_benefit_Timer, treatment_benefit_2_Timer, complete_response_information_Ti, treatment_side_effects_1_Timer
treatment_side_effects_2_Timer, treatment_side_effects_3_Timer, treatment_risk_Timer
When S3 = 1 and Q11 NE 1 and treatment_feature_Timer <10 or treatment_benefit_Timer <10 or treatment_benefit_2_Timer <10
or complete_response_information_Ti <10 or treatment_side_effects_1_Timer < 10 treatment_side_effects_2_Timer <10 or treatment_side_effects_3_Timer or treatment_risk_Timer
from MM1;
group by record;
quit;
... View more
