Base Statistical Analysis System (SAS)

PS

by PValue Solutions
Course level: All Levels
Share: Share:

Categories Data Science
Total Enrolled 2
Last Update June 22, 2021

Description

Setting Up Practice Data

Topics for this course

367 Lessons

Chapter 1: Setting Up Practice Data

Accessing Your Practice Data (Requirements)

Accessing Your Practice Data (Practice Data ZIP File)

Accessing Your Practice Data (Instructions)

Chapter 2: Basic Concepts

Chapter 3: Accessing Your Data

SAS Libraries

SAS Libraries(Assigning Librefs)

SAS Libraries(Verifying Librefs)

SAS Libraries(How Long Librefs Remain in Effect)

SAS Libraries(Specifying Two-Level Names)

SAS Libraries(Referencing Third-Party Data)

SAS Libraries(Accessing Stored Data)

Viewing SAS Libraries(Viewing Libraries)

Viewing SAS Libraries(Viewing Libraries Using PROC CONTENTS)

Viewing SAS Libraries (Example: View the Contents of an Entire Library)

Viewing SAS Libraries (Example: View Descriptor Information)

Viewing SAS Libraries (Example: View Descriptor Information Using the Varnum Option)

Quiz

Chapter 4: Creating SAS Data Sets

Referencing an External Data File (Using a FILENAME Statement)

Referencing an External Data File (Defining a Fully Qualified Filename)

Referencing an External Data File (Referencing a Fully Qualified Filename)

The IMPORT Procedure (The Basics of PROC IMPORT)

The IMPORT Procedure (PROC IMPORT Syntax)

The IMPORT Procedure (Example: Importing an Excel File with an XLSX Extension)

The IMPORT Procedure (Example: Importing a Delimited File with a TXT Extension)

The IMPORT Procedure (Example: Importing a Space-Delimited File with a TXT Extension)

The IMPORT Procedure (Example: Importing a Comma-Delimited File with a CSV Extension)

The IMPORT Procedure (Example: Importing a Tab-Delimited File)

Reading and Verifying Data(Verifying the Code That Reads the Data)

Reading and Verifying Data (Checking DATA Step Processing)

Reading and Verifying Data (Printing the Data Set)

Reading and Verifying Data (Reading the Entire External File)

Using the Imported Data in a DATA Step(Naming the Data Set with the DATA Statement)

Using the Imported Data in a DATA Step (Specifying the Imported Data with the SET Statement)

Reading a Single SAS Data Set to Create Another (Example: Reading a SAS Data Set)

Reading a Single SAS Data Set to Create Another (Specifying DROP= and KEEP= Data Set Options)

Reading Microsoft Excel Data with the XLSX Engine (Running SAS with Microsoft Excel)

Reading Microsoft Excel Data with the XLSX Engine (Steps for Reading Excel Data)

Reading Microsoft Excel Data with the XLSX Engine (The LIBNAME Statement)

Reading Microsoft Excel Data with the XLSX Engine (Referencing an Excel Workbook)

Reading Microsoft Excel Data with the XLSX Engine (Referencing an Excel Workbook in a DATA Step)

Reading Microsoft Excel Data with the XLSX Engine (Printing an Excel Worksheet as a SAS Data Set)

Creating Excel Worksheets

Writing Observations Explicitly

Quiz

Chapter 5: Identifying and Correcting SAS Language Errors

Error Messages(Types of Errors)

Error Messages(Syntax Errors)

Example: Syntax Error Messages

Correcting Common Errors(The Basics of Error Correction)

Correcting Common Errors (Resubmitting a Revised Program )

The Basics of Logic Errors(The PUTLOG Statement)

The Basics of Logic Errors(Temporary Variables)

Example: The DATA Step Produces Wrong Results but There Are No Error Messages

PUT Statement(Syntax)

Example: Using the PUT Statement

Example: Character Strings

Example: Data Set Variables

Example: Conditional Processing

Missing RUN Statement

Missing Semicolon

Missing Semicolon(Correcting the Error)

Missing Semicolon (Unbalanced Quotation Marks)

Missing Semicolon (Correcting the Error in the Windows Operating Environment)

Missing Semicolon (Correcting the Error in the UNIX Environment )

Correcting the Error in the z/OS Operating Environment

Semantic Error: Invalid Option

Correcting the Error: Invalid Option

Select the best answer for each question. Check your answers using the answer key in the appendix.

Chapter 6: Creating Reports

Chapter 7: Understanding DATA Step Processing

How SAS Processes Programs

Compilation Phase(Program Data Vector (PDV))

Compilation Phase(Syntax Checking)

Compilation Phase(Data Set Variables)

Compilation Phase(Descriptor Portion of the SAS Data Set)

Execution Phase(Initializing Variables )

Execution Phase(SET Statement)

Execution Phase(Sequentially Process Statements)

Execution Phase(End of the DATA Step)

Execution Phase(Iterations of the DATA Step )

Execution Phase(End-of-File Marker )

End of the Execution Phase

Debugging a DATA Step(Diagnosing Errors in the Compilation Phase)

Debugging a DATA Step(Diagnosing Errors in the Execution Phase)

Debugging a DATA Step(Debugging Data Errors )

Debugging a DATA Step(Using an Assignment Statement to Clean Invalid Data)

Testing Your Programs(Limiting Observations)

Example: Viewing Execution in the SAS Log

Chapter 7: Quiz

Chapter 8: BY-Group Processing

Chapter 9: Creating and Managing Variables

Chapter 10: Combining SAS Data Sets

Chapter 11: Processing Data with DO Loops

The Basics of DO Loops(The Basics of Using Grouping Statements and DO Groups)

The Basics of DO Loops (Example: DO and END Statements)

The Basics of DO Loops (DO Statement, Iterative Syntax)

The Basics of DO Loops (Example: Processing Iterative DO Loops)

Constructing DO Loops(DO Loop Execution)

Constructing DO Loops (Using Explicit OUTPUT Statements)

Constructing DO Loops (Decrementing DO Loops)

Constructing DO Loops (Specifying a Series of Items)

Nesting DO Loops (Indenting and Nesting DO Groups)

Nesting DO Loops (Examples: Nesting DO Loops)

Iteratively Processing Observations from a Data Set

Conditionally Executing DO Loops(Overview)

Conditionally Executing DO Loops (Using the DO UNTIL Statement)

Conditionally Executing DO Loops (Using the DO WHILE Statement)

Quiz

Chapter 12 : SAS Formats and Informats

Applying SAS Formats and Informats (Temporarily Assigning Formats to Variables)

Applying SAS Formats and Informats (Specifying SAS Formats)

Applying SAS Formats and Informats (Field Widths)

Applying SAS Formats and Informats (Decimal Places)

Examples: Data Values and Formats

The FORMAT Procedure( Definitions)

The FORMAT Procedure( A Word about PROC FORMAT )

The FORMAT Procedure( The PROC FORMAT Statement)

The FORMAT Procedure( Permanently Storing Your Formats)

Defining a Unique Format (The VALUE Statement)

Defining a Unique Format (Specifying Value Ranges)

Associating User-Defined Formats with Variables( How SAS Finds Format Catalogs)

Associating User-Defined Formats with Variables( Assigning Formats to Variables )

Associating User-Defined Formats with Variables(Displaying User-Defined Formats )

Quiz

Chapter 13: SAS Date, Time, and Datetime Values

SAS Date and Time Values(Definitions)

SAS Date and Time Values (Example: Date and Time Values)

Reading Dates and Times with Informats(Overview)

Reading Dates and Times with Informats (The MMDDYYw. Informat)

Reading Dates and Times with Informats (Example: Reading Dates with Formats and Informats)

Reading Dates and Times with Informats (The DATEw. Informat)

Reading Dates and Times with Informats (The TIMEw. Informat)

Reading Dates and Times with Informats (The DATETIMEw. Informat)

Example: Using Dates and Times in Calculations

Displaying Date and Time Values with Formats(The WEEKDATEw. Format)

Displaying Date and Time Values with Formats (The WORDDATEw. Format)

Quiz

Chapter 14: Using Functions to Manipulate Data

Chapter 15: Producing Descriptive Statistics

Chapter 16: Creating Output

About the instructor

PValue Solutions

0 (0 ratings)

2 Courses

2 students

Base-SAS-Certification-Preparatory-Course

Free

Description

Topics for this course

Chapter 1: Setting Up Practice Data

Accessing Your Practice Data (Requirements)

Accessing Your Practice Data (Practice Data ZIP File)

Accessing Your Practice Data (Instructions)

Chapter 2: Basic Concepts

Getting Started

The Basics of the SAS Language (SAS Statements)

The Basics of the SAS Language (Global Statements)

The Basics of the SAS Language (DATA Step)

The Basics of the SAS Language ( PROC Step)

The Basics of the SAS Language (SAS Program Structure)

The Basics of the SAS Language(Processing SAS Programs)

The Basics of the SAS Language(Log Messages)

The Basics of the SAS Language(Results of Processing)

SAS Libraries (Definition)

SAS Libraries(Predefined SAS Libraries)

SAS Libraries(Defining Libraries)

SAS Libraries(How SAS Files Are Stored)

SAS Libraries(Storing Files Temporarily or Permanently)

Referencing SAS Files( Referencing Permanent SAS Data Sets)

Referencing SAS Files(Referencing Temporary SAS Files)

Referencing SAS Files(Rules for SAS Names)

Referencing SAS Files(VALIDVARNAME=System Option)

Referencing SAS Files(VALIDMEMNAME=System Option)

SAS Data Sets(Overview of Data Sets)

SAS Data Sets(Descriptor Portion)

SAS Data Sets(SAS Variable Attributes)

SAS Data Sets((Data Portion)

SAS Data Sets(Extended Attributes)

Select the best answer for each question. Check your answers using the answer key in the appendix

Chapter 3: Accessing Your Data

SAS Libraries

SAS Libraries(Assigning Librefs)

SAS Libraries(Verifying Librefs)

SAS Libraries(How Long Librefs Remain in Effect)

SAS Libraries(Specifying Two-Level Names)

SAS Libraries(Referencing Third-Party Data)

SAS Libraries(Accessing Stored Data)

Viewing SAS Libraries(Viewing Libraries)

Viewing SAS Libraries(Viewing Libraries Using PROC CONTENTS)

Viewing SAS Libraries (Example: View the Contents of an Entire Library)

Viewing SAS Libraries (Example: View Descriptor Information)

Viewing SAS Libraries (Example: View Descriptor Information Using the Varnum Option)

Quiz

Chapter 4: Creating SAS Data Sets

Referencing an External Data File (Using a FILENAME Statement)

Referencing an External Data File (Defining a Fully Qualified Filename)

Referencing an External Data File (Referencing a Fully Qualified Filename)

The IMPORT Procedure (The Basics of PROC IMPORT)

The IMPORT Procedure (PROC IMPORT Syntax)

The IMPORT Procedure (Example: Importing an Excel File with an XLSX Extension)

The IMPORT Procedure (Example: Importing a Delimited File with a TXT Extension)

The IMPORT Procedure (Example: Importing a Space-Delimited File with a TXT Extension)

The IMPORT Procedure (Example: Importing a Comma-Delimited File with a CSV Extension)

The IMPORT Procedure (Example: Importing a Tab-Delimited File)

Reading and Verifying Data(Verifying the Code That Reads the Data)

Reading and Verifying Data (Checking DATA Step Processing)

Reading and Verifying Data (Printing the Data Set)

Reading and Verifying Data (Reading the Entire External File)

Using the Imported Data in a DATA Step(Naming the Data Set with the DATA Statement)

Using the Imported Data in a DATA Step (Specifying the Imported Data with the SET Statement)

Reading a Single SAS Data Set to Create Another (Example: Reading a SAS Data Set)

Reading a Single SAS Data Set to Create Another (Specifying DROP= and KEEP= Data Set Options)

Reading Microsoft Excel Data with the XLSX Engine (Running SAS with Microsoft Excel)

Reading Microsoft Excel Data with the XLSX Engine (Steps for Reading Excel Data)

Reading Microsoft Excel Data with the XLSX Engine (The LIBNAME Statement)

Reading Microsoft Excel Data with the XLSX Engine (Referencing an Excel Workbook)

Reading Microsoft Excel Data with the XLSX Engine (Referencing an Excel Workbook in a DATA Step)

Reading Microsoft Excel Data with the XLSX Engine (Printing an Excel Worksheet as a SAS Data Set)

Creating Excel Worksheets

Writing Observations Explicitly

Quiz

Chapter 5: Identifying and Correcting SAS Language Errors

Error Messages(Types of Errors)

Error Messages(Syntax Errors)

Example: Syntax Error Messages

Correcting Common Errors(The Basics of Error Correction)