OverviewThe San Diego SAS Users Group (SANDS) is open to anyone interested in the use of SAS Software. Starting in 2017, we will meet twice a year and the meetings generally include a two-hour workshop, two presentations, door prizes, and a free dinner. There are no dues.
|
Management
SANDS is incorporated as a nonprofit educational California corporation and is managed by three elected officers and an Executive Committee. Elections are held at the first meeting of the calendar year. Currently elected officers include:
|
Next Meetings:
|
Presenters' Bios and Presentation Titles and Abstracts for the June 14, 2017 Meeting
Jane Eslinger
SAS
Jane Eslinger is a Senior Technical Support Analyst at SAS Headquarters in Cary, North Carolina. In the six years that Jane has been at SAS, she has earned certifications as an Advanced Programmer for SAS®9 and as an Advanced Visual Business Analyst and authored The SAS® Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques. She has presented at numerous conferences and users’ groups across the US, including a 2015 SAS Global Forum paper about compute blocks in PROC Report. In her day-to-day work, Jane enjoys supporting SAS customers in using ODS and Base SAS® procedures, with an emphasis on PROC REPORT. Before joining SAS, Jane served as a statistician and statistical programmer in the social science and clinical research fields. She earned her Bachelor of Science in Statistics from NC State University.
The REPORT Procedure and ODS Destination for Microsoft Excel: The Smarter, Faster Way to Create First-Rate Excel Reports
Does your job require you to create reports in Microsoft Excel on a quarterly, monthly, or even weekly basis? Are you creating all or part of these reports by hand, referencing another sheet containing rows and rows and rows of data? If so, stop! There is a better way! The new ODS destination for Excel enables you to create native Excel files directly from SAS®. Now you can include just the data you need, create great-looking tabular output, and do it all in a fraction of the time! This paper shows you how to use the REPORT procedure to create polished tables that contain formulas, colored cells, and other customized formatting. Also presented in the paper are the destination options used to create various workbook structures, such as multiple tables per worksheet. Using these techniques to automate the creation of your Excel reports will save you hours of time and frustration, enabling you to pursue other endeavors.
Twanda Baker
SAS
Twanda has nearly two decades of technology training experience in the education industry. In 2013, Twanda earned her Master of Science degree in Advanced Analytics from North Carolina State University. As a student, her concentration was retail forecasting. After graduation, Twanda joined SAS Institute and broadened her analytic focus to include data mining, text analytics, and data visualization. As a Systems Engineer on the Customer Loyalty Team at SAS, she helps companies identify solutions to their analytic challenges, delivers presentations at public conferences, and conducts demonstrations for customer knowledge sharing sessions.
What’s New for Analytics in SAS® 9.4?
Many new analytical enhancements and procedures have been added for SAS 9.4 analytical products including Base SAS, SAS/STAT®, SAS/ETS®, and SAS® Enterprise Miner™. This session not only covers the new additions but also provides examples.
Ed Summers
SAS
Ed Summers is a blind software engineer and an accessibility specialist. He has a B.S. in Computer Science and more than 20 years of professional experience as a software developer and a development manager. Ed’s personal mission is to enable people with disabilities to realize their full potential in the classroom and the 21st century knowledge economy. He fulfills that mission as a leader in the software industry and disability-related not-for-profit organizations. Ed is a Distinguished Technical Leader and Senior Manager of Accessibility at SAS, the market leader in business analytics software and services that is used at more than 80,000 sites around the world. The SAS accessibility team enables users of all abilities to access the power of analytics. Ed also serves as the Chair of the North Carolina State Board of Education Advisory Council for the Governor Morehead School for the Blind.
Accessibility and SAS® University Edition: Tips for Students and Professors
Accessibility has become a hot topic on campus due to a flurry of recent investigations of discrimination against students with disabilities by the U.S. Department of Justice and the U.S. Department of Education. This paper provides an update on the latest improvements in SAS University Edition that are specifically targeted to enable students with disabilities to excel in the classroom and beyond. The paper will cover the entire SAS University Edition user experience including installation, documentation, training, support, SAS Studio, and new accessibility features in SAS 9.4M4.
SAS
Jane Eslinger is a Senior Technical Support Analyst at SAS Headquarters in Cary, North Carolina. In the six years that Jane has been at SAS, she has earned certifications as an Advanced Programmer for SAS®9 and as an Advanced Visual Business Analyst and authored The SAS® Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques. She has presented at numerous conferences and users’ groups across the US, including a 2015 SAS Global Forum paper about compute blocks in PROC Report. In her day-to-day work, Jane enjoys supporting SAS customers in using ODS and Base SAS® procedures, with an emphasis on PROC REPORT. Before joining SAS, Jane served as a statistician and statistical programmer in the social science and clinical research fields. She earned her Bachelor of Science in Statistics from NC State University.
The REPORT Procedure and ODS Destination for Microsoft Excel: The Smarter, Faster Way to Create First-Rate Excel Reports
Does your job require you to create reports in Microsoft Excel on a quarterly, monthly, or even weekly basis? Are you creating all or part of these reports by hand, referencing another sheet containing rows and rows and rows of data? If so, stop! There is a better way! The new ODS destination for Excel enables you to create native Excel files directly from SAS®. Now you can include just the data you need, create great-looking tabular output, and do it all in a fraction of the time! This paper shows you how to use the REPORT procedure to create polished tables that contain formulas, colored cells, and other customized formatting. Also presented in the paper are the destination options used to create various workbook structures, such as multiple tables per worksheet. Using these techniques to automate the creation of your Excel reports will save you hours of time and frustration, enabling you to pursue other endeavors.
Twanda Baker
SAS
Twanda has nearly two decades of technology training experience in the education industry. In 2013, Twanda earned her Master of Science degree in Advanced Analytics from North Carolina State University. As a student, her concentration was retail forecasting. After graduation, Twanda joined SAS Institute and broadened her analytic focus to include data mining, text analytics, and data visualization. As a Systems Engineer on the Customer Loyalty Team at SAS, she helps companies identify solutions to their analytic challenges, delivers presentations at public conferences, and conducts demonstrations for customer knowledge sharing sessions.
What’s New for Analytics in SAS® 9.4?
Many new analytical enhancements and procedures have been added for SAS 9.4 analytical products including Base SAS, SAS/STAT®, SAS/ETS®, and SAS® Enterprise Miner™. This session not only covers the new additions but also provides examples.
Ed Summers
SAS
Ed Summers is a blind software engineer and an accessibility specialist. He has a B.S. in Computer Science and more than 20 years of professional experience as a software developer and a development manager. Ed’s personal mission is to enable people with disabilities to realize their full potential in the classroom and the 21st century knowledge economy. He fulfills that mission as a leader in the software industry and disability-related not-for-profit organizations. Ed is a Distinguished Technical Leader and Senior Manager of Accessibility at SAS, the market leader in business analytics software and services that is used at more than 80,000 sites around the world. The SAS accessibility team enables users of all abilities to access the power of analytics. Ed also serves as the Chair of the North Carolina State Board of Education Advisory Council for the Governor Morehead School for the Blind.
Accessibility and SAS® University Edition: Tips for Students and Professors
Accessibility has become a hot topic on campus due to a flurry of recent investigations of discrimination against students with disabilities by the U.S. Department of Justice and the U.S. Department of Education. This paper provides an update on the latest improvements in SAS University Edition that are specifically targeted to enable students with disabilities to excel in the classroom and beyond. The paper will cover the entire SAS University Edition user experience including installation, documentation, training, support, SAS Studio, and new accessibility features in SAS 9.4M4.
