Creating & Reading Data Sets

SAS 9
  • 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
    FREE ACCESS
  • Locked
    4. 
    Using the ODS to Create an Excel Sheet
    3m 9s
    FREE ACCESS
  • Locked
    5. 
    Using the IMPORT Wizard with Excel
    3m 9s
    FREE ACCESS
  • Locked
    6. 
    Using the EXPORT Wizard with Excel
    1m 58s
    FREE ACCESS
  • Locked
    7. 
    Creating a Data Set from a Delimited File
    4m 10s
    FREE ACCESS
  • Locked
    8. 
    Using the LENGTH Statement
    5m 3s
    FREE ACCESS
  • Locked
    9. 
    Reading Nonstandard Data with Informants
    6m 28s
    FREE ACCESS
  • Locked
    10. 
    Processing Nonstandard Data in the DATA Step
    5m 4s
    FREE ACCESS
  • Locked
    11. 
    Using the List Input DSD Option
    5m 15s
    FREE ACCESS
  • Locked
    12. 
    Using the MISSOVER Option
    6m 1s
    FREE ACCESS
  • Locked
    13. 
    Exercise: Read Data
    8m 52s
    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 Creating Summary Reports & Charts
Likes 11 Likes 11  
COURSE Datasets in R: Loading & Saving Data
Likes 0 Likes 0  
COURSE Using Formulas to Obtain Data
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Arrays & Restructuring and Merging Data Sets
Likes 10 Likes 10  
COURSE Getting Started with Excel for Office 365
Likes 1408 Likes 1408  
COURSE The SAS Environment
Likes 47 Likes 47