An Idea Exchange for SAS software and services

Comments
by Super User
on ‎07-20-2015 06:18 AM

Hi,

Not sure I follow.  From this list:

M     12

M     19

M     25

The min would return 19, what would all() return?  Is it based on T-SQL, if so would there not be confusion then based on different platform specific SQL interpretations.

by Regular Contributor
on ‎07-20-2015 09:42 AM

First, I don't think we should change MIN to ALL and MAX to ANY, MIN and MAX have intuitive definitions as aggregate functions, this shouldn't change.

In these examples MIN and MAX are being applied to Boolean values, The use and the return value of MIN and MAX are dependent on the Boolean values calculated during the execution of the code.  Your statement involving MIN and MAX and their not depending "on the internal representation of Boolean values" makes no sense and is a bad argument.

by Regular Contributor
on ‎07-20-2015 09:43 AM

I think I see your idea and it's interesting, but you haven't motivated your point well enough.  Please put into words how you propose to define ANY and ALL as aggregate functions.

by Respected Advisor
on ‎07-20-2015 02:54 PM

Thanks for the comments. My proposal is not about removing the MIN and MAX functions. It is just about not applying them to boolean values.

I added a more precise definition of the ALL and ANY aggregate functions. Hoping it will shift your vote Smiley Happy.

PG

by Regular Contributor
on ‎07-20-2015 03:38 PM

now the only problem is that its not part of any SQL standard (that I know of, correct me if).  That most likely is a deal killer -- I think.

by PROC Star
on ‎07-20-2015 11:03 PM

While I can see your point, no new feature is added.

If we were to extend SQL's vocabulary, I'd much prefer a new feature such a summary function for strings ( concatenate, concatenate_dedupe for example) or an implementation of oracle's rank function.

by Respected Advisor
on ‎07-20-2015 11:20 PM

I would like the concatenation function too! My request is modest in comparison. Nonetheless, clarity, ease of expression and legibility ARE features of a programming language. - PG

Idea Statuses
Top Liked Authors