Inputs & Outputs

SAS 9
  • 13 Videos | 57m 40s
  • Includes Assessment
  • Earns a Badge
Likes 10
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 16s
    UP NEXT
  • Playable
    2. 
    Writing to Multiple SAS Data Sets
    5m 53s
  • Locked
    3. 
    Controlling Variable Input and Output
    4m 56s
    FREE ACCESS
  • Locked
    4. 
    Controlling Observation Input and Output
    5m 54s
    FREE ACCESS
  • Locked
    5. 
    Creating an Accumulating Variable Using RETAIN
    2m 52s
    FREE ACCESS
  • Locked
    6. 
    Creating an Accumulating Variable Using SUM
    3m 21s
    FREE ACCESS
  • Locked
    7. 
    Summarizing Data by Groups
    5m 2s
    FREE ACCESS
  • Locked
    8. 
    Summarizing Data by Multiple Groups
    2m 57s
    FREE ACCESS
  • Locked
    9. 
    Using Column Input
    2m 55s
    FREE ACCESS
  • Locked
    10. 
    Using Formatted Input
    5m 48s
    FREE ACCESS
  • Locked
    11. 
    Creating a Single Observation from Multiple Records
    5m 6s
    FREE ACCESS
  • Locked
    12. 
    Controlling When a Record Loads
    4m 57s
    FREE ACCESS
  • Locked
    13. 
    Reading Raw Data with Missing Values
    3m 43s
    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 Final Exam: Working with Datasets in R
Likes  0
COURSE Creating Reports
Likes  12
COURSE Design & Install Analysis Services
Likes  11

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Arrays & Restructuring and Merging Data Sets
Likes  10
COURSE Data Manipulation & Debugging
Likes  8
COURSE Creating & Reading Data Sets
Likes  25