0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Mastering SAS Programming for Data Warehousing

You're reading from Mastering SAS Programming for Data Warehousing An advanced programming guide to designing and managing Data Warehouses using SAS

Product type Paperback

Published in Oct 2020

Publisher Packt

ISBN-13 9781789532371

Length 494 pages

Edition 1st Edition

Tools

SAS

Concepts

Application Development

Author (1):

Monika Wahi

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Managing Data in a SAS Data Warehouse

2. Chapter 1: Using SAS in a Data Mart, Data Lake, or Data Warehouse FREE CHAPTER

3. Chapter 2: Reading Big Data into SAS

4. Chapter 3: Helpful PROCs for Managing Data

5. Chapter 4: Managing ETL in SAS

6. Chapter 5: Managing Data Reporting in SAS

7. Section 2: Using SAS for Extract-Transform-Load (ETL) Protocols in a Data Warehouse

8. Chapter 6: Standardizing Coding Using SAS Arrays

9. Chapter 7: Designing and Developing ETL Code in SAS

10. Chapter 8: Using Macros to Automate ETL in SAS

11. Chapter 9: Debugging and Troubleshooting in SAS

12. Section 3: Using SAS When Serving Warehouse Data to Users

13. Chapter 10: Considering the User Needs of SAS Data Warehouses

14. Chapter 11: Connecting the SAS Data Warehouse to Other Systems

15. Chapter 12: Using the ODS for Visualization in SAS

16. Assessments

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Further reading

The Understanding Star Schemas website from the Oracle Data Mart Builder Population Guide, available here: http://gkmc.utah.edu/ebis_class/2003s/Oracle/DMB26/A73318/schemas.htm
The SAS white paper, Transporting Data in the SAS Universe, by John Malloch and Jayne May Miller, available here: https://www.lexjansen.com/nesug/nesug04/po/po06.pdf
The SAS white paper, Using Proc SQL and ODBC to Manage Data outside of SAS, by Jeff Magouirk, available here: https://www.lexjansen.com/wuss/2004/data_warehousing/c_dwdb_using_proc_sql_and_od.pdf
The SAS white paper, Using SAS Views and SQL Views, by Lynn Palmer, available here: https://www.lexjansen.com/wuss/2003/DatabaseManagement/c-using_sas_views_and_sql_views.pdf
Florida AHCA Office of Data Dissemination and Transparency: https://ahca.myflorida.com/schs/DataD/DataD.shtml

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Monika Wahi

Monika Wahi

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.

See other products by Monika Wahi

Other recommended products

Related to this chapter

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Big Data Analytics with SAS

Big Data Analytics with SAS

SAS provides innovative data management, analytics, and business intelligence software and services which helps their customers to make better decisions faster. SAS is the world leader in analytics and recognized as one of the top business skills to learn to advance one's career. This book provides the reader with hands-on examples of using SAS for data management, analysis, and reporting and how explains how they can use SAS to perform efficient Big Data analytics.

Nov 2017 8h 52m

Hands-On SAS For Data Analysis

Hands-On SAS For Data Analysis

SAS is one of the leading enterprise tools in the world today when it comes to data management and analysis. It allows for faster, easier processing of data and empowers you to get valuable business insights for effective decision-making. This book will serve as a comprehensive guide you can refer to while preparing for your SAS certification exam.

Sep 2019 11h 32m

Personalised recommendations for you

Based on your interests and search pattern

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m

System Programming Essentials with Go

System Programming Essentials with Go

From file operations to process management and network programming, this hands-on guide equips software engineers with the skills to build efficient, reliable applications and optimize their performance.

Jun 2024 13h 36m

Modern Python Cookbook

Modern Python Cookbook

The new edition of Modern Python Cookbook provides over 130 recipes for solving real-world problems with Python. Updated for Python 3.12 with new recipes and chapters. This practical guide will enhance your skills and teach you advanced techniques.

Jul 2024 27h 16m

The Ultimate Zoom Cookbook

The Ultimate Zoom Cookbook

This cookbook is an in-depth guide to using Zoom effectively. You'll be able to follow each recipe easily to harness the power of the communication and collaboration tools in Zoom.

May 2024 11h 20m

Enterprise Architecture with .NET

Enterprise Architecture with .NET

This book will help you create applications that integrate correctly into complex and ever-changing information systems. You'll execute this by using industry standards that reduce the app's technical debt and elevate software development practices.

May 2024 25h 44m

Salesforce B2C Solution Architect's Handbook

Salesforce B2C Solution Architect's Handbook

Discover how Salesforce Customer 360 unifies Marketing Cloud, B2C Commerce, Data Cloud, and Service Cloud into one solution, and learn the capabilities, integration options, limitations, and workflows to create value for your organization.

May 2024 15h 28m

Systems Programming with C# and .NET

Systems Programming with C# and .NET

Unlock the full potential of C# and .NET Core in systems programming to secure, deploy, and maintain robust applications. With this book, you'll focus on low-level APIs, memory management, and performance optimization.

Jul 2024 15h 48m

Technical Program Manager's Handbook

Technical Program Manager's Handbook

Unlock the full potential of your career as a TPM with this comprehensive guide, featuring new chapters on AI and more. Learn advanced techniques and gain insights from industry leaders. Elevate your skills and thrive in the Big Five tech companies.

Sep 2024 12h 16m

Microsoft Power Pages in Action

Microsoft Power Pages in Action

Packed with real-world examples, low-code coding techniques, and insights into crafting responsive pages, automating apps, and enhancing virtual agents, Microsoft Power Pages in Action is a valuable resource for building feature-rich web apps.

Jun 2024 11h 40m