This course is for users who want to learn how to write SAS programs and who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses. This fast track combines the courses SAS® Programmierung 1: Grundlagen and SAS® Programmierung 2: Datenmanagement.
Lernen Sie, wie Sie / Learn how to
- Navigate the SAS windowing environment.
- Read various types of data into SAS data sets.
- Validate and clean SAS data sets.
- Create SAS variables and subset data.
- Combine SAS data sets.
- Create and enhance listing and summary reports.
- Control SAS data set input and output.
- Combine SAS data sets.
- Summarize, read, and write different types of data.
- Perform DO-loop and SAS array processing.
- Transform character, numeric, and date variables.
Zielgruppe / Who should attend
Programmers, business analysts, and anyone getting started writing SAS programs
Before attending this course, you should have experience using computer software.
In diesem Kurs wird mit folgenden Software Modulen gearbeitet / This course addresses Base SAS Software
This course is appropriate for students who are using SAS 9 software.
Introduction- Course logistics.
- Overview of Foundation SAS.
Getting Started with SAS- Introduction to SAS programs.
- Submitting a SAS program.
Working with SAS Syntax- Mastering fundamental concepts.
- Diagnosing and correcting syntax errors.
Getting Familiar with SAS Data Sets- Examining descriptor and data portions.
- Accessing SAS data libraries.
- Accessing relational databases (self-study).
Reading SAS Data Sets- Introduction to reading data.
- Using SAS data as input.
- Subsetting observations and variables.
- Adding permanent attributes.
Reading Microsoft Excel Worksheets- Using Excel data as input.
- Doing more with Excel worksheets (self-study).
Reading Delimited Raw Data Files- Using standard delimited data as input.
- Using nonstandard delimited data as input.
Validating and Cleaning Data- Introduction to validating and cleaning data.
- Examining data errors when reading raw data files.
- Validating data with the PRINT and FREQ procedures.
- Validating data with the MEANS and UNIVARIATE procedures.
- Cleaning invalid data.
Manipulating Data- Creating variables.
- Creating variables conditionally.
- Subsetting observations.
Combining SAS Data Sets- Introduction to combining data sets.
- Appending a data set (self-study).
- Concatenating data sets.
- Merging data sets one to one.
- Merging data sets one to many.
- Merging data sets with nonmatches.
Enhancing Reports- Using global statements.
- Adding labels and formats.
- Creating user-defined formats.
- Subsetting and grouping observations.
- Directing output to external files.
Producing Summary Reports- Using the FREQ procedure.
- Using the MEANS procedure.
- Using the TABULATE procedure (self-study).
Introduction to Graphics Using SAS/GRAPH (Self-Study)- Creating bar and pie charts.
- Creating plots.
- Enhancing output.
Controlling Input and Output- Writing observations explicitly.
- Writing to multiple SAS data sets.
- Selecting variables and observations.
Summarizing Data- Creating an accumulating total variable.
- Accumulating totals for a group of data.
Reading Raw Data Files- Reading raw data files with formatted input.
- Controlling when a record loads.
Data Transformations- Manipulating character values.
- Manipulating numeric values.
- Converting variable type.
Debugging Techniques- Using the PUTLOG statement.
Processing Data Iteratively- DO-loop processing.
- Conditional DO-loop processing.
- SAS array processing.
- Using SAS arrays.
Restructuring a Data Set- Rotating with the DATA step.
Combining SAS Data Sets- Using data manipulation techniques with match-merging.
Creating and Maintaining Permanent Formats- Creating permanent formats.
Other SAS Languages- Overview of other languages.
- Using the SQL procedure.
- Using SAS macro language.
Learning More- SAS resources.
- Next steps.
