Keyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS SavvyKeyword Search SAS Savvy
SAS® Savvy
Smarter SAS® Searches Save Time

Beyond Proc SQL: Extracting Dataset Vitals

  • 25 Oct 2017
  • 11:00 AM
  • webinar

Registration

  • Non-members need to pay to be enrolled in this training session.

When you get a SAS dataset, would you also like to get dataset vitals so that you can confirm and better know your data?  With the innovative Proc SQL technique I will introduce during this webinar, you can do just that! 


Won't it be nice to have a macro to provide dataset vitals such as the total number of observations, number of unique patients based on any conditions and if duplicate records exist based on key variables.  This becomes very useful to track progress from raw to sdtm to adams for example.  Ideally, datasets have the expected numbers for each important vital.  This Proc SQL technique is one that I doubt you have seen in any book or tip since it takes an unconventional approach to address these challenges.  I was not even sure Proc SQL could do this until I pushed the envelope.

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.



© 2014 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.

Powered by Wild Apricot Membership Software