Help using Base SAS procedures

where statement

Accepted Solution Solved
Reply
Contributor
Posts: 69
Accepted Solution

where statement

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!

 


Accepted Solutions
Solution
‎07-25-2016 08:22 AM
Super User
Posts: 6,941

Re: where statement

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;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎07-25-2016 08:22 AM
Super User
Posts: 6,941

Re: where statement

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;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 206 views
  • 2 likes
  • 2 in conversation