What we're about
Upcoming events (5+)
Lunch and Learn Webinar Presentation Title Use the Advantage of INDEXes even If a WHERE Clause Contains an OR Condition Presenter Bartosz Jabłoński Lecturer / Analyst, Warsaw University of Technology / Citibank Europe PLC About the Presenter Bart is presenting this topic at SGF2019 in Dallas. He is a leader of the Polish SAS User Group with excellent SAS Skills. We are happy he has accepted our invitation to speak! Paper Description The advantage of an indexed Base SAS® engine's data set is that when it is queried with a WHERE clause, the process might be optimized and the index subsetting works faster than a sequential read. Unfortunately, the Base SAS engine is unable to use more than one index at a time to optimize a WHERE clause. Especially when the WHERE clause contains an OR condition between two different (indexed) variables, the Base SAS engine does not optimize it and executes a sequential read. This presentation offers a simple, hash table-based solution to the following question: How do you handle a situation in which you have a WHERE clause with the OR condition on two different indexed variables and you want to use the advantage of indexing to subset the data faster? Details This event is a Webinar and Free to our members. RSVP to get the event link sent to you. Tags Cross-Industry Data Management Data Access SAS Base Programmer Intermediate
Let’s hang out and catch up. I know not everyone can make it. Just know this is the stuff I will cover: 1. Taco Tuesday 2.00 tacos. Seriously! 2. Getting to SAS on AWS. Easier than you think 3. GIT basics. Rehearsing a topic and presentation. So let’s talk. 4. MWSUG is in fall and in Chicago. Let’s get you informed. 5. Our review of the Tuesday webinar and the coming Thursday one. 6. Just introduce and network with each other. This is “our” group. Would love to hear ideas and suggestions on topics etc. Overall would love to meet and get to know more SAS Geeks! Have a great weekend and week everyone! Best Zeke
Ask a Recruiter: Managing Your Analytics & Data Science Career If you’ve ever wished you had a career advisor that specialized in the analytics and data science fields, now’s your chance! WCSUG is happy to have the Burtch Works’ data science and analytics recruiting team for a Lunch & Learn to hear about: • When to change jobs • Which skills are in demand • What companies look for, and how to choose which tools to learn • How to prep for interviews • Resume tips • How you can keep your skills sharp The WCSUG and Burtch Works' team will be sharing their knowledge from years of recruiting in this space, as well as answering questions to help set you up for long-term career success. We look forward to seeing you there! RSVP for this Free/Open Webinar About Burtch Works Burtch Works is a targeted recruiting firm whose quantitative specializations range from data science and predictive analytics to marketing research and data engineering, among many others. Over the past several years, Burtch Works has been repeatedly mentioned in the press, including The New York Times, The Wall Street Journal, CNBC, The Chicago Tribune, InformationWeek, Analytics Magazine, and many more. Burtch Works has also been recognized by Forbes as one of America’s Best Recruiting Firms. Burtch Works recruits for positions on both a contingency and retained basis with firms ranging from Fortune 50 corporations to growing startups and private equity firms. Additionally, Burtch Works recruiters maintain close relationships with quantitative professionals throughout their careers, working with early career through executive-level leadership professionals. Katie Ferguson Katie Ferguson, Partner & Executive Recruiter at Burtch Works, has over 15 years’ experience in recruiting, specializing in roles within quantitative marketing science and predictive analytics. Katie helped launch Burtch Works’ mid- and junior-level analytics practice, and her extensive knowledge of the quantitative space allows her to share copious hiring market insights on the Burtch Works blog, as well as speak with students about analytics careers. Flora Jiang Flora Jiang, an Executive Recruiter at Burtch Works, is well-versed in the analytics space, having been a quantitative market researcher at Nielsen for several years. She also spent three years doing competitive analysis, tracking studies, and qualitative interviews as a marketing consultant for a digital ad agency. Flora’s deep knowledge of the quantitative talent landscape allows her to share insights in numerous blogs and webinars, in addition to speaking to students at many universities on the intricacies of quantitative careers. Stefan Vallentine Stefan Vallentine spent several years recruiting for actuaries and predictive modelers in the insurance industry, and now partners with Katie Ferguson and Flora Jiang on the quantitative analytics team at Burtch Works. Stefan has enjoyed working in the quantitative space because of the fast pace of market activity and change in the space, and likes to focus on developing long-term relationships with both candidates and clients.
Lunch n Learn Webinar Presenter Kiran Venna SAS Data Engineer About our Speaker Kiran is SAS Certified Advance Programmer for SAS®9 and Teradata 12 Certified Technical Specialist with 8 years of experience. He is the author of 5 SAS papers and has presented at various SAS conferences. He was designated as PROC Star twice in SAS communities for answering and helping others SAS Users on SAS Communities. Presentation Title ETL with SAS - some Basics and Optimizations Details This event is a Webinar and Free to our members. RSVP to get the event link sent to you.