Ohio SAS Users Webinars - online resources
Thank you to everyone involved in making this event such a great success!
For a link to all of the presentations from our recent webinar series, as well as recommended readings and other topics of interest CLICK HERE.
Thank you to everyone involved in making this event such a great success!
For a link to all of the presentations from our recent webinar series, as well as recommended readings and other topics of interest CLICK HERE.
New Online Training:
Fuzzy Matching Programming Techniques Using SAS® Software
July 29th from 3-4pm
Kirk Paul Lafler
REGISTER HERE
This 1-hour course teaches fuzzy matching techniques using the SOUNDEX (phonetic matching) algorithm, and the SPEDIS, COMPLEV, and COMPGED functions
Course Description Data comes in all forms, shapes, sizes and complexities. Stored in files and data sets, SAS® users across industries know all too well that data can be, and often is, problematic and plagued with a variety of issues. When a unique and reliable identifier, referred to as a key, is available, users are generally able to search or match records from two or more data sets using programming techniques without problem. But, when a unique identifier is not reliable or does not exist, such as with files containing subscriber names, mailing addresses, and/or misspelled email addresses, where one or more characters are transposed, or are partially and/or incorrectly recorded the problem becomes more complicated. This course will introduce what fuzzy matching is, along with the application of the SOUNDEX (for phonetic matching) algorithm, the SPEDIS, COMPLEV, and COMPGED functions to resolve key identifier issues and to successfully match, merge, and join less than perfect or messy data.
Abstract, presentation outline and information about the presenter
Fuzzy Matching Programming Techniques Using SAS® Software
July 29th from 3-4pm
Kirk Paul Lafler
REGISTER HERE
This 1-hour course teaches fuzzy matching techniques using the SOUNDEX (phonetic matching) algorithm, and the SPEDIS, COMPLEV, and COMPGED functions
Course Description Data comes in all forms, shapes, sizes and complexities. Stored in files and data sets, SAS® users across industries know all too well that data can be, and often is, problematic and plagued with a variety of issues. When a unique and reliable identifier, referred to as a key, is available, users are generally able to search or match records from two or more data sets using programming techniques without problem. But, when a unique identifier is not reliable or does not exist, such as with files containing subscriber names, mailing addresses, and/or misspelled email addresses, where one or more characters are transposed, or are partially and/or incorrectly recorded the problem becomes more complicated. This course will introduce what fuzzy matching is, along with the application of the SOUNDEX (for phonetic matching) algorithm, the SPEDIS, COMPLEV, and COMPGED functions to resolve key identifier issues and to successfully match, merge, and join less than perfect or messy data.
Abstract, presentation outline and information about the presenter
We are excited to announce the SAS Analytics Explorers program. Perhaps remote working has given you more time to boost your career, chat with other SAS users, share experiences or enjoy new activities. Whatever your situation, SAS can help you stay connected and this program will allow you to interact as much or as little as you like.
You can build connections with experts across industries, read fresh content, tips, and best practices, access private SAS resources and events, and earn points to redeem special rewards*. This is a fun way to learn and interact with other SAS users.
Join now and start earning points to claim rewards*, including SAS goodies, free access to training courses and events!
You can build connections with experts across industries, read fresh content, tips, and best practices, access private SAS resources and events, and earn points to redeem special rewards*. This is a fun way to learn and interact with other SAS users.
Join now and start earning points to claim rewards*, including SAS goodies, free access to training courses and events!
Register for our latest SAS Webinar!
Click here to register
Date: June 24th
Time: 3pm-4pm
Dating for SAS Programmers
Abstract:
Every SAS programmer needs to know how to get a date... no, not that kind of date. This paper will cover the fundamentals of working with SAS date values, time values, and date/time values. Topics will include constructing date and time values from their individual pieces, extracting their constituent elements, and converting between various types of dates. We will also explore the extensive library of built-in SAS functions, formats, and informats for working with dates and times using in-depth examples. Finally, you will learn how to answer that age-old question... when is Easter next year?
SAS Software Packages: Base SAS
Intended Audience: All levels of SAS programmers
Length and Format: 50-minute lecture Course
Outline:
1. Introduction to Dates & Times in SAS
2. Writing Dates & Times with Formats a. Built-in Date and Time Formats b. Picture Formats c. Custom Formats
3. Reading Dates & Times with Informats
4. Manipulating Dates & Times with Functions
a. Functions for getting the current date and time
b. Functions for extracting specific elements from dates and times
c. Functions for building dates and times from components
d. Functions for working with date and time intervals
5. Date & Time Macro Variables
6. Wrap-Up and Recommended Resources
About the Instructor
Josh Horstman is an independent statistical programmer based in Indianapolis with over 22 years’ experience using SAS in the life sciences industry. He specializes in analyzing clinical trial data, and his clients have included major pharmaceutical corporations, biotech companies, and research organizations. A SAS Certified Advanced Programmer, Josh loves coding and is a frequent presenter and trainer at SAS Global Forum and various regional and local SAS user groups. Josh holds a bachelor's degree in mathematics and computer science, and a master's degree in statistics from Colorado State University.
Click here to register
Date: June 24th
Time: 3pm-4pm
Dating for SAS Programmers
Abstract:
Every SAS programmer needs to know how to get a date... no, not that kind of date. This paper will cover the fundamentals of working with SAS date values, time values, and date/time values. Topics will include constructing date and time values from their individual pieces, extracting their constituent elements, and converting between various types of dates. We will also explore the extensive library of built-in SAS functions, formats, and informats for working with dates and times using in-depth examples. Finally, you will learn how to answer that age-old question... when is Easter next year?
SAS Software Packages: Base SAS
Intended Audience: All levels of SAS programmers
Length and Format: 50-minute lecture Course
Outline:
1. Introduction to Dates & Times in SAS
2. Writing Dates & Times with Formats a. Built-in Date and Time Formats b. Picture Formats c. Custom Formats
3. Reading Dates & Times with Informats
4. Manipulating Dates & Times with Functions
a. Functions for getting the current date and time
b. Functions for extracting specific elements from dates and times
c. Functions for building dates and times from components
d. Functions for working with date and time intervals
5. Date & Time Macro Variables
6. Wrap-Up and Recommended Resources
About the Instructor
Josh Horstman is an independent statistical programmer based in Indianapolis with over 22 years’ experience using SAS in the life sciences industry. He specializes in analyzing clinical trial data, and his clients have included major pharmaceutical corporations, biotech companies, and research organizations. A SAS Certified Advanced Programmer, Josh loves coding and is a frequent presenter and trainer at SAS Global Forum and various regional and local SAS user groups. Josh holds a bachelor's degree in mathematics and computer science, and a master's degree in statistics from Colorado State University.
Register for our free SAS Webinar!
REGISTER HERE
May 27th
3pm to 4pm
Short Jaunt Down Function and Format Fairway
Abstract: We have all been there. We write a program based on the data we have. Then, we get new data and we must
update the program. Making these updates can be time consuming. Not only must you update the production version of
the program, but someone must also update any associated validation or QC programs. Wouldn’t it be nice if there were
ways around this? This is where data-driven techniques come in handy. Using detailed examples, you will learn how to
write robust code that is ready to handle an unexpected bend in the road! This presentation will cover a few data-driven
techniques such as: discovering and using information about variables even if it's not known in advance; using
concatenation functions and generating dynamic formats that are based on the data instead of hard-coded into your
program.
SAS Software Packages: Base SAS
Intended Audience: Basic familiarity with DATA step programming
Length and Format: 50-minute lecture
Course Outline:
Introduction:
What is meant by data-driven?
What is the benefit of data-driven?
Variable, ANY/NOT and CAT Functions:
Explanation of functions and syntax
Illustration of how they can be used
PROC FORMAT
Build format libraries based on the data to use as input for other fields.
REGISTER HERE
May 27th
3pm to 4pm
Short Jaunt Down Function and Format Fairway
Abstract: We have all been there. We write a program based on the data we have. Then, we get new data and we must
update the program. Making these updates can be time consuming. Not only must you update the production version of
the program, but someone must also update any associated validation or QC programs. Wouldn’t it be nice if there were
ways around this? This is where data-driven techniques come in handy. Using detailed examples, you will learn how to
write robust code that is ready to handle an unexpected bend in the road! This presentation will cover a few data-driven
techniques such as: discovering and using information about variables even if it's not known in advance; using
concatenation functions and generating dynamic formats that are based on the data instead of hard-coded into your
program.
SAS Software Packages: Base SAS
Intended Audience: Basic familiarity with DATA step programming
Length and Format: 50-minute lecture
Course Outline:
Introduction:
What is meant by data-driven?
What is the benefit of data-driven?
Variable, ANY/NOT and CAT Functions:
Explanation of functions and syntax
Illustration of how they can be used
PROC FORMAT
Build format libraries based on the data to use as input for other fields.
Richann Watson is an independent statistical programmer and CDISC consultant based in
Ohio. She has been using SAS since 1996 with most of her experience being in the life
sciences industry. She specializes in analyzing clinical trial data and implementing CDISC
standards. Additionally, she is a member of the CDISC ADaM team and various sub-teams.
Richann loves to code and is an active participant and leader in the SAS User Group
community. She has presented numerous papers, posters, and training seminars at SAS
Global Forum, PharmaSUG, and various regional and local SAS user group meetings.
Richann holds a bachelor’s degree in mathematics and computer science from Northern
Kentucky University and master’s degree in statistics from Miami University.
Ohio. She has been using SAS since 1996 with most of her experience being in the life
sciences industry. She specializes in analyzing clinical trial data and implementing CDISC
standards. Additionally, she is a member of the CDISC ADaM team and various sub-teams.
Richann loves to code and is an active participant and leader in the SAS User Group
community. She has presented numerous papers, posters, and training seminars at SAS
Global Forum, PharmaSUG, and various regional and local SAS user group meetings.
Richann holds a bachelor’s degree in mathematics and computer science from Northern
Kentucky University and master’s degree in statistics from Miami University.
One Day Conference 2020 cancelled
At this time, due to the current medical and public health concerns around COVID-19, CINSUG has made the difficult decision to cancel this year's SAS Ohio One-Day Conference. However, we look forward to seeing you at the SAS Ohio ODC 2021! In the meantime, we are planning a virtual event for you; please watch out for updates, both here and via our listserv!
At this time, due to the current medical and public health concerns around COVID-19, CINSUG has made the difficult decision to cancel this year's SAS Ohio One-Day Conference. However, we look forward to seeing you at the SAS Ohio ODC 2021! In the meantime, we are planning a virtual event for you; please watch out for updates, both here and via our listserv!
Join Our Mailing List
To receive the most up to date information regarding our events, please go to http://www.freelists.org/list/cinsug and register your email. This is a privately managed list and we will never send you any emails that aren't related to CinSUG or SAS.
To receive the most up to date information regarding our events, please go to http://www.freelists.org/list/cinsug and register your email. This is a privately managed list and we will never send you any emails that aren't related to CinSUG or SAS.
Thank you to everyone for making the 2019 Conference a great success! Papers can be found here.
Register now to attend MWSUG 2019!
You still have time to register with the early-bird discount to attend MWSUG 2019! We have been planning an exciting conference for you and we are looking forward to seeing you in Chicago. Register today!
Conference Highlights
Don’t forget: After you register, book your room. Accommodations are available at Hyatt Regency Chicago. Conference rates of $234/night end on Sept. 9.
Book your reservation now.
Important Dates
Please visit the conference website for more information and the latest updates.
We look forward to seeing you at MWSUG 2019!
Sincerely,
Jessica Chen – Academic Chair
Adrian Katschke – Operations Chair
You still have time to register with the early-bird discount to attend MWSUG 2019! We have been planning an exciting conference for you and we are looking forward to seeing you in Chicago. Register today!
Conference Highlights
- Over 100 presentations.
- Pre-conference training workshops.
- Hands-on workshops.
- Live demos.
- Networking and Innovation Area.
- Best and most popular SAS authors and educators.
- Fun, food and friends!
Don’t forget: After you register, book your room. Accommodations are available at Hyatt Regency Chicago. Conference rates of $234/night end on Sept. 9.
Book your reservation now.
Important Dates
- Early registration ends – Aug. 31
- Guaranteed hotel rate ends – Sept. 9
- Regular registration ends – Sept. 20
- Pre-conference training – Sept. 27-29
- Conference dates – Sept. 29 – Oct. 1
Please visit the conference website for more information and the latest updates.
We look forward to seeing you at MWSUG 2019!
Sincerely,
Jessica Chen – Academic Chair
Adrian Katschke – Operations Chair
Save the Date! November 15, 2018
Andrew Kuligowski will be coming to Cincinnati to present: Working with Sparse Matrices in SAS® and An Introduction to SAS® Arrays
The meeting will be at the P&G Business Center from 4-6 pm. For more information please visit our events page.
Sponsored by:
Andrew Kuligowski will be coming to Cincinnati to present: Working with Sparse Matrices in SAS® and An Introduction to SAS® Arrays
The meeting will be at the P&G Business Center from 4-6 pm. For more information please visit our events page.
Sponsored by:
Thank you to everyone for making the 2018 Conference a great success! Papers can be found here.
Events: Find about upcoming events
Past Events: Want to know what you missed. See details about past events and topics presented
Presentations: Papers and/or PowerPoint presentations from Past Events |
Job Postings: What jobs are available in our area
Ohio ODC: Get full details about this upcoming event sponsored by all three Ohio SAS User Groups
About us
The Greater Cincinnati, OH Area SAS Users Group (CinSUG)'s mission is to provide its users with opportunities to use and learn enhanced resources for SAS products, as well as to facilitate communications with other SAS Users Groups and among users of SAS in the community. This organization is open to all SAS users in the Cincinnati, Tri-State and Dayton areas.
The Greater Cincinnati, OH Area SAS Users Group (CinSUG)'s mission is to provide its users with opportunities to use and learn enhanced resources for SAS products, as well as to facilitate communications with other SAS Users Groups and among users of SAS in the community. This organization is open to all SAS users in the Cincinnati, Tri-State and Dayton areas.