Log in Working With SASĀ® And Microsoft Excel

by SAS Institute Inc Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

SAS Institute Inc Logo

img Duration

7 Hours

Course Details

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.

  • Central Branch

    20 ANSON ROAD, Central

Check out more MS Excel courses in Singapore

Inspizone Logo

Microsoft PowerPoint

After completing this 2-day PowerPoint training course, participant will be able to create and deliver a professional PowerPoint presentations that explain the key points of the presented message via the use of text, graphics, and animations.

by Inspizone [Claim Listing ]
Ccisg Logo

Microsoft PowerPoint Tips, Tricks and Techniques

This is a one-day hands-on course. The trainer will walk through the topic step-by-step. You will be provided with exercise files on every topic to effectively apply the tips and techniques taught. A short Q & A session will be available after each topic.

by Ccisg [Claim Listing ]
Intuition International Logo

Microsoft MS PowerPoint and MS Word (2013, 2016, 2019 and 365) for Office and Business Presentation

Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.

by Intuition International [Claim Listing ]
Ask Training Logo

Microsoft Excel Power Query, Data Model, Power Pivot & DAX (Intro)

This course introduces Microsoft Excelā€™s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX).Ā 

by Ask Training [Claim Listing ]
Koenig-Solutions Logo

Intermediate Microsoft Excel

The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.

by Koenig-Solutions [Claim Listing ]

Ā© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy