| Description |
1 online resource |
| Summary |
SAS software has been in existence for a long time and has been implemented in large, data-intensive environments, including data warehouses. This SAS book covers practical programming considerations to make when involving SAS in a data warehouse environment. You'll be able to develop the skills you need to apply SAS in your working environment. |
| Contents |
Cover -- Title Page -- Copyright and Credits -- Dedication -- About Packt -- Contributors -- Table of Contents -- Preface -- Section 1: Managing Data in a SAS Data Warehouse -- Chapter 1: Using SAS in a Data Mart, Data Lake, or Data Warehouse -- Technical requirements -- Using original versions of SAS -- Initial SAS data handling -- Early SAS data handling -- SAS data handling improvements -- Accessing data in SAS -- Upgrading to mainframes -- Transitioning to personal computers -- Reading external files -- Improving I/O -- Developing warehouse environments -- Using the WHERE clause |
|
Using IF compared to WHERE -- Sorting in SAS -- Setting indexes on variables -- Dealing with storage and memory issues -- Avoiding memory issues -- Accommodating Structured Query Language -- Using PROC SQL -- Using SAS today in a warehouse environment -- Using SAS in the cloud -- Using SAS in modern warehousing -- Warehousing unstructured text -- Using SAS components for warehousing -- Using other applications with SAS -- Connecting to Snowflake -- Summary -- Questions -- Further reading -- Chapter 2: Reading Big Data into SAS -- Technical requirements -- Reading data extracts into SAS |
|
Understanding SAS datasets -- Working with the WORK directory -- Specifying LIBNAME -- Reading in SAS datasets -- Using the SAS XPT format -- Storing data in XPT format -- Creating an XPT file -- Comparing PROC CPORT/CIMPORT to PROC COPY -- Reading in XPTs using the XPORT engine -- Working with other file formats -- Reading non-SAS data formats -- Using PROC IMPORT -- Converting non-SAS data to SAS format -- Dealing with difficult data -- Understanding legacy data -- Reading data with difficult formats -- Specifying data locations in a fixed-width file |
|
Troubleshooting reading data after transport -- Summary -- Questions -- Further reading -- Chapter 3: Helpful PROCs for Managing Data -- Technical requirements -- PROCs for understanding data -- Using PROC CONTENTS to understand data -- Documenting SAS data with codebooks -- Using labels for variables -- Adding user-defined formats to categorical variables -- Using native SAS formats with numeric variables -- Applying user-defined formats to continuous variables -- Using labels and formats in processing -- Using PROCs with labels and formats -- Maintaining labels and formats |
|
Alternatives to using labels and formats in a warehouse setting -- Viewing data in SAS -- Using PROC PRINT to view data -- Using PROC SQL to view data -- Using arithmetic operators in SAS -- Viewing data through SAS windows -- Summary -- Questions -- Further reading -- Chapter 4: Managing ETL in SAS -- Technical requirements -- Setting up an analytic environment -- Designating storage and user groups -- Managing documentation storage -- Setting naming conventions for datasets -- Planning for data transformation -- Understanding arrays in SAS -- Setting naming conventions for variables |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Data warehousing.
|
|
SAS (Computer program language)
|
|
Data warehousing |
|
SAS (Computer program language) |
| Other Form: |
Print version : 9781789532371 |
| ISBN |
1789531187 |
|
9781789531183 (electronic bk.) |
|
9781789532371 (pbk.) |
|
