Download PDF SAS Certification Prep Guide Advanced Programming For SAS 9

Sinopsis

PROC SQL is the SAS implementation of Structured Query Language (SQL), which is a standardized language that is widely used to retrieve and update data in tables and in views that are based on those tables.

Content

1. SQL Processing With SAS
2. Performing Queries Using PROC SQL
3. Performing Advanced Queries Using PROC SQL
4. Combining Tables Horizontally Using PROC SQL
5. Combining Tables Vertically Using PROC SQL
6. Creating and Managing Tables Using PROC SQL
7. Creating and Managing Indexes Using PROC SQL
8. Creating and Managing Views Using PROC SQL
9. Managing Processing Using PROC SQL
10. SAS Macro Language
11. Introducing Macro Variables
12. Processing Macro Variables at Execution Time
13. Creating and Using Macro Programs
14. Storing Macro Programs
15. Advanced SAS Programming Techniques
16. Creating Samples and Indexes
17. Combining Data Vertically
18. Combining Data Horizontally
19. Using Lookup Tables to Match Data
20. Formatting Data
21. Modifying SAS Data Sets and Tracking Changes
22. Optimizing SAS Programs
23. Introduction to Efficient SAS Programming
24. Controlling Memory Usage
25. Controlling Data Storage Space
26. Utilizing Best Practices
27. Selecting Efficient Sorting Strategies
28. Querying Data Efficiently

Click here to  download