SAS Tutorial | How to Restructure Your Data Using Arrays and DO Loops
Do you get data that are “short and wide”? Such data sets have one observation per subject and multiple time points and variables within one row. Jennifer Waller, Professor at Augusta University, prefers “long and skinny” data sets. In this SAS How-To tutorial, Jennifer shows you how to restructure data sets by setting up arrays and then using DO loops on those arrays. Download Data Files Jennifer uses data found on this site: https://covidtracking.com Content Outline 0:00 – Welcome 1:04 – Why Jennifer likes a long and skinny dataset 2:31 – How to set up arrays and use DO loops on the arrays 7:34 – How to output each iteration of this DO loop (OUTPUT statement is key) Learn more about SAS Software ◉ SAS Global Forum paper: A Beginners Guide to Using Arrays and DO Loops – https://www.sas.com/content/dam/SAS/s... ◉ Jennifer’s SAS Global Forum presentation – • A Beginners Guide to Using Arrays and DO L... ◉ GitHub – https://github.com/sascommunities/sas... ◉ ARRAY Statement – https://go.documentation.sas.com/?doc... ◉ DO Statement – https://go.documentation.sas.com/?doc... ◉ The DO Loop blog – https://blogs.sas.com/content/iml/ ◉ Free SAS Online Training – https://www.sas.com/en_us/training/of... SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS https://www.youtube.com/SASUsers?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 ► https://www.sas.com SAS Customer Support ► https://support.sas.com SAS Communities ► https://communities.sas.com SAS Analytics Explorers ► https://explorers.sas.com Facebook ► / sassoftware Twitter ► / sassoftware LinkedIn ► / sas Blogs ► https://blogs.sas.com RSS ► https://www.sas.com/rss
SAS Tutorial | Transfer Learning
Part 2: Using Proc SQL to create and use arrays in macros in SAS.
SAS DATA STEP Crash Course: Learn SAS in Under an Hour!
A Beginners Guide to Using Arrays and DO Loops
SAS Tutorial | How to Create Macro Variables and Use Macro Functions
Hash Iterator Objects in SAS: SAS for Beginners (Lesson 33)
Arrays in SAS | Using IN & OF Operators and DO Loop With Arrays |SAS Arrays Guide With Real Examples
Ex-Google Recruiter Explains Why "Lying" Gets You Hired
LOOPS IN SAS - 2 | Iterative Do Loop in SAS | Do Index Loop in SAS | Do Loop in SAS
DO loops
LOOPS in SAS - 1 | Introduction to Loops in SAS | What is Loop and How Does it Work in SAS
Understanding transpose using data step arrays (wide to long) in SAS
Using Arrays in SAS | Data Tutorial | Do Loops
SAS Tutorial | If-Then / Else Statements
SAS Libraries (Libname Statement) and Importing Data into SAS OnDemand for Academics
SAS Tutorial | 3 Steps to Build a SAS Macro Program
Using Regular Expressions in SAS | Find and Replace a Pattern | PRXCHANGE
Nobody Breaks Celebrities Like Rowan Atkinson
How SpaceX Humiliated Wall Street
