SAS Hash Object Programming Made Easy

Download SAS Hash Object Programming Made Easy PDF Online Free

Author :
Publisher :
ISBN 13 : 9781607648017
Total Pages : 0 pages
Book Rating : 4.6/5 (48 download)

DOWNLOAD NOW!


Book Synopsis SAS Hash Object Programming Made Easy by : Michele M. Burlew

Download or read book SAS Hash Object Programming Made Easy written by Michele M. Burlew and published by . This book was released on 2012 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: Hash objects, an efficient look-up tool in the SAS DATA step, are object-oriented programming structures that function differently from traditional SAS language statements. Michele Burlew's SAS Hash Object Programming Made Easy shows readers how to use these powerful features, which they can program to quickly look up and manage data and to conserve computing resources. SAS provides various look-up techniques, and hash objects are among the newest, so therefore many users may not have yet used them. Because the examples presented vary in complexity, SAS Hash Object Programming Made Easy is useful to SAS users of all experience levels, from novice programmer to advanced programmer. Novice programmers can adapt some of the simpler hash programming techniques as they develop their SAS programming skills. This book helps more experienced programmers learn how to take advantage of hash object programming by comparing traditional processing techniques to those that use hash objects. Additionally, users from diverse fields with different requirements can adapt the examples in SAS Hash Object Programming Made Easy to fit their unique situations. This book is part of the SAS Press program.

SAS Hash Object Programming Made Easy (Hardcover Edition)

Download SAS Hash Object Programming Made Easy (Hardcover Edition) PDF Online Free

Author :
Publisher :
ISBN 13 : 9781642957945
Total Pages : 208 pages
Book Rating : 4.9/5 (579 download)

DOWNLOAD NOW!


Book Synopsis SAS Hash Object Programming Made Easy (Hardcover Edition) by : Michele M. Burlew

Download or read book SAS Hash Object Programming Made Easy (Hardcover Edition) written by Michele M. Burlew and published by . This book was released on 2012-09-14 with total page 208 pages. Available in PDF, EPUB and Kindle. Book excerpt: Hash objects, an efficient look-up tool in the SAS DATA step, are object-oriented programming structures that function differently from traditional SAS language statements. Michele Burlew's SAS Hash Object Programming Made Easy shows readers how to use these powerful features, which they can program to quickly look up and manage data and to conserve computing resources. SAS provides various look-up techniques, and hash objects are among the newest, so therefore many users may not have yet used them. Because the examples presented vary in complexity, SAS Hash Object Programming Made Easy is useful to SAS users of all experience levels, from novice programmer to advanced programmer. Novice programmers can adapt some of the simpler hash programming techniques as they develop their SAS programming skills. This book helps more experienced programmers learn how to take advantage of hash object programming by comparing traditional processing techniques to those that use hash objects. Additionally, users from diverse fields with different requirements can adapt the examples in SAS Hash Object Programming Made Easy to fit their unique situations.

Data Management Solutions Using SAS Hash Table Operations

Download Data Management Solutions Using SAS Hash Table Operations PDF Online Free

Author :
Publisher : SAS Institute
ISBN 13 : 1635260590
Total Pages : 400 pages
Book Rating : 4.6/5 (352 download)

DOWNLOAD NOW!


Book Synopsis Data Management Solutions Using SAS Hash Table Operations by : Paul Dorfman

Download or read book Data Management Solutions Using SAS Hash Table Operations written by Paul Dorfman and published by SAS Institute. This book was released on 2018-07-09 with total page 400 pages. Available in PDF, EPUB and Kindle. Book excerpt: Hash tables can do a lot more than you might think! Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Study concentrates on solving your challenging data management and analysis problems via the power of the SAS hash object, whose environment and tools make it possible to create complete dynamic solutions. To this end, this book provides an in-depth overview of the hash table as an in-memory database with the CRUD (Create, Retrieve, Update, Delete) cycle rendered by the hash object tools. By using this concept and focusing on real-world problems exemplified by sports data sets and statistics, this book seeks to help you take advantage of the hash object productively, in particular, but not limited to, the following tasks: select proper hash tools to perform hash table operations use proper hash table operations to support specific data management tasks use the dynamic, run-time nature of hash object programming understand the algorithmic principles behind hash table data look-up, retrieval, and aggregation learn how to perform data aggregation, for which the hash object is exceptionally well suited manage the hash table memory footprint, especially when processing big data use hash object techniques for other data processing tasks, such as filtering, combining, splitting, sorting, and unduplicating. Using this book, you will be able to answer your toughest questions quickly and in the most efficient way possible!

SAS Macro Programming Made Easy, Third Edition

Download SAS Macro Programming Made Easy, Third Edition PDF Online Free

Author :
Publisher : SAS Institute
ISBN 13 : 1629591513
Total Pages : 457 pages
Book Rating : 4.6/5 (295 download)

DOWNLOAD NOW!


Book Synopsis SAS Macro Programming Made Easy, Third Edition by : Michele M. Burlew

Download or read book SAS Macro Programming Made Easy, Third Edition written by Michele M. Burlew and published by SAS Institute. This book was released on 2014-06-16 with total page 457 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides beginners with a thorough foundation in SAS macro programming. The macro facility is a popular part of SAS. Macro programming is a required skill for many SAS programming jobs, and the SAS Advanced Programming Certification Exam tests macro processing concepts. Whether you're looking to become certified, land a job, or increase your skills, you'll benefit from SAS Macro Programming Made Easy, Third Edition. By following Michele Burlew's examples and step-by-step instructions, you'll be able to rapidly perform repetitive programming tasks, to pass information between programming steps more easily, and to make your programming easier to read. Updated for SAS 9.4, this book teaches you the elements of the macro facility (macro variables, macro programs, macro language), how to write a macro program, techniques for macro programming, tips on using the macro facility, how the macro facility fits into SAS, and about the interfaces between the macro facility and other components of SAS. Beginning macro programmers will learn to write SAS macro programs quickly and efficiently. More experienced programmers will find this book useful to refresh their conceptual knowledge and expand on their macro programming skills. Ultimately, any user interested in automating their programs—including analysts, programmers, and report writers—will find Michele Burlew's book an excellent tutorial. -- Michele M. Burlew

Getting Started with SAS Programming

Download Getting Started with SAS Programming PDF Online Free

Author :
Publisher : SAS Institute
ISBN 13 : 1953329187
Total Pages : 344 pages
Book Rating : 4.9/5 (533 download)

DOWNLOAD NOW!


Book Synopsis Getting Started with SAS Programming by : Ron Cody

Download or read book Getting Started with SAS Programming written by Ron Cody and published by SAS Institute. This book was released on 2021-02-24 with total page 344 pages. Available in PDF, EPUB and Kindle. Book excerpt: Get up and running with SAS using Ron Cody’s easy-to-follow, step-by-step guide. Aimed at beginners, Getting Started with SAS Programming: Using SAS Studio in the Cloud uses short examples to teach SAS programming from the basics to more advanced topics in the point-and-click interactive environment of SAS Studio. To begin, you will learn how to register for SAS OnDemand for Academics, an online delivery platform for teaching and learning statistical analysis that provides free access to SAS software via the cloud. The first part of the book shows you how to use SAS Studio built-in tasks to produce a report, summarize data, and create charts and graphs. It also describes how you can perform basic statistical tests using the interactive point-and-click environment. The second part of the book uses easy-to-follow examples to show you how to write your own SAS programs and how to use SAS procedures to perform a variety of tasks. This part of the book also explains how to read data from a variety of sources: text files, Excel workbooks, and CSV files. In order to get familiar with the SAS Studio environment, this book also shows you how to access dozens of interesting data sets that are included with the SAS OnDemand for Academics platform.

Carpenter's Complete Guide to the SAS Macro Language, Third Edition

Download Carpenter's Complete Guide to the SAS Macro Language, Third Edition PDF Online Free

Author :
Publisher : SAS Institute
ISBN 13 : 1629602396
Total Pages : 540 pages
Book Rating : 4.6/5 (296 download)

DOWNLOAD NOW!


Book Synopsis Carpenter's Complete Guide to the SAS Macro Language, Third Edition by : Art Carpenter

Download or read book Carpenter's Complete Guide to the SAS Macro Language, Third Edition written by Art Carpenter and published by SAS Institute. This book was released on 2016-08-25 with total page 540 pages. Available in PDF, EPUB and Kindle. Book excerpt: Providing both a compendium of reusable and adaptable code, and opportunities for deepening your understanding and growing as a SAS programmer, this pragmatic, example-driven reference offers nearly 400 ready-to-use macros, macro functions, and macro tools that enable you to convert SAS code to macros, define macro variables, and more. --

PROC SQL

Download PROC SQL PDF Online Free

Author :
Publisher : SAS Institute
ISBN 13 : 1635266815
Total Pages : 538 pages
Book Rating : 4.6/5 (352 download)

DOWNLOAD NOW!


Book Synopsis PROC SQL by : Kirk Paul Lafler

Download or read book PROC SQL written by Kirk Paul Lafler and published by SAS Institute. This book was released on 2019-03-20 with total page 538 pages. Available in PDF, EPUB and Kindle. Book excerpt: PROC SQL: Beyond the Basics Using SAS®, Third Edition, is a step-by-step, example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book not only covers all the basics, but it also offers extensive guidance on complex topics such as set operators and correlated subqueries. Programmers at all levels will appreciate Kirk Lafler’s easy-to-follow examples, clear explanations, and handy tips to extend their knowledge of PROC SQL. This third edition explores new and powerful features in SAS® 9.4, including topics such as: IFC and IFN functions nearest neighbor processing the HAVING clause indexes It also features two completely new chapters on fuzzy matching and data-driven programming. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basics Using SAS®, Third Edition, explores this powerful database language using discussion and numerous real-world examples.

The Book of R

Download The Book of R PDF Online Free

Author :
Publisher : No Starch Press
ISBN 13 : 1593276516
Total Pages : 833 pages
Book Rating : 4.5/5 (932 download)

DOWNLOAD NOW!


Book Synopsis The Book of R by : Tilman M. Davies

Download or read book The Book of R written by Tilman M. Davies and published by No Starch Press. This book was released on 2016-07-16 with total page 833 pages. Available in PDF, EPUB and Kindle. Book excerpt: The Book of R is a comprehensive, beginner-friendly guide to R, the world’s most popular programming language for statistical analysis. Even if you have no programming experience and little more than a grounding in the basics of mathematics, you’ll find everything you need to begin using R effectively for statistical analysis. You’ll start with the basics, like how to handle data and write simple programs, before moving on to more advanced topics, like producing statistical summaries of your data and performing statistical tests and modeling. You’ll even learn how to create impressive data visualizations with R’s basic graphics tools and contributed packages, like ggplot2 and ggvis, as well as interactive 3D visualizations using the rgl package. Dozens of hands-on exercises (with downloadable solutions) take you from theory to practice, as you learn: –The fundamentals of programming in R, including how to write data frames, create functions, and use variables, statements, and loops –Statistical concepts like exploratory data analysis, probabilities, hypothesis tests, and regression modeling, and how to execute them in R –How to access R’s thousands of functions, libraries, and data sets –How to draw valid and useful conclusions from your data –How to create publication-quality graphics of your results Combining detailed explanations with real-world examples and exercises, this book will provide you with a solid understanding of both statistics and the depth of R’s functionality. Make The Book of R your doorway into the growing world of data analysis.

R For Dummies

Download R For Dummies PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 1119963133
Total Pages : 470 pages
Book Rating : 4.1/5 (199 download)

DOWNLOAD NOW!


Book Synopsis R For Dummies by : Andrie de Vries

Download or read book R For Dummies written by Andrie de Vries and published by John Wiley & Sons. This book was released on 2012-06-06 with total page 470 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master the programming language of choice among statisticians and data analysts worldwide Coming to grips with R can be tough, even for seasoned statisticians and data analysts. Enter R For Dummies, the quick, easy way to master all the R you'll ever need. Requiring no prior programming experience and packed with practical examples, easy, step-by-step exercises, and sample code, this extremely accessible guide is the ideal introduction to R for complete beginners. It also covers many concepts that intermediate-level programmers will find extremely useful. Master your R ABCs ? get up to speed in no time with the basics, from installing and configuring R to writing simple scripts and performing simultaneous calculations on many variables Put data in its place ? get to know your way around lists, data frames, and other R data structures while learning to interact with other programs, such as Microsoft Excel Make data dance to your tune ? learn how to reshape and manipulate data, merge data sets, split and combine data, perform calculations on vectors and arrays, and much more Visualize it ? learn to use R's powerful data visualization features to create beautiful and informative graphical presentations of your data Get statistical ? find out how to do simple statistical analysis, summarize your variables, and conduct classic statistical tests, such as t-tests Expand and customize R ? get the lowdown on how to find, install, and make the most of add-on packages created by the global R community for a wide variety of purposes Open the book and find: Help downloading, installing, and configuring R Tips for getting data in and out of R Ways to use data frames and lists to organize data How to manipulate and process data Advice on fitting regression models and ANOVA Helpful hints for working with graphics How to code in R What R mailing lists and forums can do for you

SAS(R) Macro Programming Made Easy, Third Edition

Download SAS(R) Macro Programming Made Easy, Third Edition PDF Online Free

Author :
Publisher :
ISBN 13 : 9781635269079
Total Pages : 386 pages
Book Rating : 4.2/5 (69 download)

DOWNLOAD NOW!


Book Synopsis SAS(R) Macro Programming Made Easy, Third Edition by : Michele M. Burlew

Download or read book SAS(R) Macro Programming Made Easy, Third Edition written by Michele M. Burlew and published by . This book was released on 2018-07-20 with total page 386 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides beginners with a thorough foundation in SAS macro programming. The macro facility is a popular part of SAS. Macro programming is a required skill for many SAS programming jobs, and the SAS Advanced Programming Certification Exam tests macro processing concepts. Whether you're looking to become certified, land a job, or increase your skills, you'll benefit from SAS Macro Programming Made Easy, Third Edition. By following Michele Burlew's examples and step-by-step instructions, you'll be able to rapidly perform repetitive programming tasks, to pass information between programming steps more easily, and to make your programming easier to read. Updated for SAS 9.4, this book teaches you the elements of the macro facility (macro variables, macro programs, macro language), how to write a macro program, techniques for macro programming, tips on using the macro facility, how the macro facility fits into SAS, and about the interfaces between the macro facility and other components of SAS. Beginning macro programmers will learn to write SAS macro programs quickly and efficiently. More experienced programmers will find this book useful to refresh their conceptual knowledge and expand on their macro programming skills. Ultimately, any user interested in automating their programs-including analysts, programmers, and report writers-will find Michele Burlew's book an excellent tutorial. This book is part of the SAS Press program.

The Art of R Programming

Download The Art of R Programming PDF Online Free

Author :
Publisher : No Starch Press
ISBN 13 : 1593273843
Total Pages : 404 pages
Book Rating : 4.5/5 (932 download)

DOWNLOAD NOW!


Book Synopsis The Art of R Programming by : Norman Matloff

Download or read book The Art of R Programming written by Norman Matloff and published by No Starch Press. This book was released on 2011-10-11 with total page 404 pages. Available in PDF, EPUB and Kindle. Book excerpt: R is the world's most popular language for developing statistical software: Archaeologists use it to track the spread of ancient civilizations, drug companies use it to discover which medications are safe and effective, and actuaries use it to assess financial risks and keep economies running smoothly. The Art of R Programming takes you on a guided tour of software development with R, from basic types and data structures to advanced topics like closures, recursion, and anonymous functions. No statistical knowledge is required, and your programming skills can range from hobbyist to pro. Along the way, you'll learn about functional and object-oriented programming, running mathematical simulations, and rearranging complex data into simpler, more useful formats. You'll also learn to: –Create artful graphs to visualize complex data sets and functions –Write more efficient code using parallel R and vectorization –Interface R with C/C++ and Python for increased speed or functionality –Find new R packages for text analysis, image manipulation, and more –Squash annoying bugs with advanced debugging techniques Whether you're designing aircraft, forecasting the weather, or you just need to tame your data, The Art of R Programming is your guide to harnessing the power of statistical computing.

Programming Persistent Memory

Download Programming Persistent Memory PDF Online Free

Author :
Publisher : Apress
ISBN 13 : 1484249321
Total Pages : 384 pages
Book Rating : 4.4/5 (842 download)

DOWNLOAD NOW!


Book Synopsis Programming Persistent Memory by : Steve Scargall

Download or read book Programming Persistent Memory written by Steve Scargall and published by Apress. This book was released on 2020-01-09 with total page 384 pages. Available in PDF, EPUB and Kindle. Book excerpt: Beginning and experienced programmers will use this comprehensive guide to persistent memory programming. You will understand how persistent memory brings together several new software/hardware requirements, and offers great promise for better performance and faster application startup times—a huge leap forward in byte-addressable capacity compared with current DRAM offerings. This revolutionary new technology gives applications significant performance and capacity improvements over existing technologies. It requires a new way of thinking and developing, which makes this highly disruptive to the IT/computing industry. The full spectrum of industry sectors that will benefit from this technology include, but are not limited to, in-memory and traditional databases, AI, analytics, HPC, virtualization, and big data. Programming Persistent Memory describes the technology and why it is exciting the industry. It covers the operating system and hardware requirements as well as how to create development environments using emulated or real persistent memory hardware. The book explains fundamental concepts; provides an introduction to persistent memory programming APIs for C, C++, JavaScript, and other languages; discusses RMDA with persistent memory; reviews security features; and presents many examples. Source code and examples that you can run on your own systems are included. What You’ll Learn Understand what persistent memory is, what it does, and the value it brings to the industry Become familiar with the operating system and hardware requirements to use persistent memory Know the fundamentals of persistent memory programming: why it is different from current programming methods, and what developers need to keep in mind when programming for persistence Look at persistent memory application development by example using the Persistent Memory Development Kit (PMDK)Design and optimize data structures for persistent memoryStudy how real-world applications are modified to leverage persistent memoryUtilize the tools available for persistent memory programming, application performance profiling, and debugging Who This Book Is For C, C++, Java, and Python developers, but will also be useful to software, cloud, and hardware architects across a broad spectrum of sectors, including cloud service providers, independent software vendors, high performance compute, artificial intelligence, data analytics, big data, etc.

SAS Data Integration Studio 3.4

Download SAS Data Integration Studio 3.4 PDF Online Free

Author :
Publisher : Sas Inst
ISBN 13 : 9781599941981
Total Pages : 393 pages
Book Rating : 4.9/5 (419 download)

DOWNLOAD NOW!


Book Synopsis SAS Data Integration Studio 3.4 by : SAS Institute

Download or read book SAS Data Integration Studio 3.4 written by SAS Institute and published by Sas Inst. This book was released on 2007 with total page 393 pages. Available in PDF, EPUB and Kindle. Book excerpt: This manual is a task-oriented introduction to the main features of SAS Data Integration Studio. SAS Data Integration Studio is a visual design tool that enables you to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. The audience for this manual is users who are responsible for data integration and who have a working knowledge of Base SAS software. This title is also available online.

SAS and Open-Source Model Management

Download SAS and Open-Source Model Management PDF Online Free

Author :
Publisher :
ISBN 13 : 9781970170818
Total Pages : 148 pages
Book Rating : 4.1/5 (78 download)

DOWNLOAD NOW!


Book Synopsis SAS and Open-Source Model Management by :

Download or read book SAS and Open-Source Model Management written by and published by . This book was released on 2020-07 with total page 148 pages. Available in PDF, EPUB and Kindle. Book excerpt: Turn analytical models into business value and smarter decisions with this special collection of papers about SAS Model Management. Without a structured and standardized process to integrate and coordinate all the different pieces of the model life cycle, a business can experience increased costs and missed opportunities. SAS Model Management solutions enable organizations to register, test, deploy, monitor, and retrain analytical models, leveraging any available technology - including open-source models in Python, R, and TensorFlow -into a competitive advantage.

A Handbook of Statistical Graphics Using SAS ODS

Download A Handbook of Statistical Graphics Using SAS ODS PDF Online Free

Author :
Publisher : CRC Press
ISBN 13 : 1466599030
Total Pages : 250 pages
Book Rating : 4.4/5 (665 download)

DOWNLOAD NOW!


Book Synopsis A Handbook of Statistical Graphics Using SAS ODS by : Geoff Der

Download or read book A Handbook of Statistical Graphics Using SAS ODS written by Geoff Der and published by CRC Press. This book was released on 2014-08-15 with total page 250 pages. Available in PDF, EPUB and Kindle. Book excerpt: Easily Use SAS to Produce Your Graphics Diagrams, plots, and other types of graphics are indispensable components in nearly all phases of statistical analysis, from the initial assessment of the data to the selection of appropriate statistical models to the diagnosis of the chosen models once they have been fitted to the data. Harnessing the full graphics capabilities of SAS, A Handbook of Statistical Graphics Using SAS ODS covers essential graphical methods needed in every statistician’s toolkit. It explains how to implement the methods using SAS 9.4. The handbook shows how to use SAS to create many types of statistical graphics for exploring data and diagnosing fitted models. It uses SAS’s newer ODS graphics throughout as this system offers a number of advantages, including ease of use, high quality of results, consistent appearance, and convenient semiautomatic graphs from the statistical procedures. Each chapter deals graphically with several sets of example data from a wide variety of areas, such as epidemiology, medicine, and psychology. These examples illustrate the use of graphic displays to give an overview of data, to suggest possible hypotheses for testing new data, and to interpret fitted statistical models. The SAS programs and data sets are available online.

SAS Stored Processes

Download SAS Stored Processes PDF Online Free

Author :
Publisher : Apress
ISBN 13 : 1484259254
Total Pages : 334 pages
Book Rating : 4.4/5 (842 download)

DOWNLOAD NOW!


Book Synopsis SAS Stored Processes by : Philip Mason

Download or read book SAS Stored Processes written by Philip Mason and published by Apress. This book was released on 2020-06-06 with total page 334 pages. Available in PDF, EPUB and Kindle. Book excerpt: Customize the SAS Stored Process web application to create amazing tools for end users. This book shows you how to use stored processes—SAS programs stored on a server and executed as required by requesting applications. Never before have there been so many ways to turn data into information and build applications with SAS. This book teaches you how to use the web technologies that you frequently see used on impressive websites. By using SAS Stored Processes, you will be able to build applications that exploit CSS, JavaScript, and HTML libraries and enable you to build powerful and impressive web applications using SAS as the backend. While this approach is not common with SAS users, some have had amazing results. People who have SAS skills usually do not have web development skills, and those with web development skills usually do not have SAS skills. Some people have both skills but are unaware of how to connect them with the SAS Stored Process web application. This book shows you how to leverage your skills for success. What You Will Learn Know the benefits of stored processesWrite your own tools in SASMake a stored process generate its own HTML menuPass data between stored processesUse stored processes to generate pure JavaScriptUtilize data generated by SASConvert a SAS program into a stored process Who This Book Is For SAS programmers looking to improve their existing programming skills to develop web applications, and programming managers who want to make better use of the SAS software they already license

Advanced SQL with SAS

Download Advanced SQL with SAS PDF Online Free

Author :
Publisher : SAS Institute
ISBN 13 : 1955977895
Total Pages : 463 pages
Book Rating : 4.9/5 (559 download)

DOWNLOAD NOW!


Book Synopsis Advanced SQL with SAS by : Christian FG Schendera

Download or read book Advanced SQL with SAS written by Christian FG Schendera and published by SAS Institute. This book was released on 2022-05-01 with total page 463 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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