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