A common befuddlement often facing beginning SAS® programmers is that the SAS data set that they create is not what they intended to create. These types of mistakes are most commonly committed because programming novices learn SAS language syntax without understanding the fundamental SAS programming concepts. In this seminar, the attendees will learn how DATA step programming operates.
Part 1: The Essence of DATA Step Programming. In this section, attendees will be exposed to what happens behind the scenes while creating a SAS data set. They will learn how a new data set is created, one row at a time, from either a raw text file or an existing SAS data set.
Part 2: How Best to Write a Loop in the DATA Step. During the execution of the DATA step processing, the DATA step works like a loop, repetitively reading the data and creating observations one at a time. This type of loop is referred to as an implicit loop. Attendees will learn how to create loops with various applications and what happens in the PDV when creating the explicit loop.
Part 3: The Many Ways to Effectively Utilize Array Processing. Utilizing array processing allows you to reduce the amount of coding in the DATA step. The syntax for constructing arrays is complicated. Once mastering syntax rules, we still need to understand what happens in the PDV during array processing.
Session ID: 5317
Presenter: Arthur Li, City of Hope National Medical Center
Topic: Programming
Industry: Non-Industry
Audience: Analyst, Programmer
Level: Novice
Content Outlines
0:00:00 - Overview and outline
0:00:45 - Understanding how the DATA Step works
0:11:09 - Importance of the OUTPUT Statement
0:12:29 - Differences in a Raw Data Set and a SAS Data Set
0:16:12 - RETAIN statement values
0:21:30 - SUM Statement
0:22:50 - IF Statement
0:23:50 - END=Option
0:30:05 - By-group processing method
0:42:00 - Duplicate or Non-duplicate observations
0:51:27 - Restructuring Data sets from Long to Wide Format
0:58:53 - Writing loops in the DATA Step
1:00:39 - Implicit Loops
1:03:17 - Explicit Loops
1:12:29 - Nested Loops
1:13:33 - Combining Implicit and Explicit Loops
1:14:55 - Array Processing
1:26:28 - Array Functions
Additional resources
Resource Hub for Data Professionals - www.sas.com/sas/offers/resour...
Learn more about SAS Software
Free SAS Online Training - www.sas.com/en_us/training/of...
Contact SAS® - www.sas.com/en_us/contact.geo...
SUBSCRIBE TO THE SAS USERS RU-vid CHANNEL #SASUsers #LearnSAS #SASGF
ru-vid.com?sub_...
ABOUT SAS
SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.
CONNECT WITH SAS
SAS ► www.sas.com/contact
SAS Customer Support ► support.sas.com
SAS Communities ► communities.sas.com
SAS Analytics Explorers ► explorers.sas.com
Facebook ► / sassoftware
Twitter ► / sassoftware
LinkedIn ► / sas
Blogs ► blogs.sas.com
RSS ►www.sas.com/rss
30 июн 2024