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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: