From the course: SAS® 9.4 Cert Prep: Part 08 Controlling Data Step Processing
Join today to access over 22,500 courses taught by industry experts.
Controlling DATA step processing - SAS Tutorial
From the course: SAS® 9.4 Cert Prep: Part 08 Controlling Data Step Processing
Controlling DATA step processing
- [Instructor] Now that you have a better idea of what happens with the PDV during the compilation and execution phases of DATA step processing you can use that knowledge to your advantage. There are times when the default processing rules of execution are perfectly fine for your needs, but there are other times when you need to alter those rules to process your data in a different way. The DATA step enables you to control exactly how the steps of execution proceed. Let's start by looking at the implicit output that occurs at the end of the DATA step. By default SAS reads one row from the input table, manipulates the values, and writes that updated row to the output table. But what if you want to control exactly when and where each row is written? To illustrate this let's look at the sashelp.shoes table. Each row includes annual sales for region, product and subsidiary. Suppose we want to create a table that includes a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.