Ohio SAS® Users Conference 2019
Secure Online Event Registration
Our annual conference allows those in Ohio and surrounding states the opportunity to hear presentations from statistical programmers, statisticians, data managers, and others who use SAS and analyze data.
Register by May 10, 2019 to save 20% off our regular registration rate of $124.
(requires a coupon code)
Clear Selection
This presentation explains some techniques available to you when working with SAS® and Microsoft Excel data. You learn how to import Excel data into SAS using the IMPORT procedure, the SAS DATA step, SAS® Enterprise Guide®, and other methods. Exporting data and analytical results from SAS to Excel is performed using the EXPORT procedure, the SAS DATA step, SAS Enterprise Guide, the SAS Output Delivery System (ODS), and other tools. The material is appropriate for all skill levels, and the techniques work with various versions of SAS software running on the Windows, UNIX (including Linux), and z/OS operating systems. Some techniques require only Base SAS® and others require SAS/ACCESS® Interface to PC Files.
SAS is a world leader in data analytics while Microsoft Excel, with over 30 million active users, is a leader when it comes to spreadsheet packages. Excel spreadsheets are heavily used for calculations, information organization, statistical analysis, and graphics. SAS can leverage the power of its world-class analytics and reporting capabilities to produce stylistic and highly functional Excel spreadsheets using the Excel destination in the SAS® Output Delivery (ODS) System. This paper, relevant to anyone who uses Microsoft Excel, offers insights into the depths of the ODS Excel destination by illustrating how you can customize styles in Microsoft Excel worksheets, and it discusses common layout and reporting questions (including limitations). In addition, the discussion covers useful applications for automating and executing Excel worksheets. After diving deep into this discussion about the ODS Excel destination, you should understand the behavior and capabilities of the destination so that you can create aesthetic and effective Excel worksheets.
Machine Learning has been everywhere for quite some time now. We hear about it in the trade journals, on TV, in newspapers and comic strips. Companies are spending a lot of money on Machine Learning. Maybe you’ve thought about jumping on the bandwagon. Good. There is a lot of benefit to using analytical techniques like Machine Learning. As you do, it’s important to be well prepared. This webinar will discuss 5 things that you probably don’t know about Machine Learning, but that are important to know as you make that jump.
