Cargando…
Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. /
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 skill...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2020.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_on1203953754 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr ||||||||||| | ||
| 008 | 201016s2020 enk o 000 0 eng d | ||
| 040 | |a UKAHL |b eng |e pn |c UKAHL |d YDX |d N$T |d OCLCO |d OCLCF |d UKMGB |d EBLCP |d OCLCQ |d OCLCO |d KSU |d OCLCQ | ||
| 015 | |a GBC0G8258 |2 bnb | ||
| 016 | 7 | |a 019991744 |2 Uk | |
| 019 | |a 1201297571 | ||
| 020 | |a 1789531187 | ||
| 020 | |a 9781789531183 |q (electronic bk.) | ||
| 020 | |z 9781789532371 |q (pbk.) | ||
| 029 | 1 | |a AU@ |b 000068846019 | |
| 029 | 1 | |a UKMGB |b 019991744 | |
| 029 | 1 | |a AU@ |b 000068339100 | |
| 035 | |a (OCoLC)1203953754 |z (OCoLC)1201297571 | ||
| 037 | |a 9781789531183 |b Packt Publishing | ||
| 050 | 4 | |a QA76.9.D37 | |
| 082 | 0 | 4 | |a 005.745 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Wahi, Monika, |e author. | |
| 245 | 1 | 0 | |a Mastering SAS Programming for Data Warehousing : |b an advanced programming guide to designing and managing Data Warehouses using SAS. / |c Monika Wahi, Wahi. |
| 260 | |b Packt Publishing, |c 2020. | ||
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 520 | |a 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. | ||
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a Data warehousing. | |
| 650 | 0 | |a SAS (Computer program language) | |
| 650 | 6 | |a Entrepôts de données (Informatique) | |
| 650 | 6 | |a SAS (Langage de programmation) | |
| 650 | 7 | |a Data warehousing. |2 fast |0 (OCoLC)fst00888026 | |
| 650 | 7 | |a SAS (Computer program language) |2 fast |0 (OCoLC)fst01738546 | |
| 776 | 0 | 8 | |i Print version : |z 9781789532371 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781789532371/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH37757135 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6414485 | ||
| 938 | |a EBSCOhost |b EBSC |n 2655461 | ||
| 938 | |a YBP Library Services |b YANK |n 301634249 | ||
| 994 | |a 92 |b IZTAP | ||