Inputs & Outputs

SAS 9    |    Beginner
  • 13 videos | 57m 1s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 30 users Rating 4.5 of 30 users (30)
Effectively getting data into and out of SAS is key for a SAS programmer, and data will come in a variety of formats. Explore inputs and outputs from the SAS system.

WHAT YOU WILL LEARN

  • Control when sas writes an observation to a data set using an output statement
    Write to more than one sas data set
    Control sas variable input and output with drop and keep
    Control sas observation input and output with obs and firstobs
    Use the retain statement to create an accumulating variable in sas
    Use the sum statement to create an accumulating variable in sas
    Summarize data by groups using by-group processing in sas
  • Summarize data by multiple groups using by-group processing in sas
    Use column input to read input data that is arranged in columns or fixed fields in sas
    Use formatted input to read both standard and nonstandard data that is arranged in fixed fields in sas
    Use multiple input statements to read a group of records in a raw data file as a single observation in a new data set in sas
    Use a line-hold specifier to prevent the second input statement in a data step from moving to the second line in a raw data file in sas
    Use the missover and dsd options to control behavior with missing values in raw data in sas

IN THIS COURSE

  • 4m 13s
    Learn how to control when SAS writes an observation to a data set using an OUTPUT statement. FREE ACCESS
  • 5m 50s
    During this video, you will learn how to write to more than one SAS dataset. FREE ACCESS
  • Locked
    3.  Controlling Variable Input and Output
    4m 53s
    In this video, you will learn how to control which SAS variables are input and output with DROP and KEEP. FREE ACCESS
  • Locked
    4.  Controlling Observation Input and Output
    5m 51s
    In this video, you will learn how to control SAS observation input and output with OBS and FIRSTOBS. FREE ACCESS
  • Locked
    5.  Creating an Accumulating Variable Using RETAIN
    2m 49s
    During this video, you will learn how to use the RETAIN statement to create an accumulating variable in SAS. FREE ACCESS
  • Locked
    6.  Creating an Accumulating Variable Using SUM
    3m 18s
    In this video, you will learn how to use the SUM statement to create an accumulating variable in SAS. FREE ACCESS
  • Locked
    7.  Summarizing Data by Groups
    4m 59s
    In this video, learn how to summarize data by groups using BY-Group processing in SAS. FREE ACCESS
  • Locked
    8.  Summarizing Data by Multiple Groups
    2m 54s
    In this video, learn how to summarize data by multiple groups using BY-Group processing in SAS. FREE ACCESS
  • Locked
    9.  Using Column Input
    2m 52s
    In this video, learn how to use column input to read input data that is arranged in columns or fixed fields. FREE ACCESS
  • Locked
    10.  Using Formatted Input
    5m 45s
    In this video, you will learn how to use formatted input to read both standard and nonstandard data that is arranged in fixed fields. FREE ACCESS
  • Locked
    11.  Creating a Single Observation from Multiple Records
    5m 3s
    In this video, you will learn how to use multiple INPUT statements to read a group of records in a raw data file as a single observation in a new data set in SAS. FREE ACCESS
  • Locked
    12.  Controlling When a Record Loads
    4m 54s
    In this video, learn how to use a line-hold specifier to prevent the second INPUT statement in a DATA step from moving to the second line in a raw data file. FREE ACCESS
  • Locked
    13.  Reading Raw Data with Missing Values
    3m 40s
    During this video, you will learn how to use the MISSOVER and DSD options to control behavior with missing values in raw data in SAS. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Data and Analytics at Work
Rating 2.0 of 1 users Rating 2.0 of 1 users (1)
Journey Introduction to Computer Architecture
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Visual Data Insights Using SAS ODS Graphics: A Guide to Communication-Effective Data Visualization

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course The SAS Environment
Rating 4.3 of 117 users Rating 4.3 of 117 users (117)
Course Data Manipulation with SAS
Rating 4.3 of 38 users Rating 4.3 of 38 users (38)
Course Microsoft 365 Fundamentals: Mobile Management & Security and Compliance
Rating 4.6 of 405 users Rating 4.6 of 405 users (405)