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

Setting up an analytic environment

An analytic environment conceptually refers to a technological environment in which analytics takes place. This can be as simple as a designated directory on a hard drive for storing files associated with analyzing a small survey dataset. In SAS data warehousing, the analytic environment encompasses the parts of the data warehouse in which analytics take place. While this is not a very specific definition, it can be better understood when thinking of permissions associated with user groups. Analysts and developers who build and maintain the SAS warehouse need access to the parts of the analytic environment they must use in order to perform their functions. Users who are outside the analytic environment could be considered end users of the SAS data warehouse. These include readers of reports from the SAS data warehouse or users of a web dashboard placed on data from a SAS data warehouse.

Setting up and running a SAS data warehouse requires a lot...

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