Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering SAS Programming for Data Warehousing
  • Table Of Contents Toc
Mastering SAS Programming for Data Warehousing

Mastering SAS Programming for Data Warehousing

By : Monika Wahi
4.4 (5)
close
close
Mastering SAS Programming for Data Warehousing

Mastering SAS Programming for Data Warehousing

4.4 (5)
By: Monika Wahi

Overview of this book

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.
Table of Contents (18 chapters)
close
close
1
Section 1: Managing Data in a SAS Data Warehouse
7
Section 2: Using SAS for Extract-Transform-Load (ETL) Protocols in a Data Warehouse
12
Section 3: Using SAS When Serving Warehouse Data to Users

Chapter 5: Managing Data Reporting in SAS

This chapter will introduce you to the different ways in which SAS handles data reporting. First, we will talk about the invention of the output delivery system (ODS). When PROCs run, they create internal tables and files that are not accessible outside of the PROC. First, you will learn how to use the ODS to output internal tables as data tables. Next, you will learn how to use the ODS to save the textual and graphical output from SAS PROCs in *.pdf, *.rtf, and *.htm format.

After that, the chapter will focus on PROCs in SAS designed specifically for reporting that leverage the ODS as part of how the PROC runs. First, you will be shown how to build a tabular report, first in PROC REPORT and then in PROC TABULATE. Next, the family of graphing PROCs, including PROC SGPLOT, PROC SGPANEL, PROC SGSCATTER, and PROC SGRENDER, will be demonstrated. PROCs SGPLOT, PROC SGPANEL, and PROC SGSCATTER provide more options for customization than using...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering SAS Programming for Data Warehousing
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon