SAS Coding with Copilot: From Raw Data to Analysis-Ready Tables

Business analysts are often asked to work with raw files such as CSVs and turn them into clean, usable SAS datasets that can support downstream analysis. In this session, participants follow a realistic analyst workflow that starts with messy CSV inputs and ends with a trusted, analysis-ready SAS table. Using Microsoft Copilot as a coding and thinking assistant, the session demonstrates how to import external files, inspect and clean data, standardize values, identify join keys, combine datasets, and validate results along the way. Emphasis is placed on prompt quality, analyst judgment, validation, and professional SAS coding practices in a regulated banking environment.

About the Presenter

With over a decade of experience in data analytics and machine learning, Melodie Rush brings a wealth of expertise to her role as an Customer Success Data Scientist. Her passion for solving complex problems with innovative technology has made her an essential member of the SAS team.  Melodie's work involves developing and deploying advanced models that help businesses make better decisions based on their data insights. She is constantly exploring new ways to improve analytical methods and technologies, striving to create systems that are faster, more accurate, and more efficient than ever before. In addition to her technical skills, Melodie is also known for her ability to communicate complex concepts in simple terms.