Mastering SAS Programming for Data Warehousing An advanced programming guide to designing and managing Data Warehouses using SAS
暫譯: 掌握SAS程式設計於資料倉儲的應用

Monika Wahi

Mastering SAS Programming for Data Warehousing
  • 出版商: Packt Publishing
  • 出版日期: 2020-10-16
  • 售價: $2,220
  • 貴賓價: 9.5 折 $2,109
  • 語言: 英文
  • 頁數: 494
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 178953237X
  • ISBN-13: 9781789532371

    • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Build a strong foundation in SAS data warehousing by understanding data transformation code and policy, data stewardship and management, interconnectivity between SAS and other warehousing products, and print and web reporting

Key Features

  • Understand how to use SAS macros for standardizing extract, transform, and load (ETL) protocols
  • Develop and use data curation files for effective warehouse management
  • Learn how to develop and manage ETL, policies, and print and web reports that meet user needs

Book Description

SAS is used for various functions in the development and maintenance of data warehouses, thanks to its reputation of being able to handle 'big data'.

This book will help you learn the pros and cons of storing data in SAS. As you progress, you'll understand how to document and design extract-transform-load (ETL) protocols for SAS processes. Later, you'll focus on how the use of SAS arrays and macros can help standardize ETL. The book will also help you examine approaches for serving up data using SAS and explore how connecting SAS to other systems can enhance the data warehouse user's experience.

By the end of this data management book, you will have a fundamental understanding of the roles SAS can play in a warehouse environment, and be able to choose wisely when designing your data warehousing processes involving SAS.

What you will learn

  • Develop efficient ways to manage data input/output (I/O) in SAS
  • Create and manage extract, transform, and load (ETL) code in SAS
  • Standardize ETL through macro variables, macros, and arrays
  • Identify data warehouse users and ensure their needs are met
  • Design crosswalk and other variables to serve analyst needs
  • Maintain data curation files to improve communication and management
  • Use the output delivery system (ODS) for print and web reporting
  • Connect other products to SAS to optimize storage and reporting

Who this book is for

This book is for data architects, managers leading data projects, and programmers or developers using SAS who want to effectively maintain a data lake, data mart, or data warehouse.

商品描述(中文翻譯)

建立堅實的 SAS 數據倉儲基礎，了解數據轉換代碼和政策、數據管理與治理、SAS 與其他倉儲產品之間的互聯互通，以及列印和網頁報告。

主要特點

- 了解如何使用 SAS 宏來標準化提取、轉換和加載 (ETL) 協議
- 開發和使用數據策展文件以有效管理倉儲
- 學習如何開發和管理滿足用戶需求的 ETL、政策以及列印和網頁報告

書籍描述

SAS 在數據倉儲的開發和維護中被用於各種功能，因為它能夠處理「大數據」而享有盛譽。

本書將幫助您了解在 SAS 中存儲數據的優缺點。隨著學習的深入，您將了解如何為 SAS 流程記錄和設計提取-轉換-加載 (ETL) 協議。之後，您將專注於如何使用 SAS 陣列和宏來標準化 ETL。本書還將幫助您檢視使用 SAS 提供數據的方式，並探索如何將 SAS 連接到其他系統以增強數據倉儲用戶的體驗。

在本書結束時，您將對 SAS 在倉儲環境中所能扮演的角色有基本的理解，並能在設計涉及 SAS 的數據倉儲流程時做出明智的選擇。

您將學到的內容

- 開發有效的方式來管理 SAS 中的數據輸入/輸出 (I/O)
- 在 SAS 中創建和管理提取、轉換和加載 (ETL) 代碼
- 通過宏變數、宏和陣列標準化 ETL
- 確定數據倉儲用戶並確保滿足他們的需求
- 設計交叉走道和其他變數以滿足分析師的需求
- 維護數據策展文件以改善溝通和管理
- 使用輸出交付系統 (ODS) 進行列印和網頁報告
- 將其他產品連接到 SAS 以優化存儲和報告

本書適合對象

本書適合數據架構師、負責數據項目的經理，以及希望有效維護數據湖、數據集市或數據倉儲的 SAS 程式設計師或開發人員。

作者簡介

Monika Wahi, MPH, CPH, is a well-published epidemiologist, biostatistician, informaticist, and data scientist. For over 20 years, Monika has worked at various governmental organizations and non-profits, and led consulting projects in academia and for governments both in the United States and internationally. She is President of DethWench Professional Services (DPS), which offers consulting and training in data science, specializing in public health and healthcare. Monika is proficient in SAS, R, Excel, and SQL, and is the author of many articles and online courses in data science and health data analytics.

作者簡介(中文翻譯)

Monika Wahi，公共衛生碩士（MPH）、認證公共衛生專家（CPH），是一位發表眾多論文的流行病學家、生物統計學家、資訊學家和數據科學家。超過20年來，Monika在各種政府機構和非營利組織工作，並在美國及國際上領導學術界和政府的諮詢專案。她是DethWench專業服務（DPS）的總裁，該公司提供數據科學的諮詢和培訓，專注於公共衛生和醫療保健。Monika精通SAS、R、Excel和SQL，並撰寫了許多有關數據科學和健康數據分析的文章及線上課程。

目錄大綱

  1. Using SAS in a Data Mart, Data Lake, or Data Warehouse
  2. Reading Big Data into SAS
  3. Helpful PROCs for Managing Data
  4. Managing ETL in SAS
  5. Managing Data Reporting in SAS
  6. Standardizing Coding Using SAS Arrays
  7. Designing and Developing ETL Code in SAS
  8. Using Macros to Automate ETL in SAS
  9. Debugging and Troubleshooting in SAS
  10. Considering the User Needs of SAS Data Warehouses
  11. Connecting the SAS Data Warehouse to Other Systems
  12. Using the ODS for Visualization in SAS

目錄大綱(中文翻譯)


  1. Using SAS in a Data Mart, Data Lake, or Data Warehouse

  2. Reading Big Data into SAS

  3. Helpful PROCs for Managing Data

  4. Managing ETL in SAS

  5. Managing Data Reporting in SAS

  6. Standardizing Coding Using SAS Arrays

  7. Designing and Developing ETL Code in SAS

  8. Using Macros to Automate ETL in SAS

  9. Debugging and Troubleshooting in SAS

  10. Considering the User Needs of SAS Data Warehouses

  11. Connecting the SAS Data Warehouse to Other Systems

  12. Using the ODS for Visualization in SAS

類似商品

最後瀏覽商品 (18)