Base Statistical Analysis System (SAS) – PValue Courses and Training

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

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)

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

Creating a Basic Report

Selecting Variables(The VAR Statement)

Identifying Observations(Using the ID Statement in PROC PRINT)

Identifying Observations (Example: ID Statement)

Identifying Observations (Example: ID and VAR Statement)

Identifying Observations (Selecting Observations)

Identifying Observations (Specifying WHERE Expressions)

Identifying Observations (Using the CONTAINS Operator)

Identifying Observations (Specifying Compound WHERE Expressions)

Identifying Observations (Examples of WHERE Statements)

Identifying Observations (Using System Options to Specify Observations)

Identifying Observations (Examples: FIRSTOBS= and OBS= Options)

Identifying Observations (Using FIRSTOBS= and OBS= for Specific Data Sets)

Identifying Observations (Example: FIRSTOBS= and OBS= as Data Set Options)

Sorting Data(The SORT Procedure)

Sorting Data (Example: PROC SORT)

Generating Column Totals(The SUM Statement)

Generating Column Totals (Creating Subtotals for Variable Groups)

Generating Column Totals (Example: SUM Statement)

Generating Column Totals (Creating a Customized Layout with BY Groups and ID Variables)

Generating Column Totals (Example: ID, BY, and SUM Statements)

Generating Column Totals (Creating Subtotals on Separate Pages)

Generating Column Totals (Example: PAGEBY Statement)

Specifying Titles and Footnotes in Procedure Output(TITLE and FOOTNOTE Statements)

Specifying Titles and Footnotes in Procedure Output (Example: Creating Titles)

Specifying Titles and Footnotes in Procedure Output (Example: Creating Footnotes)

Specifying Titles and Footnotes in Procedure Output (Modifying and Canceling Titles and Footnotes)

Assigning Descriptive Labels (Temporarily Assigning Labels to Variables)

Assigning Descriptive Labels (Example: Using the LABEL Option in the PROC PRINT Statement)

Assigning Descriptive Labels (Example: Using Multiple LABEL Statements)

Assigning Descriptive Labels (Example: Using a Single LABEL Statement to Assign Multiple Labels)

Using Permanently Assigned Labels

Quiz

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

Definitions

Preprocessing Data(Determine Whether the Data Requires Preprocessing)

Preprocessing Data (Example: Sorting Observations for BY-Group Processing)

FIRST. and LAST. DATA Step Variables(How the DATA Step Identifies BY Groups)

FIRST. and LAST. DATA Step Variables (How SAS Determines FIRST.variable and LAST.variable)

FIRST. and LAST. DATA Step Variables (Example: Grouping Observations Using One BY Variable)

FIRST. and LAST. DATA Step Variables (Example: Grouping Observations Using Multiple BY Variables)

Quiz

Chapter 9: Creating and Managing Variables

Creating Variables(Assignment Statements)

Creating Variables (SAS Expressions)

Creating Variables (Using Operators in SAS Expressions)

Creating Variables (Examples: Assign Variables)

Creating Variables (Date Constants)

Creating Variables (Example: Assignment Statements and Date Values)

Modifying Variables(Selected Useful Statements)

Modifying Variables (Accumulating Totals)

Modifying Variables (Example: Accumulating Totals)

Modifying Variables (Initializing Sum Variables)

Modifying Variables (Example: RETAIN Statement)

Specifying Lengths for Variables(Avoiding Truncated Variable Values)

Specifying Lengths for Variables (Example: LENGTH Statement)

Subsetting Data(Using a Subsetting IF Statement)

Subsetting Data (Example: Subsetting IF Statement)

Subsetting Data (Categorizing Values)

Subsetting Data (Example: IF-THEN Statement)

Subsetting Data (Examples: Logical Operators)

Subsetting Data (Providing an Alternative Action)

Subsetting Data (Deleting Unwanted Observations)

Subsetting Data( Example: IF-THEN and DELETE Statements)

Subsetting Data (Selecting Variables)

Subsetting Data (Example: DROP Data Set Option)

Subsetting Data (Example: Using the DROP Statement)

Transposing Variables into Observations(The TRANSPOSE Procedure)

Transposing Variables into Observations (PROC TRANSPOSE Results)

Transposing Variables into Observations (Example: Performing a Simple Transposition)

Transposing Variables into Observations (Transposing Specific Variables)

Transposing Variables into Observations (Naming Transposed Variables)

Transposing Variables into Observations (Transposing BY Groups)

Using SAS Macro Variables (%LET Statement)

Using SAS Macro Variables (Example: Using SAS Macro Variables with Numeric Values)

Using SAS Macro Variables (Example: Using SAS Macro Variables with Character Values)

Using SAS Macro Variables (Example: Using Macro Variables in TITLE Statements)

Quiz

Chapter 10: Combining SAS Data Sets

How to Prepare Your Data Sets (Determining the Structure and Contents of Data Sets )

How to Prepare Your Data Sets (Testing Your Program )

How to Prepare Your Data Sets (Looking at Sources of Common Problems )

Methods of Combining SAS Data Sets: The Basics

One-to-One Reading: Details ( One-to-One Reading Syntax )

One-to-One Reading: Details ( How One-to-One Reading Selects Data )

One-to-One Reading: Details ( How One-to-One Reading Works )

Example: Using One-to-One Reading to Combine Data Sets

Concatenating: Details (Concatenating Syntax )

Concatenating: Details (How Concatenating Selects Data )

Example: Using Concatenating to Combine Data Sets

Match-Merging: Details (Match-Merging Syntax )

Match-Merging: Details (How Match-Merging Selects Data )

Example: Using Match-Merging to Combine Data Sets

Example: Merge in Descending Order

Match-Merge Processing (The Basics of Match-Merge Processing )

Match-Merge Processing (The Compilation Phase: Setting Up a New Data Set )

Match-Merge Processing (The Execution Phase: Match-Merging Observation )

Match-Merge Processing (Handling Unmatched Observations and Missing Values)

Renaming Variables (The Basics of Renaming Variables )

Renaming Variables(RENAME Statement Syntax )

Example: Renaming Variables

Excluding Unmatched Observations (Overview)

Excluding Unmatched Observations(Identifying Observation in Both Data Sets)

Excluding Unmatched Observations (Selecting Matching Observations )

Quiz

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

The Basics of SAS Functions( Definition)

The Basics of SAS Functions( Uses of SAS Functions)

The Basics of SAS Functions( SAS Functions Categories)

SAS Functions Syntax (Arguments and Variable Lists )

Example: Multiple Arguments

SAS Functions Syntax (Target Variables)

Converting Data with Functions (A Word about Converting Data)

Converting Data with Functions (Potential Problems of Omitting INPUT or PUT)

Converting Data with Functions (Automatic Character-to-Numeric Conversion)

Converting Data with Functions (When Automatic Conversion Occurs)

Converting Data with Functions (A Word about Converting DataRestriction for WHERE Expressions )

Converting Data with Functions (Explicit Character-to-Numeric Conversion)

Example: INPUT Function

Converting Data with Functions (Automatic Numeric-to-Character Conversion)

Converting Data with Functions (Explicit Numeric-to-Character Conversion)

Manipulating SAS Date Values with Functions (SAS Date Functions)

Manipulating SAS Date Values with Functions(YEAR, QTR, MONTH, and DAY Functions)

Example: Finding the Year and Month

Example: Finding the Year

WEEKDAY Function( Overview of the WEEKDAY Function)

Example: WEEKDAY Function

MDY Function( Overview of the MDY Function)

Example: MDY Function

Example: Finding the Date

DATE and TODAY Functions (Overview of the DATE Function )

DATE and TODAY Functions (Overview of the TODAY Function )

Example: The DATE and TODAY Functions

INTCK Function (Overview of the INTCK Function )

INTCK Function (Details )

Examples: INTCK Function

Example: The INTCK Function and Periodic Events

INTNX Function (Overview of the INTNX Function )

INTNX Function (Details)

Example: INTNX Function

DATDIF and YRDIF Functions

Modifying Character Values with Functions (SCAN Function)

Modifying Character Values with Functions (Details)

Example: Create New Name Variables

Specifying Delimiters

Modifying Character Values with Functions (Specifying Multiple Delimiters )

Modifying Character Values with Functions (Default Delimiters)

Modifying Character Values with Functions (Specifying Variable Length)

SUBSTR Function (Overview of the SUBSTR Function)

Example: SUBSTR Function

SUBSTR Function(Replacing Text Using SUBSTR)

SUBSTR Function(Positioning the SUBSTR Function)

SCAN versus SUBSTR Functions

LEFT and RIGHT Functions (Overview of the LEFT and RIGHT Functions )

Example: LEFT Function

Example: RIGHT Function

Concatenation Operator

TRIM Function (Overview of the TRIM Function )

Example: TRIM Function

CATX Function (Overview of the CATX Function )

Example: Create New Variable Using CATX Function

INDEX Function (Overview of the INDEX Function )

Example: Search for Occurrences of a Phrase

Finding a String Regardless of Case

FIND Function( Overview of the FIND Function)

FIND Function( Details)

Example: Find Word Processing Jobs in a Data Set

UPCASE Function

LOWCASE Function

PROPCASE Function

TRANWRD Function( Overview of the TRANWRD Function)

Example: Update Variables in Place Using TRANWRD Function

COMPBL Function

COMPRESS Function( Overview of the COMPRESS Function )

Example: Compress a Character String

Example: Compress a Character String Using a Modifier

Modifying Numeric Values with Functions

Modifying Numeric Values with Functions(CEIL and FLOOR Functions )

INT Function

ROUND Function

Nesting SAS Functions

quiz

Chapter 15: Producing Descriptive Statistics

The MEANS Procedure(What Does the MEANS Procedure Do?)

The MEANS Procedure (MEANS Procedure Syntax)

The MEANS Procedure (Example: Default PROC MEANS Output)

The MEANS Procedure (Specifying Descriptive Statistics Keywords)

The MEANS Procedure (Example: Specifying Statistic Keywords)

The MEANS Procedure (Limiting Decimal Places with MAXDEC= Option)

The MEANS Procedure (Specifying Variables Using the VAR Statement)

The MEANS Procedure (Group Processing Using the CLASS Statement)

The MEANS Procedure (Group Processing Using the BY Statement)

The MEANS Procedure (Creating a Summarized Data Set Using the OUTPUT Statement)

The FREQ Procedure(What Does the FREQ Procedure Do?)

The FREQ Procedure (FREQ Procedure Syntax)

The FREQ Procedure (Example: Creating a One-Way Frequency Table (Default)

The FREQ Procedure (Specifying Variables Using the TABLES Statement)

The FREQ Procedure (Example: Creating a One-Way Table for One Variable)

The FREQ Procedure (Example: Determining the Report Layout)

The FREQ Procedure (Create Two-Way and N-Way Tables)

The FREQ Procedure (Example: Creating Two-Way Tables)

The FREQ Procedure (Examples: Creating N-Way Tables)

The FREQ Procedure (Creating Tables Using the LIST Option)

The FREQ Procedure (Example: Using the LIST Option)

The FREQ Procedure (Example: Using the CROSSLIST Option)

The FREQ Procedure (Suppressing Table Information)

The FREQ Procedure (Example: Suppressing Percentages)

Quiz

Chapter 16: Creating Output

The Output Delivery System (ODS)(Overview of ODS)

The Output Delivery System (ODS) (Opening and Closing ODS Destinations)

The Output Delivery System (ODS) (Using Statements to Open and Close ODS Destinations)

Creating HTML Output with ODS (The ODS HTML Statement)

Creating HTML Output with ODS (Example: Creating Output with PROC PRINT)

Creating HTML Output with ODS (Creating HTML Output with a Table of Contents)

Creating HTML Output with ODS (Using Options to Specify Links and Paths)

Creating HTML Output with ODS (Changing the Appearance of HTML Output)

Creating PDF Output with ODS(The ODS PDF Statement)

Creating PDF Output with ODS (The ODS Printer Family of Statements)

Creating PDF Output with ODS (Opening and Closing the PDF Destination)

Creating PDF Output with ODS (Working with the Table of Contents)

Creating PDF Output with ODS (Example: Creating PDF Output Using the FILE= Option)

Creating PDF Output with ODS (Example: Creating a Printable Table of Contents)

Creating PDF Output with ODS (Changing the Appearance of PDF Output)

Creating RTF Output with ODS (The ODS RTF Statement)

Creating RTF Output with ODS (Opening and Closing the RTF Destination)

Creating RTF Output with ODS (Understanding How RTF Formats Output)

Creating RTF Output with ODS (ODS RTF and Graphics )

Example: Using the STYLE= Option (FestivalPrinter Style)

Creating EXCEL Output with ODS( The ODS EXCEL Statement )

Creating EXCEL Output with ODS( Details about the Excel ODS Destination )

Example: Customizing Your Excel Output

The EXPORT Procedure (The Basics of PROC EXPORT )

The EXPORT Procedure (PROC EXPORT Syntax )

Example: Exporting a Subset of Observation to a CSV File

Chapter Quiz

About the instructor

PValue Solutions

0 (0 ratings)

3 Courses

23 students

Base-SAS-Certification-Preparatory-Course

Free

Login

Remember Me

Forgot Password?

Create a new account