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 2

  1. The XPT format is a SAS format used for reducing the size of *.SAS7bdat datasets so they can be transported and extracted into another SAS system.

  2. The GUESSINGROWS option in PROC IMPORT allows the user to set how many rows SAS reads in order to guess the informat, format, and input code PROC IMPORT automatically generates for the infile statement.

  3. Using PROC IMPORT with a dataset induces SAS to guess at building infile code. SAS automatically builds this code, then outputs to the log file. Even if this code has errors, much of the generated code is helpful to the programmer because it already has format, informat, and input lines for each variable in the source dataset. The programmer can copy this generated code from the log file into a code file and edit out the errors.

  4. Because fixed-width files do not have delimiters, and the analyst must include in SAS infile code the positions for each character of each variable in each row (or record). Without documentation...

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