Opis: Sharpening Your Advanced SAS Skills - Sunil Gupta

Sharpening Your Advanced SAS(R) Skills presents sophisticated SAS programming techniques, procedures, and tools, such as Proc SQL, hash tables, and SAS Macro programming, for any industry. Drawing on his more than 20 years' experience of SAS programming in the pharmaceutical industry, the author provides a unique approach that empowers both advanced programmers who need a quick refresher and programmers interested in learning new techniques. The book helps you easily search for key points by summarizing and differentiating the syntax between similar SAS statements and options. Each chapter begins with an overview so you can quickly locate the detailed examples and syntax. The basic syntax, expected data, and descriptions are organized in summary tables to facilitate better memory recall. General rules list common points about similar statements or options. Real-world examples of SAS programs and code statements are line numbered with references, such as SAS papers and websites, for more detailed explanations. The text also includes end-of-chapter questions to reinforce your knowledge of the topics and prepare you for the advanced SAS certification exam. In addition, the author's website offers mindmaps and process flowcharts that connect concepts and relationships.Accessing Data Using SQL Introduction Table Access and Retrieval Creating Macro Variables Table Structure Operations Table Content Operations Connecting to Relational Databases SAS Macro Processing Introduction Introduction to SAS Macro Language and Ground Rules Writing Macro Programs to Automate Tasks Accessing Macros from Macro Libraries Creating Macro Variables to Store and Replace Text Referencing Macro Variables to Substitute Text The Art of SAS Macro Testing Section Summary Powerful SAS Macro Quoting Functions Advanced Programming Techniques Introduction Demonstrate the Use of Advanced Table Lookup Techniques Reduce I/O by Controlling the Space Required to Store SAS Datasets Reduce Programming Time by Developing Reusable SAS Programs Perform Effective Benchmarking SORT Procedure Identify Appropriate Applications for Using Indexes and Create Them Compare Techniques to Eliminate Duplicate Data What's New in SAS Version 9.3 Introduction What's New in SAS Procedures What's New in Character and Numeric Functions What's New in ODS Styles and Templates What's New in ODS Statistical Graphics Answers to Chapter Review Questions References and Questions appear at the end of each chapter.

Szczegóły: Sharpening Your Advanced SAS Skills - Sunil Gupta

Tytuł: Sharpening Your Advanced SAS Skills
Autor: Sunil Gupta
Producent: Apple
ISBN: 9781482240375
Rok produkcji: 2015
Ilość stron: 176
Oprawa: Twarda

Recenzje: Sharpening Your Advanced SAS Skills - Sunil Gupta