Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

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)
Buy this Book
close
close
Mastering SAS Programming for Data Warehousing

Mastering SAS Programming for Data Warehousing

4.4 (5)
By: Monika Wahi
Buy this Book

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
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Download the example code files
Icon
Download the color images
Icon
Conventions used
Icon
Get in touch
Icon
Reviews
1
Section 1: Managing Data in a SAS Data Warehouse
Icon
Section 1: Managing Data in a SAS Data Warehouse
Lock Free Chapter
2
Chapter 1: Using SAS in a Data Mart, Data Lake, or Data Warehouse
Icon
Chapter 1: Using SAS in a Data Mart, Data Lake, or Data Warehouse
Icon
Technical requirements
Icon
Using original versions of SAS
Icon
Accessing data in SAS
Icon
Improving I/O
Icon
Dealing with storage and memory issues
Icon
Using SAS in modern warehousing
Icon
Summary
Icon
Questions
Icon
Further reading
3
Chapter 2: Reading Big Data into SAS
chevron up
Icon
Chapter 2: Reading Big Data into SAS
Icon
Technical requirements
Icon
Reading data extracts into SAS
Icon
Using the SAS XPT format
Icon
Working with other file formats
Icon
Dealing with difficult data
Icon
Summary
Icon
Questions
Icon
Further reading
4
Chapter 3: Helpful PROCs for Managing Data
Icon
Chapter 3: Helpful PROCs for Managing Data
Icon
Technical requirements
Icon
PROCs for understanding data
Icon
Using labels and formats in processing
Icon
Viewing data in SAS
Icon
Summary
Icon
Questions
Icon
Further reading
5
Chapter 4: Managing ETL in SAS
Icon
Chapter 4: Managing ETL in SAS
Icon
Technical requirements
Icon
Setting up an analytic environment
Icon
Planning for data transformation
Icon
Developing policy
Icon
Summary
Icon
Questions
Icon
Further reading
6
Chapter 5: Managing Data Reporting in SAS
Icon
Chapter 5: Managing Data Reporting in SAS
Icon
Technical requirements
Icon
Using the ODS for data files
Icon
Using the ODS for graphics files
Icon
SAS PROCs designed for reporting
Icon
Summary
Icon
Questions
Icon
Further reading
7
Section 2: Using SAS for Extract-Transform-Load (ETL) Protocols in a Data Warehouse
Icon
Section 2: Using SAS for Extract-Transform-Load (ETL) Protocols in a Data Warehouse
8
Chapter 6: Standardizing Coding Using SAS Arrays
Icon
Chapter 6: Standardizing Coding Using SAS Arrays
Icon
Technical requirements
Icon
Understanding examples of arrays used to create variables
Icon
Conditions and index variables in array processing
Icon
Limitations of arrays
Icon
Summary
Icon
Questions
Icon
Further reading
9
Chapter 7: Designing and Developing ETL Code in SAS
Icon
Chapter 7: Designing and Developing ETL Code in SAS
Icon
Technical requirements
Icon
Planning the ETL approach
Icon
Creating transformation code
Icon
Summary
Icon
Questions
Icon
Further reading
10
Chapter 8: Using Macros to Automate ETL in SAS
Icon
Chapter 8: Using Macros to Automate ETL in SAS
Icon
Technical requirements
Icon
Creating macros out of data step code
Icon
Storing and calling macros
Icon
Loading transformed data
Icon
Summary
Icon
Questions
Icon
Further reading
11
Chapter 9: Debugging and Troubleshooting in SAS
Icon
Chapter 9: Debugging and Troubleshooting in SAS
Icon
Technical requirements
Icon
Debugging data step code
Icon
Debugging the do loop code
Icon
Debugging SAS macros
Icon
Summary
Icon
Questions
Icon
Further reading
12
Section 3: Using SAS When Serving Warehouse Data to Users
Icon
Section 3: Using SAS When Serving Warehouse Data to Users
13
Chapter 10: Considering the User Needs of SAS Data Warehouses
Icon
Chapter 10: Considering the User Needs of SAS Data Warehouses
Icon
Technical requirements
Icon
Needs of data warehouse users
Icon
Data stewardship for serving warehouse users
Icon
Data stewardship for serving warehouse developers
Icon
Summary
Icon
Questions
Icon
Further reading
14
Chapter 11: Connecting the SAS Data Warehouse to Other Systems
Icon
Chapter 11: Connecting the SAS Data Warehouse to Other Systems
Icon
Technical requirements
Icon
Serving SAS to other systems
Icon
Connecting to non-SAS data storage
Icon
Innovations in integrating SAS in reporting functions
Icon
Summary
Icon
Questions
Icon
Further reading
15
Chapter 12: Using the ODS for Visualization in SAS
Icon
Chapter 12: Using the ODS for Visualization in SAS
Icon
Technical requirements
Icon
The basics of using the ODS for data visualization
Icon
Serving SAS data to the web with the ODS
Icon
Using SAS and R for visualizations
Icon
Considerations when reporting SAS warehouse data
Icon
Summary
Icon
Questions
Icon
Further reading
16
Assessments
Icon
Chapter 1
Icon
Chapter 2
Icon
Chapter 3
Icon
Chapter 4
Icon
Chapter 5
Icon
Chapter 6
Icon
Chapter 7
Icon
Chapter 8
Icon
Chapter 9
Icon
Chapter 10
Icon
Chapter 11
Icon
Chapter 12
17
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Leave a review - let other readers know what you think

Dealing with difficult data

Up until now, we have discussed reading data into SAS in typical SAS and non-SAS formats. Because SAS is able to handle such large datasets, it is common to receive data from legacy systems that were built many decades ago but continue to be used to store big data. These systems can produce data extracts that are difficult to read into SAS environments.

This section will cover the following:

  • How legacy data is typically documented, and how the information in this documentation can be helpful for informing the development of infile code.

  • How file viewer and big data editor applications can be helpful in developing infile code for legacy data extracts.

  • How to adjust infile options, format, and informat to troubleshoot reading in difficult data.

  • How to use PROC PRINT and PROC CONTENTS as part of troubleshooting reading in difficult data.

  • How to use file positions to read in difficult data from a fixed width file.

  • How to verify...

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
End of Section 3
Next Section
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
Order Page Read Now

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