Proc SQL has many unique features such as creating cartesian products. You may have been warned to stay away and prevent creating cartesian products, however, there may be special cases when cartesian products can come to the rescue. Come join us as we explore the five types of cartesian products and why they are dangerous unless you know how to manage and control them.
Along with using cartesian products to join many to many datasets, cartesian products are also very useful for joining many records with one record with one or more variables whose values are constant across all records.
SAS Savvy Premium/University Members attend for free but still need to register. Non SAS Savvy Premium Members must pay $65. It's not too late to upgrade today to attend for free.
Computer and phone connections are required. Webinar will be recorded for on-demand viewing.
This webinar is sponsored by TalentMine.
© 2023 Sunil Gupta, SAS Savvy, All Rights Reserved, Sunil@SASSavvy.com, SAS is a registered trademark of SAS Institute Inc.
SAS, Statistical Analysis System, and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.