Creating & Reading Data Sets

SAS 9    |    Beginner
  • 13 Videos | 1h 2m
  • Earns a Badge
Likes 25 Likes 25
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

  • Playable
    1. 
    Creating a Data Set from an Excel Sheet
    5m 1s
    UP NEXT
  • Playable
    2. 
    Reading from an Excel Sheet
    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 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

Likes 0 Likes 0  
Likes 8 Likes 8  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 69 Likes 69  
COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 8 Likes 8