This course presents techniques for integrating SAS and Microsoft Excel to access Excel workbooks to explore, prepare, analyze, and report on your data using the SAS XLSX engine.
This course presents techniques for integrating SAS and Microsoft Excel to access Excel workbooks to explore, prepare, analyze, and report on your data using the SAS XLSX engine.
You learn a bit about the history of SAS and Excel, and then how to easily read data from and write data to Excel files from 2007 and later using SAS techniques like the IMPORT and EXPORT procedures, and the LIBNAME engine.
The course also teaches you to use the SAS Output Delivery System (or ODS) to create Excel reports. ODS enables you to customize your Excel reports by adding tables, summarized data, and visualizations using SAS.
ODS also enables you to fully customize the styling of your Excel reports. Lastly, you learn about a few advanced techniques to add Excel formats and functions to Excel reports.
Prerequisites
Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS Programming 1: Essentials course and used SAS for at least one month. Basic knowledge of the Output Delivery System (ODS) and simple ODS invocation techniques is helpful, but not required.
This Course Addresses:;
Base SAS software 9.4M2 and later (including SAS Viya).
SAS/ACCESS Interface to PC Files XLSX engine for Microsoft Excel 2007 and later.
Output Delivery System (ODS) to produce Microsoft Excel files compatible with Microsoft Office 2010 and later.
Our vision and mission are based on the belief that analytics changes the world.Connecting analytics and advocacy to create something new, better, purposeful and lasting.
Our Vision
To be the most trustworthy analytics partner on the planet.
We envision a world where everyone can make better decisions, grounded in trusted data and assisted by the productivity and speed of SAS® AI and analytics.
When decisions need to happen at just the right moment, you need the world’s most trustworthy analytics brand and people to give you confidence.
Our Mission
To provide knowledge in the moments that matter.
Making it easier and faster for more people to use powerful analytics shortens the path from data to insights and inspires bold new discoveries that drive progress.
The result is analytics that breaks down barriers, fuels ambition and gets results in the moments that matter most. Read about our mission in action.
Our Values
From the software we create to the conversations we share, our core values inform partners, customers and prospects about the type of relationship they can expect when they work with us.
The Basic Excel Skills Hands-on training teaches you how to use Microsoft Excel 2019 / Microsoft Office 365 extremely well for day to day use in the office, and at home.
Excel has also been the backbone for organizations for a very long time! This course helps you understand how you could leverage the power of Excel and SQL for data management & visualization.
Microsoft Visio is an intelligent diagramming and vector graphics application. Visio helps simplify information communication with data-driven visual information including,
Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.
Microsoft Office is a most popular windows or Mac suites that containing various tools for processing word (Word), data entries in spreadsheets (Excel), and audio-visual clippings (PowerPoint).
Ā© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy