|
p a r t 1 sql processing with sas
chapter 1: performing queries using proc sql
o proc sql basics
o writing a proc sql step
o selecting columns
o specifying the table
o specifying subsetting criteria
o ordering rows
o querying multiple tables
o summarizing groups of data
o creating output tables
chapter 2: performing advanced queries using proc sql
o viewing select statement syntax
o displaying all columns
o limiting the number of rows displayed
o eliminating duplicate rows from output
o subsetting rows by using conditional operators
o subsetting rows by using calculated values
o enhancing query output
o summarizing and grouping data
o subsetting data by using subqueries
o subsetting data by using noncorrelated subqueries
o subsetting data by using correlated subqueries
chapter 3: combining tables horizontally using proc sql
o understanding joins
o generating a cartesian product
o using inner joins
o using outer joins
o creating an inner join with outer join-style syntax
o comparing sql joins and data step match-merges
o using in-line views
o joining multiple tables and views
chapter 4: combining tables vertically using proc sql
o understanding set operations
o using the except set operator
o using the intersect set operator
o using the union set operator
o using the outer union set operator
o comparing outer unions and other sas techniques
chapter 5: creating and managing tables using proc sql
o understanding methods of creating tables
o creating an empty table by defining columns
o displaying the structure of a table
o creating an empty table that is like another table
o creating a table from a query result
o inserting rows of data into a table
o creating a table that has integrity constraints
o handling errors in row insertions
o displaying integrity constraints for a table
o updating values in existing table rows
o deleting rows in a table
o altering columns in a table
o dropping tables
chapter 6: creating and managing indexes using proc sql
o understanding indexes
o deciding whether to create an index
o creating an index
o displaying index specifications
o managing index usage
o dropping indexes
chapter 7: creating and managing views using proc sql
o creating and using proc sql views
o displaying the definition for a proc sql view
o managing proc sql views
o updating proc sql views
o dropping proc sql views
chapter 8: managing processing using proc sql
o specifying sql options
o controlling execution
o controlling output
o testing and evaluating performance
o resetting options
o using dictionary tables
p a r t 2 sas macro language
chapter 9: introducing macro variables
o basic concepts
o using automatic macro variables
o using user-defined macro variables
o processing macro variables
o displaying macro variable values in the sas log
o using macro functions to mask special characters
o using macro functions to manipulate character strings
o using sas functions with macro variables
o combining macro variable references with text
chapter 10: processing macro variables at execution time
o creating a macro variable during data step execution
o creating multiple macro variables during data step execution
o referencing macro variables indirectly
o obtaining macro variable values during data step execution
o creating macro variables during proc sql step execution
o working with proc sql views
o using macro variables in scl programs
chapter 11: creating and using macro programs
o basic concepts
o developing and debugging macros
o using macro parameters
o understanding symbol tables
o processing statements conditionally
o processing statements iteratively
o using arithmetic and logical expressions
chapter 12: storing macro programs
o understanding session-compiled macros
o storing macro definitions in external files
o storing macro definitions in catalog source entries
o using the autocall facility
o using stored compiled macros
|