Creating & Reading Data Sets

SAS 9    |    Beginner
  • 13 videos | 1h 2m
  • Earns a Badge
Likes 29 Likes 29
Before SAS software can process data, such as data saved in an Excel worksheet, it must be in the form of a SAS data set. Discover how to create data sets from various sources.

WHAT YOU WILL LEARN

  • create a data set from an Excel sheet using the PROC step in SAS
    read from an Excel sheet using the libname statement
    use the PROC step to create an Excel sheet in SAS
    use the ODS to create an Excel sheet in SAS
    use the IMPORT wizard to import data from an Excel sheet in SAS
    use the EXPORT wizard to write to an Excel Sheet in SAS
    create a data set from a delimited raw data file using the DATA step in SAS
  • use the LENGTH statement to define the length of a variable in SAS
    read nonstandard data in SAS using informants
    use additional SAS statements to process nonstandard data in the DATA step
    read consecutive delimiters as missing values using the DSD option in SAS
    recognize missing data at the end of a record with the MISSOVER option
    read data from a variety of sources in SAS

IN THIS COURSE

  • 5m 1s
  • 5m 16s
  • Locked
    3.  Using the PROC Step to Create an Excel Sheet
    2m 33s
  • Locked
    4.  Using the ODS to Create an Excel Sheet
    3m 9s
  • Locked
    5.  Using the IMPORT Wizard with Excel
    3m 9s
  • Locked
    6.  Using the EXPORT Wizard with Excel
    1m 58s
  • Locked
    7.  Creating a Data Set from a Delimited File
    4m 10s
  • Locked
    8.  Using the LENGTH Statement
    5m 3s
  • Locked
    9.  Reading Nonstandard Data with Informants
    6m 28s
  • Locked
    10.  Processing Nonstandard Data in the DATA Step
    5m 4s
  • Locked
    11.  Using the List Input DSD Option
    5m 15s
  • Locked
    12.  Using the MISSOVER Option
    6m 1s
  • Locked
    13.  Exercise: Read Data
    8m 52s

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

Book Learn Data Science Using SAS Studio: A Quick-Start Guide
Channel SAS(r) Certified Base Programmer
Likes 158 Likes 158  
Course Formatting cells and ranges in Excel 365
Likes 5 Likes 5  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Arrays & Restructuring and Merging Data Sets
Likes 20 Likes 20  
Course Data Manipulation & Debugging
Likes 15 Likes 15  
Course Introduction to Data Sets
Likes 56 Likes 56