double WHERE statement

[matt23]

Would you be able to tell me how to fix my double WHERE statement so it works?

proc reg data=datananame (where=(Month in (1,2,3)) and (Day in (1,2,3,4,5)));
model Y=X;
run;

[Kurt_Bremser]

where=(Month in (1,2,3) and Day in (1,2,3,4,5))

just too many parentheses.

[Tom · Accepted solution]

---

@matt23 wrote:

Would you be able to tell me how to fix my double WHERE statement so it works?

proc reg data=datananame (where=(Month in (1,2,3)) and (Day in (1,2,3,4,5)));
model Y=X;
run;

---

You just need to get the parenthesis nested properly.

You could also look at using the WHERE statement instead of the WHERE= dataset option. 

That way you can a WHERE ALSO statement to add additional restrictions.

proc reg data=datananame;
  where Month in (1,2,3);
  where also Day in (1,2,3,4,5);
  model Y=X;
run;