[Sora] Fwd: The Complete Guide to PROC SQL

Tue Feb 6 15:39:58 PST 2024

I’m teaching an SQL class in March. While it’s focused on PROC SQL (the procedure that lets you use SQL code in SAS), the universal concepts of SQL apply across many platforms. I hope you’ll join us!

Tasha

______________________________________________

Tasha Chapman

Senior Research Analyst / Lead Data Steward

Oregon Department of Consumer and Business Services

Tasha.L.Chapman at dcbs.oregon.gov<mailto:Tasha.L.Chapman at dcbs.oregon.gov>  • new email address

(503) 428-2879

She/her/hers

Find out more about the State of Oregon Research Academy at OregonResearch.org

________________________________
From: Western Users of SAS Software (WUSS) <socialmedia at wuss.org>
Sent: Tuesday, February 6, 2024 2:59 PM
To: CHAPMAN Tasha L * DCBS <tasha.l.chapman at dcbs.oregon.gov>
Subject: The Complete Guide to PROC SQL

Seamlessly query data on any programming platform
[WUSS Virtual] <https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=cd3c08be51&e=23b5f1504e>
Online classes at your fingertips

Western Users of SAS Software is excited to announce WUSS Virtual Classes, a curated selection of the finest content our instructors have to offer.

WUSS Virtual Classes feature several of our most popular half-day training classes taught live with expert instructors. These classes are a tremendous value at only $175 per session.

Registration is now open. Sign up today!

Register today!<https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=bfcc1e5fea&e=23b5f1504e>
[WUSS 2024 Virtual Class. The Complete Guide to PROC SQL. Mastering Essentials and Unlocking Advanced Techniques. with Tasha Chapman. Part 1 - March 12. Part 2 - March 14. 10am - 2pm Pacific. Learn more at WUSS.org.] <https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=c52f4c74ed&e=23b5f1504e>
The Complete Guide to PROC SQL:
Mastering Essentials and Unlocking Advanced Techniques
March 12 & 14, 2024  |  10am-2pm Pacific  |  $175/person (each part)
This is a two-part series.  Each part may be taken individually or as a package.

SQL is a common language used across many computing platforms to store, retrieve, and manipulate data in relational databases. You can use SQL code in SAS, instantly doubling the tools in your coding toolbox, but after this course you’ll also be able to seamlessly query and manipulate data from multiple data tables on any programming platform AND easily communicate with non-SAS programmers in a language they understand.

This course is appropriate for beginners who have never used SQL as well as intermediate level users who would like to strengthen their existing skills. The course will cover the basic syntax of SQL to develop a firm understanding of how the language is used, and then move to more advanced topics. With engaging activities and exercises, there will be plenty of opportunities to practice what you’ve learned both in and out of the classroom.

This class is split into two parts. While each part can be taken individually, it is strongly recommended that both parts be taken together.

Part 1 - March 12
By the end of part one attendees will have an understanding of:

  *   Basic database concepts
  *   SQL select statements
  *   Restricting rows and sorting data
  *   Using SAS syntax within PROC SQL
  *   CASE/WHEN expression
  *   Group functions

Part 2 - March 14
By the end of part two attendees will have an understanding of:

  *   Creating tables
  *   Joining tables
  *   Unions
  *   Subqueries
  *   Tips for better coding
  *   Using PROC SQL with non-SAS databases

Register today!<https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=06bcb1917a&e=23b5f1504e>
[https://mcusercontent.com/ad153879d45d11498f339446c/images/9492ebd3-d64f-c708-f49f-082f86f52588.png] <https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=282e917e5a&e=23b5f1504e>

About the instructor

Tasha Chapman has been using SAS since 2003 and an active member of the SAS User Community since 2006. Throughout her career she has championed continuing education and professional development, presented trainings and workshops at professional conferences across the country, sat as an executive committee member on nationally recognized associations, and founded two organizations dedicated to educating colleagues about research, data, and statistics. She was the chair of the Western Users of SAS Software Conference and Educational Forum in 2017 and 2022.

Tasha received a Master’s Degree in Psychology, with an emphasis on personality assessment and psychometrics from the University of California, Riverside. Since 2005 she has worked for the State of Oregon as a lead research analyst providing data and policy analysis for Oregon OSHA, the Oregon Child Welfare Program, and the Oregon Health Authority. She lives in Salem, Oregon with her two adorable kids, Nadia and Atlas.
For More Information

For more information about the WUSS Virtual Classes,
reach out to us at Training at wuss.org<mailto:training at wuss.org>.

Forward this email to a friend!<https://us15.forward-to-friend.com/forward?u=ad153879d45d11498f339446c&id=9bb30766a6&e=23b5f1504e>

[LinkedIn]<https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=3877861b45&e=23b5f1504e>
[Twitter]<https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=29a6ac6c33&e=23b5f1504e>
[Instagram]<https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=fe666a3efc&e=23b5f1504e>
[Facebook]<https://wuss.us15.list-manage.com/track/click?u=ad153879d45d11498f339446c&id=65a72f7803&e=23b5f1504e>
Copyright © 2024 Western Users of SAS Software, Inc., All rights reserved.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/sora/attachments/20240206/60fe3f4b/attachment.html>