SAS certification prep guide : advanced programming for SAS 9

Prepares you to take the Advanced Programming for SAS 9 exam. Major topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs. You will also become familiar with the enhancements and new functionality that are available in SAS 9.

Detalles Bibliográficos
Autor Corporativo: SAS Institute Content Provider (content provider)
Otros Autores: Institute, SAS, author (author), SAS Institute Contributor (contributor)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] SAS Institute 2011
Edición:3rd ed
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628246306719
Tabla de Contenidos:
  • Performing queries using PROC SQL
  • Performing advanced queries using PROC SQL
  • Combining tables horizontally using PROC SQL
  • Combining tables vertically using PROC SQL
  • Creating and managing tables using PROC SQL
  • Creating and managing indexes using PROC SQL
  • Creating and managing views using PROC SQL
  • Managing processing using PROC SQL
  • Introducing macro variables
  • Processing macro variables at execution time
  • Creating and using macro programs
  • Storing macro programs
  • Creating samples and indexes
  • Combining data vertically
  • Combining data horizontally
  • Using lookup tables to match data
  • Formatting data
  • Modifying SAS data sets and tracking changes
  • Introduction to efficient SAS programming
  • Controlling memory usage
  • Controlling data storage space
  • Using best practices
  • Selecting efficient sorting strategies
  • Querying data efficiently.