Uploading data from SAS 9 to AWS Redshift at scale requires careful consideration of performance, data formatting, and error handling. In this session, Brooke Delgoffe walks through two approaches—direct LIBNAME loads and S3-based bulk loading—and explains when each method is most effective. You’ll see how a custom macro automates S3 uploads, handles edge cases like encoding and data type mismatches, and significantly improves performance for large datasets. The session also highlights common pitfalls, including CSV transformation issues and Redshift load errors, along with strategies to diagnose and resolve them.
Presenter: Brooke Delgoffe, Sanford Health | Marshfield Clinic Research Institute
Watch the recording
