PROC SQL part -3 Aggregate functions, Group by and other related details

In this presentation I will discuss concept of aggregate functions, group by, remerging summary statistics. I will also discuss where vs having clause and also how to apply group by and aggregate functions on case when statements. For any queries, please contact us at [e-mail]

[@kamerchan]

Thank you very much for beign a fantastic teacher. Greetings from Colombia

[@satyasudha2536]

Sir your classes are really helpful for beginning learner...

[@princysingla5084]

Again very detailed and nice explained cleared allmy dobts :)

[@ashokreddy4083]

Thank you sir

[@venuvardhan1997]

Very well explained

[@gopi4716]

When calculated keyword has to be used?

[@kiranvenna]

if you are creating new variable and want to use in where clause then you need to use calculated. This is because how SQL is executed behind the scenes is it starts from "from" clause then where clause and then it goes to select. So where clause does not know about new variables in select. So calculated keyword calculated helps here.

[@gopi4716]

@@kiranvenna thankful

[@radharanidayyala9519]

For the last example, query can also be written as below:
proc sql;
select sex, count(age) from sashelp.class
group by sex, age
having age in (11,12,13,14,15);
quit;

[@priyadhokriya]

very well explained