where statement

[yael]

Hello

I have the following code:

proc glm data=sasuser.sasfile250716;

where year>=0 year<=5;

model ROA = salesGro rdsales LTassets LNAssets cAPAXASS DIVASSETS **bleep**efound BETA

/solution;

run;

I have a variable "year" which have the indicators 0-10. I want to run a regression that will limit

the data to years of two groups: 0-5 and 6-10. I used the statement where but got an ERROR

534 proc glm data=sasuser.sasfile250716;

535 where year>=0 year<=5;

----

22

76

ERROR: Syntax error while parsing WHERE clause.

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT,

LE, LT, NE, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

536 model ROA = salesGro rdsales LTassets LNAssets cAPAXASS DIVASSETS **bleep**efound BETA

537 /solution;

538 run;

I did not find where I can use where statement as a list

Can you help me?

Thanks a lot!

[Kurt_Bremser · Accepted solution]

where year>=0 year<=5;

These are actually 2 conditions; you need to use a logical operator to combine them so you get a valid boolean result:

where year>=0 and year<=5;

SAS also allows this construct:

where 0 <= year <= 5;