Technical : Difference between if and where? Ways of creating macro? First. Last.? Sql queries? Questions on functions like substr, scan trim, cat, intnx, intck etc. ? Types of merge and joins and predict output of the example table they have given?