An Introduction to SQL in SAS

Click on this link to access and read pages 1 and 2 of this introduction to SQL in SAS. Stop reading at the end of the section entitled “What To Do With The Results” on page 2.  (Links to an external site.)Then answer these questions:

List these SQL clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY and provide short explanations describing what each of them does. 
In your own words, step through how you think the keywords you listed in the first bullet work together, using an example focused on a business data. 
How do you feel about thinking through technical terms using a business application like you did in the second bullet? Does it help or hinder your understanding of the technical concepts? Why? 

REFERENCE LIST
Lund, P. (n.d). An introduction to SQL in SAS. Retrieved from:
     https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/257-30.pdf