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!
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.