topic Re: explain about clauses funtionalities in SAS Programming

explain about clauses funtionalities

thanikondharish — Wed, 07 Jul 2021 11:28:30 GMT

I have clauses see below

select,from ,join,where ,group by, having,order by

My question is which clause is will execute first and explain their functionalities.

Please explain this scenario

Oligolas — Wed, 07 Jul 2021 12:36:05 GMT

Hi,

the order of execution is

FROM

JOIN

WHERE

GROUP BY

HAVING

SELECT

DISTINCT

ORDER BY

Please consult https://www.w3schools.com/sql/ since this tutorial is excellent and what you need has nothing to do with SAS directly