Creating & Reading Data Sets

SAS 9    |    Beginner
  • 13 videos | 1h 2m
  • Earns a Badge
Rating 4.0 of 34 users Rating 4.0 of 34 users (34)
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 Business Analytics with SAS Studio: Deliver Business Intelligence by Combining SQL Processing, Insightful Visualizations, and Various Data Mining Techniques , First Edition
Channel TOSA Excel
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 Data Manipulation with SAS
Rating 4.3 of 38 users Rating 4.3 of 38 users (38)
Course Inputs & Outputs
Rating 4.5 of 30 users Rating 4.5 of 30 users (30)
Course Network Services
Rating 4.6 of 146 users Rating 4.6 of 146 users (146)