Course Details

Previous Page


Base SAS 9 Programming: Inputs and Outputs


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Effectively getting data into and out of SAS is key for a SAS programmer. Data will come in a variety of formats, and different output formats will be required. This course covers inputs and outputs from the SAS system. It also covers various functions for data transformation, and some methods for debugging your programs. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.

Target Audience
Learners interested in programmatically working with data in SAS systems.

Prerequisites
None.

Expected Duration (hours)
2.1

Lesson Objectives

Base SAS 9 Programming: Inputs and Outputs

  • start the course
  • 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
  • using the MISSOVER and DSD options to control behavior with missing values in raw data in SAS
  • use various SAS functions to perform transforms or calculations on variables
  • use SAS functions to extract and transform character values, including SUBSTR, LEFT, RIGHT, CHAR, PROPCASE and LENGTH
  • create pie charts using the SAS/GRAPH Statistical Graphics Procedures
  • use SAS functions to find and modify character values, including FIND, SUBSTR, COMPRESS and TRAINED
  • use descriptive SAS statistical functions, such as SUM, MIN, MAX and MEAN
  • truncate numerical SAS values by using the ROUND, INT, FLOOR, and CEIL functions
  • convert between SAS data types using INPUT and PUT functions
  • debug SAS programs using the PUTLOG statement
  • debug logic errors in SAS programs
  • create a program that manipulates input data
  • Course Number:
    df_sapo_a05_it_enus