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

SAS white paper, Build Your Metadata with PROC CONTENTS and ODS Output, by Louise Hadden, available here: https://support.sas.com/resources/papers/proceedings14/1549-2014.pdf
Link to SAS support page listing all the ODS tables produced with the PROC UNIVARIATE statement: https://support.sas.com/documentation/cdl/en/procstat/63963/HTML/default/viewer.htm#procstat_univariate_sect051.htm
Link to SAS support page listing ODS table names produced by base SAS procedures: https://documentation.sas.com/?docsetId=odsproc&docsetTarget=p037wkiv6e4hqln1snmfk9b7c9it.htm&docset Version=9.4&locale=en
SAS documentation on setting system options: https://documentation.sas.com/?docsetId=hosto390&docsetTarget=p0ek9qjzqu2li5n1 seq9z0s1gayi.htm&docsetVersion=9.4&locale=en
SAS white paper, A Gentle Introduction to the Powerful REPORT Procedure, by Ben Cochran, available here: https://support.sas.com/resources/papers/proceedings/proceedings/sugi30...

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

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

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

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

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

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

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

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

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

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

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