Advanced SQL with SAS - Rilegato

Schendera, Christian Fg

 
9781955977906: Advanced SQL with SAS
Rilegato
ISBN 10: 1955977909 ISBN 13: 9781955977906
Casa editrice: SAS Institute, 2022

Sinossi

This book introduces advanced techniques for using PROC SQL in SAS. If you are a SAS programmer, analyst, or student who has mastered the basics of working with SQL, Advanced SQL with SAS® will help take your skills to the next level. Filled with practical examples with detailed explanations, this book demonstrates how to improve performance and speed for large data sets. Although the book addresses advanced topics, it is designed to progress from the simple and manageable to the complex and sophisticated.

In addition to numerous tuning techniques, this book also touches on implicit and explicit pass-throughs, presents alternative SAS grid- and cloud-based processing environments, and compares SAS programming languages and approaches including FedSQL, CAS, DS2, and hash programming. Other topics include:

  • Missing values and data quality with audit trails
  • "Blind spots" like how missing values can affect even the simplest calculations and table joins
  • SAS macro language and SAS macro programs
  • SAS functions
  • Integrity constraints
  • SAS Dictionaries
  • SAS Compute Server

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull?autore

Dr. Christian FG Schendera is a Senior SAS Data Scientist and managing director at Method Consult in Switzerland. An avid SAS user for 30+ years, his experience ranges from scientific consulting, project management, and feature-engineering to statistical modeling using SAS. He studied at Heidelberg University and Martin Luther University Halle-Wittenberg. While still a student, he started consulting in statistics and research methods, lecturing on SAS, applied statistics, and the knowledge-shaping role of non-scientific methods. Christian views constructing knowledge as a two-way street: every step from data collection to applying methods will affect results. He has published several books about statistics, data quality, programming, and SAS. He is author of the most comprehensive double-volume about PROC SQL worldwide. Further information and downloads can be found at www.method-consult.ch.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
SAS Institute
Data di pubblicazione
2022
Lingua
Inglese
ISBN 10 
1955977909
ISBN 13 
9781955977906
Rilegatura
Copertina rigida
Numero di pagine
428
Contatto del produttore
non disponibile
Persona responsabile
non disponibile

Altre edizioni note dello stesso titolo

9781955977876: Advanced SQL with SAS®

Edizione in evidenza

ISBN 10:  1955977879 ISBN 13:  9781955977876
Casa editrice: SAS Institute, 2022
Brossura