Exploring the MSGLEVEL= SAS® System Option and PROC SQL _METHOD Option

Toronto SAS Meetup
Toronto SAS Meetup
Public group
Location image of event venue


There is $10 fee upon signup and its refundable when you show up for the meetup meeting.
Title. Exploring the MSGLEVEL= SAS® System Option and PROC SQL _METHOD Option
The SAS software and SQL procedure provide powerful features and options for users to gain a better understanding of what’s taking place during query processing. This presentation explores the fully supported SAS® MSGLEVEL=I system option and PROC SQL _METHOD option as application development, testing and tuning options to display on the SAS Log important informational messages along with the SQL optimizer’s execution plan when processing SQL queries.

Intended Audience: Intermediate SAS and SQL users
Prerequisites: Minimum 6-months Base-SAS experience
Type of Presentation: Tutorial with code examples
Length: 25 minutes


Title. Four ways to Merge SAS Datasets
Author. Mamadou Dakouo


Title. Data movement issues: Explicit SQL Pass-Through can do the trick
Author. Kiran Venna
Abstract. Data movement between Teradata and SAS will have huge impact on run time of SAS ETL Job. Usage of explicit SQL Pass-Through will reduce data movement and will also improve the query performance. Proper ETL planning by using explicit SQL Pass-Through whenever it is possible will be very helpful in attaining required results by using optimal resources. explicit SQL PassThrough can also enhance execution of SAS macros, when a Teradata Table is used to create a SAS data set. This paper presents few case studies related to design of explicit SQL PassThrough in ETL and SAS Macros. Issues with explicit SQL Pass-Through with SAS macro variables and also with Remerging summary statistics with data are presented along with solutions.