SAS® Programming 1: Essentials

Anyone starting to write SAS programs

• Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs
• Access SAS, Microsoft Excel, and text data
• Explore and validate data
• Prepare data by subsetting rows and computing new columns
• Analyze and report on data
• Export data and results to Excel, PDF, and other formats
• Use SQL in SAS to query and join tables

Before attending this course, you should have experience using computer software. Specifically, you should:

• Understand file structures and system commands on your operating systems
• Be able to access data files on your operating systems

No prior SAS experience is needed.

Essentials

• The SAS programming process
• Using SAS programming tools
• Understanding SAS syntax

Accessing Data

• Understanding SAS data
• Accessing data through libraries
• Importing data into SAS

Exploring and Validating Data

• Exploring data
• Filtering rows
• Formatting columns
• Sorting data and removing duplicates

Preparing Data

• Reading and filtering data
• Computing new columns
• Conditional processing

Analyzing and Reporting on Data

• Enhancing reports with titles, footnotes, and labels
• Creating frequency reports
• Creating summary statistics reports

Exporting Results

• Exporting data
• Exporting reports

Using SQL in SAS

• Using Structured Query Language in SAS
• Joining tables using SQL in SAS

Next courses

SAS® Programming 2: Data Manipulation Techniques [PG2V2]