Intro; Contents; How to Prepare for the SAS Base Programming for SAS®9 Exam; Requirements and Details; Requirements; Exam Objectives and Updates to This Book; Take a Practice Exam; Registering for the Exam; Additional Resources for Learning SAS Programming; Syntax Conventions; Accessibility Features of the SAS Certification Prep Guide; Overview; Accessibility Documentation Help; Documentation Format; Setting Up Practice Data; Accessing Your Practice Data; Requirements; Practice Data ZIP File; Instructions; Basic Concepts; Getting Started; The Basics of the SAS Language; SAS Statements.
Text of Note
Extended AttributesChapter Quiz; Accessing Your Data; SAS Libraries; Assigning Librefs; Verifying Librefs; How Long Librefs Remain in Effect; Specifying Two-Level Names; Referencing Third-Party Data; Accessing Stored Data; Viewing SAS Libraries; Viewing Libraries; Viewing Libraries Using PROC CONTENTS; Example: View the Contents of an Entire Library; Example: View Descriptor Information; Example: View Descriptor Information Using the Varnum Option; Chapter Quiz; Creating SAS Data Sets; Referencing an External Data File; Using a FILENAME Statement; Defining a Fully Qualified Filename.
Text of Note
Global StatementsDATA Step; PROC Step; SAS Program Structure; Processing SAS Programs; Log Messages; Results of Processing; SAS Libraries; Definition; Predefined SAS Libraries; Defining Libraries; How SAS Files Are Stored; Storing Files Temporarily or Permanently; Referencing SAS Files; Referencing Permanent SAS Data Sets; Referencing Temporary SAS Files; Rules for SAS Names; VALIDVARNAME=System Option; VALIDMEMNAME=System Option; When to Use VALIDMEMNAME=System Option; SAS Data Sets; Overview of Data Sets; Descriptor Portion; SAS Variable Attributes; Data Portion; SAS Indexes.
Text of Note
Naming the Data Set with the DATA StatementSpecifying the Imported Data with the SET Statement; Reading a Single SAS Data Set to Create Another; Example: Reading a SAS Data Set; Specifying DROP= and KEEP= Data Set Options; Reading Microsoft Excel Data with the XLSX Engine; Running SAS with Microsoft Excel; Steps for Reading Excel Data; The LIBNAME Statement; Referencing an Excel Workbook; Referencing an Excel Workbook in a DATA Step; Printing an Excel Worksheet as a SAS Data Set; Creating Excel Worksheets; Writing Observations Explicitly; Chapter Quiz.
Text of Note
Referencing a Fully Qualified FilenameThe IMPORT Procedure; The Basics of PROC IMPORT; PROC IMPORT Syntax; Example: Importing an Excel File with an XLSX Extension; Example: Importing a Delimited File with a TXT Extension; Example: Importing a Space-Delimited File with a TXT Extension; Example: Importing a Comma-Delimited File with a CSV Extension; Example: Importing a Tab-Delimited File; Reading and Verifying Data; Verifying the Code That Reads the Data; Checking DATA Step Processing; Printing the Data Set; Reading the Entire External File; Using the Imported Data in a DATA Step.
0
8
8
8
8
SUMMARY OR ABSTRACT
Text of Note
Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the SAS Global Certification Program. New and experienced SAS users who want to prepare for the SAS Base Programming for SAS 9 exam will find this guide to be a valuable resource that covers all of the objectives tested on the exam. Now in its fifth edition, the guide has been extensively updated and revised to streamline explanations. Major topics include importing data, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors. The chapter quizzes have been thoro.
OTHER EDITION IN ANOTHER MEDIUM
Title
SAS Certification Prep Guide : Base Programming for SAS9, Fifth Edition.