Inputs & Outputs

SAS 9    |    Beginner
  • 13 Videos | 1h 3m 31s
  • Includes Assessment
  • Earns a Badge
Likes 12 Likes 12
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

  • Playable
    1. 
    Outputting Multiple Observations
    4m 13s
    UP NEXT
  • Playable
    2. 
    Writing to Multiple SAS Data Sets
    5m 50s
  • Locked
    3. 
    Controlling Variable Input and Output
    4m 53s
    FREE ACCESS
  • Locked
    4. 
    Controlling Observation Input and Output
    5m 51s
    FREE ACCESS
  • Locked
    5. 
    Creating an Accumulating Variable Using RETAIN
    2m 49s
    FREE ACCESS
  • Locked
    6. 
    Creating an Accumulating Variable Using SUM
    3m 18s
    FREE ACCESS
  • Locked
    7. 
    Summarizing Data by Groups
    4m 59s
    FREE ACCESS
  • Locked
    8. 
    Summarizing Data by Multiple Groups
    2m 54s
    FREE ACCESS
  • Locked
    9. 
    Using Column Input
    2m 52s
    FREE ACCESS
  • Locked
    10. 
    Using Formatted Input
    5m 45s
    FREE ACCESS
  • Locked
    11. 
    Creating a Single Observation from Multiple Records
    5m 3s
    FREE ACCESS
  • Locked
    12. 
    Controlling When a Record Loads
    4m 54s
    FREE ACCESS
  • Locked
    13. 
    Reading Raw Data with Missing Values
    3m 40s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE The SAS Environment
Likes 69 Likes 69  
CHANNEL Computer Tools
Likes 1 Likes 1  
COURSE Data Errors & Validation
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Manipulation
Likes 19 Likes 19  
COURSE Introduction to Data Sets
Likes 36 Likes 36