| Speed testing SAS, SQL, and Python on Medicare data in a Snowflake Cloud |
| September 24, 2024: 3:30 AM - 3:45 AM |
| Data Collection, Management & Manipulation, Brookside B |
| Authors | Abstract |
|---|---|
| Ethan Ritchie | The Center for Medicare Services (CMS) recently switched from housing its Medicare data on a mainframe system to a Snowflake cloud system. This presentation is intended for users with any level of experience and will explore the differences in time it takes to generate basic statistics for hundreds of millions of rows using SAS, SQL, and Python in the analytics environments provided by CMS. |