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...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Packt Publishing,
2020.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | 1 online resource |
| ISBN: | 1789531187 9781789531183 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-on1203953754 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.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 |d OCLCO |d OCLCL | ||
| 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.) | ||
| 035 | |a (OCoLC)1203953754 |z (OCoLC)1201297571 | ||
| 037 | |a 9781789531183 |b Packt Publishing | ||
| 050 | 4 | |a QA76.9.D37 | |
| 082 | 7 | |a 005.745 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Wahi, Monika, |e author. |0 http://id.loc.gov/authorities/names/n2017032456 | |
| 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 | |
| 650 | 0 | |a Data warehousing. |0 http://id.loc.gov/authorities/subjects/sh97003695 | |
| 650 | 0 | |a SAS (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh2005006970 | |
| 650 | 6 | |a Entrepôts de données (Informatique) | |
| 650 | 6 | |a SAS (Langage de programmation) | |
| 650 | 7 | |a Data warehousing |2 fast | |
| 650 | 7 | |a SAS (Computer program language) |2 fast | |
| 758 | |i has work: |a Mastering SAS Programming for Data Warehousing (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFYmbXWVbtyPpVDTBw7Q9C |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version : |z 9781789532371 |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2655461 |3 Volltext |
| 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 GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-on1203953754 |
|---|---|
| _version_ | 1816882532448206848 |
| adam_text | |
| any_adam_object | |
| author | Wahi, Monika |
| author_GND | http://id.loc.gov/authorities/names/n2017032456 |
| author_facet | Wahi, Monika |
| author_role | aut |
| author_sort | Wahi, Monika |
| author_variant | m w mw |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D37 |
| callnumber-search | QA76.9.D37 |
| callnumber-sort | QA 276.9 D37 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| 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 |
| ctrlnum | (OCoLC)1203953754 |
| dewey-full | 005.745 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.745 |
| dewey-search | 005.745 |
| dewey-sort | 15.745 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05487cam a2200565 a 4500</leader><controlfield tag="001">ZDB-4-EBA-on1203953754</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr |||||||||||</controlfield><controlfield tag="008">201016s2020 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UKAHL</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">UKAHL</subfield><subfield code="d">YDX</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">UKMGB</subfield><subfield code="d">EBLCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">KSU</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBC0G8258</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">019991744</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">1201297571</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1789531187</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781789531183</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781789532371</subfield><subfield code="q">(pbk.)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1203953754</subfield><subfield code="z">(OCoLC)1201297571</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">9781789531183</subfield><subfield code="b">Packt Publishing</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D37</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.745</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Wahi, Monika,</subfield><subfield code="e">author.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2017032456</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Mastering SAS Programming for Data Warehousing :</subfield><subfield code="b">an advanced programming guide to designing and managing Data Warehouses using SAS. /</subfield><subfield code="c">Monika Wahi, Wahi.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="b">Packt Publishing,</subfield><subfield code="c">2020.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Data warehousing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh97003695</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SAS (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh2005006970</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Entrepôts de données (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">SAS (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data warehousing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SAS (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Mastering SAS Programming for Data Warehousing (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCFYmbXWVbtyPpVDTBw7Q9C</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version :</subfield><subfield code="z">9781789532371</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2655461</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH37757135</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest Ebook Central</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL6414485</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">2655461</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">301634249</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-on1203953754 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:30:07Z |
| institution | BVB |
| isbn | 1789531187 9781789531183 |
| language | English |
| oclc_num | 1203953754 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource |
| psigel | ZDB-4-EBA |
| publishDate | 2020 |
| publishDateSearch | 2020 |
| publishDateSort | 2020 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Wahi, Monika, author. http://id.loc.gov/authorities/names/n2017032456 Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / Monika Wahi, Wahi. Packt Publishing, 2020. 1 online resource text txt rdacontent computer c rdamedia online resource cr rdacarrier 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. 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 Data warehousing. http://id.loc.gov/authorities/subjects/sh97003695 SAS (Computer program language) http://id.loc.gov/authorities/subjects/sh2005006970 Entrepôts de données (Informatique) SAS (Langage de programmation) Data warehousing fast SAS (Computer program language) fast has work: Mastering SAS Programming for Data Warehousing (Text) https://id.oclc.org/worldcat/entity/E39PCFYmbXWVbtyPpVDTBw7Q9C https://id.oclc.org/worldcat/ontology/hasWork Print version : 9781789532371 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2655461 Volltext |
| spellingShingle | Wahi, Monika Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / 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 Data warehousing. http://id.loc.gov/authorities/subjects/sh97003695 SAS (Computer program language) http://id.loc.gov/authorities/subjects/sh2005006970 Entrepôts de données (Informatique) SAS (Langage de programmation) Data warehousing fast SAS (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh97003695 http://id.loc.gov/authorities/subjects/sh2005006970 |
| title | Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / |
| title_auth | Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / |
| title_exact_search | Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / |
| title_full | Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / Monika Wahi, Wahi. |
| title_fullStr | Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / Monika Wahi, Wahi. |
| title_full_unstemmed | Mastering SAS Programming for Data Warehousing : an advanced programming guide to designing and managing Data Warehouses using SAS. / Monika Wahi, Wahi. |
| title_short | Mastering SAS Programming for Data Warehousing : |
| title_sort | mastering sas programming for data warehousing an advanced programming guide to designing and managing data warehouses using sas |
| title_sub | an advanced programming guide to designing and managing Data Warehouses using SAS. / |
| topic | Data warehousing. http://id.loc.gov/authorities/subjects/sh97003695 SAS (Computer program language) http://id.loc.gov/authorities/subjects/sh2005006970 Entrepôts de données (Informatique) SAS (Langage de programmation) Data warehousing fast SAS (Computer program language) fast |
| topic_facet | Data warehousing. SAS (Computer program language) Entrepôts de données (Informatique) SAS (Langage de programmation) Data warehousing |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=2655461 |
| work_keys_str_mv | AT wahimonika masteringsasprogrammingfordatawarehousinganadvancedprogrammingguidetodesigningandmanagingdatawarehousesusingsas |