Past Meetup

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

This Meetup is past

4 people went

Price: CA$10.00 /per person
Location image of event venue

Details

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.