First format your code neatly so you can more easily see and fix the obvious typos and syntax errors.
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;
Then add grouping () to your conditions so they make sense. If you code
A and B or C or D
What are you asking for?
Are you asking for
(A and B) or C or D
or
A and (B or C or D)
?
... View more