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

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

Chapter 2

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.
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.
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.
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...