topic Re: double WHERE statement in SAS Enterprise Guide

double WHERE statement

matt23 — Mon, 02 Jul 2018 15:28:03 GMT

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;

Re: double WHERE statement

Kurt_Bremser — Mon, 02 Jul 2018 15:32:05 GMT

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

just too many parentheses.

Re: double WHERE statement

Tom — Mon, 02 Jul 2018 15:39:55 GMT

@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;