Recommended SAS White Papers for Macros for Automating ETL in Data Warehousing
*Note: I may be compensated, but you will not be charged, if you click on the links below.
💡 If you are a public health practitioner looking for a targeted program for enhancing your data science skills, please sign up to participate in my 30-minute market research interview so I can get your feedback: https://buff.ly/3UnLqmq
In this video, Monika Wahi showcases her recommended SAS White Papers for guiding the development of macros in SAS for automating ETL code for data warehousing.
LINKS TO THE WHITE PAPERS COVERED
📕Paper 1: SAS Macro Programming for Beginners by Susan J. Slaughter and Lora D. Delwiche, available here: https://buff.ly/3lqQyn1
📗Paper 2: Don't Be a SAS® Dinosaur: Modernizing Programs with Base SAS 9.2 Enhancements by Warren Repole Jr., available here: https://buff.ly/3S3VIpo
📘Paper 3: Using SAS Macro Language and SAS® Pipe to Process State Health Care Survey Data by Xiaoting Qin & Cathy M. Bailey, available here: https://buff.ly/3VuvAqE
📙Paper 4: Logging the Log Magic: Pulling the Rabbit out of the Hat by Adel Fahmy, available here: https://buff.ly/3rViUeO
📒Paper 5: A SASAUTOS Companion: Reusing Macros by Ronald Fehd, available here: https://buff.ly/3CZafyg
COURSE & BOOK
💿Want to start using free, online SAS OnDemand for Academics – but don’t know how? Take Monika’s FREE online course, “Getting Started with SAS OnDemand for Academics (ODA): https://buff.ly/3CQVPxG
📀Want to run a SAS data warehouse? Learn how by reading Monika’s book, “Mastering SAS Programming for Data Warehousing”: https://buff.ly/31Hz1mg
WANT TO SUPPORT MONIKA ON SOCIAL MEDIA?
❤️Subscribe to Monika's YouTube channel: https://buff.ly/2W6ijuc
🧡Follow/connect with Monika on LinkedIn: / dethwench
💛Follow Monika on Twitter: / phexaminer
💚Try Monika’s courses on LinkedIn Learning: https://linkedin-learning.pxf.io/NKN0JO
💙Try Monika's boutique research methods and data science courses here: https://buff.ly/3zM243P
Timestamps for easy navigation:
00:18 In this video, Monika is sharing her favorite SAS white papers for automating ETL in SAS
00:31 Paper 1: SAS Macro Programming for Beginners by Susan J. Slaughter and Lora D. Delwiche, available here: https://support.sas.com/resources/pap...
Topics: macros vs. macro variables, process for building macros, and ordering commands in macros
01:20 Paper 2: Don't Be a SAS® Dinosaur: Modernizing Programs with Base SAS 9.2 Enhancements by Warren Repole Jr., available here: https://analytics.ncsu.edu/sesug/2009...
Topics: Improving input/output efficiency in SAS coding
01:52 Example from a historical white paper, where a new option (back then) in PROC PRINT is described. Shows side-by-side examples of code, and ways to improve coding efficiency.
02:22 Paper 3: Using SAS Macro Language and SAS® Pipe to Process State Health Care Survey Data by Xiaoting Qin & Cathy M. Bailey, available here: https://support.sas.com/resources/pap...
Topics: How to move big health datasets around and pipe it from system to system. They show using macros to pipe data from one environment to another, and how to use SAS macros across pipes.
03:02 Paper 4: Logging the Log Magic: Pulling the Rabbit out of the Hat by Adel Fahmy, available here: https://www.lexjansen.com/pharmasug/2...
Topics: Manipulating the log file to get items to print in the log file for troubleshooting purposes.
04:11 Paper 5: A SASAUTOS Companion: Reusing Macros by Ronald Fehd, available here: https://www.lexjansen.com/nesug/nesug...
Topics: Using a different way from the %INCLUDE statement to reuse SAS macros (using the SASAUTOS function instead). Learn how to do it using the %INCLUDE statement in this video: • How to Make and Call a Macro in Separate F...
05:04 Do you have any favorite SAS white papers? Please comment in the description!
Recommended SAS White Papers for Macros for Automating ETL in Data Warehousing