SAS® 9.4 Cert Prep: Part 02 Accessing Data
27mBeginner2020-01-06
Authors
SAS Institute
Business analytics software and services
Course details
Want to get ahead in a crowded job market? Get certified with SAS. This course is part of a series by the SAS Institute, designed to prepare you for the SAS 9.4 certification exam. Here, instructor Stacey Syphus helps you understand the first step in the SAS programming process: reading and accessing data in a variety of locations and formats. Learn how to identify the features of SAS tables, access data through libraries, and import unstructured and structured data into SAS for analysis.
Skills covered
SASDesktop DatabasesStatisticsCert PrepData ScienceBusiness Software and Tools
Concepts
Introduction
- where is your data coming from-
Understanding SAS Data
- types of data
- what is a sas table-
- required column attributes for sas tables
- listing table and column attributes
Accessing Data Through Libraries
- accessing data in a program
- using a library to read sas data
- automatic sas libraries
- demo- exploring automatic sas libraries
- using a library to read excel files
- demo- using a library to read excel files
Importing Data into SAS
- importing unstructured data
- demo- importing a comma-delimited (csv) file
- importing an excel file