Structured Query Language (SQL) has been added to the base SAS system in order to take advantage of this standardized structured coding language. No additional purchase is necessary for you to use this tool. PROC SQL is a natural for individuals who are already familiar with SQL coding as well as new users to whom it would be valuable to learn this emerging language. SQL allows ready access to many different file types and data bases with the same general metaphor of relational design and data representation of tables of rows and columns. This language also has the particular advantage in SAS of both a simpler and more efficient alternative to the match-merge.
This course focuses on using Structured Query Language (SQL) for data retrieval within SAS programs from SASdatasets. Emphasis will be placed on extracting and manipulating data from multiple files or tables with simple and concise queries.
Upon completion, the student will be able to perform queries on data using:
- Column and row selection
- Use column calculations and functions
- Summarize data
- Retrieve data from multiple sources using JOINs, UNIONs and other methods
- Create views, tables and indices