BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GenDemo
Quartz | Level 8

Hi All

 

I am wondering if anyone knows why I sometimes get the following note when using the "<>" ('unequal') operator in a data step procedure:

NOTE: The "<>" operator is interpreted as "MAX".

 

Sometimes this happens in a proc sql as well...

1 ACCEPTED SOLUTION
4 REPLIES 4
GenDemo
Quartz | Level 8

Ah Thank you

 

This basically explains it:   Note: In a WHERE statement or clause, the <> operator is equivalent to NE. 

 

 

Reeza
Super User

In a data step, <> is the max function.

In SQL it is Not Equals.

 

In most languages <> means not equals, so SAS warns you otherwise. I would use a max function to avoid the message. 

ballardw
Super User

Things like this are one reason I use the GE LE and NE instead of >= or <= or <>, different possible interprtations and having to remember is it >= or =>.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 14340 views
  • 2 likes
  • 4 in conversation