Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. /

SAS software has been in existence for a long time and has been implemented in large, data-intensive environments, including data warehouses. This SAS book covers practical programming considerations to make when involving SAS in a data warehouse environment. You'll be able to develop the skill...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Wahi, Monika (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Packt Publishing, 2020.
Temas:
Data warehousing.
SAS (Computer program language)
Entrepôts de données (Informatique)
SAS (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright and Credits
  • Dedication
  • About Packt
  • Contributors
  • Table of Contents
  • Preface
  • Section 1: Managing Data in a SAS Data Warehouse
  • Chapter 1: Using SAS in a Data Mart, Data Lake, or Data Warehouse
  • Technical requirements
  • Using original versions of SAS
  • Initial SAS data handling
  • Early SAS data handling
  • SAS data handling improvements
  • Accessing data in SAS
  • Upgrading to mainframes
  • Transitioning to personal computers
  • Reading external files
  • Improving I/O
  • Developing warehouse environments
  • Using the WHERE clause
  • Using IF compared to WHERE
  • Sorting in SAS
  • Setting indexes on variables
  • Dealing with storage and memory issues
  • Avoiding memory issues
  • Accommodating Structured Query Language
  • Using PROC SQL
  • Using SAS today in a warehouse environment
  • Using SAS in the cloud
  • Using SAS in modern warehousing
  • Warehousing unstructured text
  • Using SAS components for warehousing
  • Using other applications with SAS
  • Connecting to Snowflake
  • Summary
  • Questions
  • Further reading
  • Chapter 2: Reading Big Data into SAS
  • Technical requirements
  • Reading data extracts into SAS
  • Understanding SAS datasets
  • Working with the WORK directory
  • Specifying LIBNAME
  • Reading in SAS datasets
  • Using the SAS XPT format
  • Storing data in XPT format
  • Creating an XPT file
  • Comparing PROC CPORT/CIMPORT to PROC COPY
  • Reading in XPTs using the XPORT engine
  • Working with other file formats
  • Reading non-SAS data formats
  • Using PROC IMPORT
  • Converting non-SAS data to SAS format
  • Dealing with difficult data
  • Understanding legacy data
  • Reading data with difficult formats
  • Specifying data locations in a fixed-width file
  • Troubleshooting reading data after transport
  • Summary
  • Questions
  • Further reading
  • Chapter 3: Helpful PROCs for Managing Data
  • Technical requirements
  • PROCs for understanding data
  • Using PROC CONTENTS to understand data
  • Documenting SAS data with codebooks
  • Using labels for variables
  • Adding user-defined formats to categorical variables
  • Using native SAS formats with numeric variables
  • Applying user-defined formats to continuous variables
  • Using labels and formats in processing
  • Using PROCs with labels and formats
  • Maintaining labels and formats
  • Alternatives to using labels and formats in a warehouse setting
  • Viewing data in SAS
  • Using PROC PRINT to view data
  • Using PROC SQL to view data
  • Using arithmetic operators in SAS
  • Viewing data through SAS windows
  • Summary
  • Questions
  • Further reading
  • Chapter 4: Managing ETL in SAS
  • Technical requirements
  • Setting up an analytic environment
  • Designating storage and user groups
  • Managing documentation storage
  • Setting naming conventions for datasets
  • Planning for data transformation
  • Understanding arrays in SAS
  • Setting naming conventions for variables

Ejemplares similares