Base SAS
Title | Level | Training Formats |
---|---|---|
FANS Membership
FANS is a member driven SAS users group. Attending FANS gives you the opportunity to network with your peers, while enhancing your skills and knowledge about the latest SAS technology. The FANS membership includes pre-paid ticket/discount to FANS network events, FANS Conferences and International Conferences. Membership Packages can be viewed here . Prices: FANS Company Kr. 22.000 - EUR 2500 FANS Personal Kr. 3.500 - EUR 400 FANS Partner Kr. 33.000 - EUR 3900 |
0 No level | ![]() ![]() ![]() ![]() ![]() |
SAS Programming Certification Fast Track
This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. This course is also for those who need to learn data manipulation techniques using the SAS DATA step and SAS procedures to access, transform, and summarize data.It is a prerequisite to many other SAS courses. |
0 No level | ![]() ![]() ![]() ![]() ![]() |
The Magic of Compelling Reports and Visualizations with SAS
Whether you’re a SAS programmer or a SAS Visual Analytics user, we’ve hand-picked a range of topics to advance your report development and data visualisation skills. With three conference streams to choose from and sessions delivered by our expert trainers, you’ll also have the chance to get hands-on experience, gain extended access to your own SAS environment and try out the techniques you’ve seen. |
0 No level | ![]() ![]() ![]() ![]() ![]() |
SAS Programming Introduction: Basic Concepts
This course teaches you how to write simple SAS programs. The course is a subset of the SAS Programming 1: Essentials course. If you do not plan to write SAS programs and prefer a point-and-click interface to SAS, you should attend the SAS Enterprise Guide 1: Querying and Reporting course. |
1 Beginner | ![]() ![]() ![]() ![]() ![]() |
Free SAS Lab Day
Visit SAS Institute and work in our Lab. Use this opportunity to join us at SAS and bring your SAS work and SAS-programs. You will meet our teachers and you can discuss your questions with SME (subject matter experts) Our programming curriculum and courses has been revised in 2018 and the content is now more compact. The programming 1 course has been shortened from 3 to 2 days and many of our students like the structure of the course, but they also think that there is too little time for exercises. Therefore, we would like to give our students the possibility to come to SAS for an extra free day. You can work with our programming case or just work with the exercises from the programming course. If you have own problems or question you can bring them this day. Length: You are welcome to stay 1-2 hours or the whole day |
1 Beginner | ![]() ![]() ![]() ![]() ![]() |
SAS Programming Series
Workshops with modern development environments and tools SAS® Enterprise Guide®, SAS® Studio, SAS® Graph, ODS and Reports Over the years our teachers at SAS have received questions about extra functionality when writing programs in SAS. All these questions are the foundation for these workshops we have created. These workshops will give you new tools and knowledge that will help you write SAS-programs in a more modern way. Content: Workshop 1- FCMP Workshop 2 - Filename Workshop 3 - PROC IML basics and R interaction Workshop 4 - Advanced data step features Workshop 5 - ODS Workshop 6 - Macro Length: 3 hours each Price: For onsite workshops at your location, KR 6.000,- / EUR 800 ex. VAT, pr. Workshop For public scheduled workshops, KR 1.000,- / EUR 130 ex. VAT, pr. person, pr. session |
1 Beginner | ![]() ![]() ![]() ![]() ![]() |
Introduction to Statistical Concepts ![]() ![]() ![]() A good starting course for people that need to know more about statistical concepts |
1 Beginner | ![]() ![]() ![]() ![]() ![]() |
SAS Programming 1: Essentials ![]() This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the SAS Enterprise Guide 1: Querying and Reporting course. |
2 Fundamental | ![]() ![]() ![]() ![]() ![]() |
Strategic Planning and Decision-Making: Powered by SAS ![]() This course helps students learn how basic statistical techniques can be used to better inform strategic business and decision-making challenges. The focus of the course is to learn the key tools and tactics of a corporate strategist/strategic planner. However, woven into the course are key analytics, powered by SAS, that can enable strategists to be more data driven and objective in terms of options, pros/cons, recommendations, and contingency plans. |
2 Fundamental | ![]() ![]() ![]() ![]() ![]() |
SAS Programming Fast Track
This course provides you with thorough understanding of the Base SAS programming language. You get the opportunity to work with basic access to data, manipulation of data as well as presentation of data from SAS Enterprise Guide, SAS Studio or Display Manager System. You will learn how to master the most important techniques within data step programming, load data, manage data and organize data efficiently in SAS data sets. This course combines the course content of the two courses SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques. |
2 Fundamental | ![]() ![]() ![]() ![]() ![]() |
SAS Programming for R Users ![]() ![]() This course is designed for experienced R users who want to transfer their programming skills to SAS. Emphasis will be placed on programming and not statistical theory or interpretation. Students of this course should have knowledge of plotting, manipulating data, iterative processing, creating functions, applying functions, linear models, generalized linear models, mixed models, stepwise model selection, matrix algebra, and statistical simulations. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS SQL 1: Essentials
This course teaches you how to process SAS data using Structured Query Language (SQL). |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Programming 2: Data Manipulation Techniques
This course is for those who need to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the SAS Programming 1: Essentials course and is not recommended for beginning SAS software users. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Propensity Score Matching, Adjustment, and Randomized Experiments ![]() This course focuses on testing whether the results of a program can be attributed to a given cause. For example, was the increase in customer sales due to mailing of sales flyers? Was the health improvement due to the new medication? What conclusion can be drawn? The following cases are examined: randomized controlled experiments and observational studies that require adjustment to reduce bias by using propensity score analysis through either propensity score matching or propensity score adjustment. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Developing Custom Tasks for SAS Enterprise Guide ![]() |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Functions by Example ![]() Ever spent valuable time writing complex code only to later find a function that would have done the job for you? Discover the plethora of practical SAS functions that you haven't seen in other SAS programming courses, and start resolving your everyday programming problems more quickly and efficiently. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Best Practices in Cluster Analysis for Customer Relationship Management (CRM) ![]() This course focuses on best practices when doing cluster analysis, particularly when applied to CRM. However, the techniques presented are easily applicable to other analytic fields. Students with different backgrounds and skill levels will benefit from the course, which explores theory, practice, and application. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Data Cleaning Techniques ![]() This course, which was completely rewritten to be compatible with the third edition of the book Cody's Data Cleaning Techniques Using SAS, will help greatly speed up the process of detecting and correcting errors in both character and numeric data. In addition, there are sections on standardizing data and using Perl regular expressions to ensure that character values conform to a specific pattern (such as ZIP codes, phone numbers, and email addresses). Although the course concentrates on methods of identifying data errors, it also teaches some programming techniques that might be new to you. For example, by using some of the latest SAS functions, you can convert a phone number in just about any form into a standard form, in only two SAS statements! The course teaches several methods of detecting errors in numeric data including range checking as well as several methods of automatic outlier detection. There are chapters devoted to data that involves multiple observations per subject, SAS dates, and projects that include multiple data sets. The class closes with a demonstration of an innovative process that leverages integrity constraints and audit trails to detect and programmatically clean dirty data before it even gets into your analysis data set. All students taking this class are presented with either a printed version or PDF version of the new Data Cleaning book and are given access to dozens of macros that will greatly speed up the laborious process of cleaning your data. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Social Network Analytics ![]() This course discusses how to leverage social networks for analytical purposes. Obviously, when we say "social networks," many people think of Facebook, Twitter, Google+, LinkedIn, and so on. These are all examples of networks that connect people using either friendship or professional relationships. In this course, we zoom out and provide a much more general definition of a social network. In fact, we define a social network as a network of nodes that are connected using edges. Both nodes and edges can be defined in various ways, depending on the setting. This course starts by describing the basic concepts of social networks and their applications in marketing, risk, fraud, and HR. It then defines various social metrics and illustrates how they can be used for community mining. The course also discusses how social networks can be used for predictive analytics. The course provides a sound mix of both theoretical and technical insights, as well as practical implementation details, and is illustrated by several real-life cases. The instructor extensively reports on both his research and consulting experience in the field. References to background material such as selected papers, tutorials, and guidelines are also provided. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Establishing Causal Inferences: Propensity Score Matching, Heckman's Two-Stage Model, Interrupted Time Series, and Regression Discontinuity Models ![]() This course introduces some methods commonly used in program evaluation and real-world effectiveness studies, including two-stage modeling, interrupted time-series, regression discontinuity, and propensity score matching. These methods help address questions such as: Which medicine is more effective in the real world? Did an advertising program have an impact on sales? More generally, are the changes in outcomes causally related to the program being run? |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS High-Performance Markdown Optimization Analytics and Modeling
This course is for those responsible for demand modeling within a retail organization in which SAS High-Performance Markdown Optimization has been implemented. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Learning Conference - For SAS Programmers & SAS Enterprise Guide Users
Overview The SAS Enterprise Guide Learning Conference gives all SAS Enterprise Guide users the opportunity to share experiences, learn new approaches, best practices, and more. In various learning sessions and workshops, you can work with the software and learn new ways to use SAS Enterprise Guide and SAS programming. You can also bring your own tasks and discuss solutions with a specialist in a personal conversation. We have workshops in three different areas: |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS SQL 2: Working with Databases
The purpose of this course is to access your DBMS’s via Proc sql. We look at all kinds of combinations of SAS and DBMS’s, look at performance and options to set up to make your queries run optimal. There will be a combination of teaching and exercises. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS® Report Writing and Graphics
This course teaches you how to create reports using Base SAS procedures. You will learn how to create text reports as well as creating graphics using ODS Graphics. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel
This course presents techniques for exporting SAS data sets or reports from SAS to Excel. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Building and Solving Optimization Models with SAS/OR
This course focuses on formulating and solving mathematical optimization models using the OPTMODEL procedure, from inputting data to interpreting output and generating reports. The course covers linear, integer, mixed integer, and nonlinear programming problems, with an emphasis on model formulation and construction. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS SQL Methods and More
This class teaches you how to improve the performance of SQL queries, and how to troubleshoot and tune other SAS processes that access relational database tables using SAS/ACCESS interfaces. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Introduction to SAS/ACCESS Interface to Teradata
This course teaches you how to read Teradata tables in Teradata using the SAS 9.4 SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata and to query a single Teradata table and multiple Teradata tables. You also learn efficiency techniques and options for optimizing data access performance. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Exploring SAS Studio for SAS Programmers
This course provides an introduction to SAS Studio for experienced SAS programmers. SAS Studio is an interface that enables users to write and submit SAS programs and use snippets and tasks to generate SAS code. The self-study e-learning includes:
|
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Certification Review: SAS 9.4 Base Programming Performance-Based Exam
This course provides a review of the majority of topics in the SAS 9.4 Base Programming Performance-Based Exam. It addresses the four exam content areas: Accessing and Creating Data Structures, Managing Data, Generating Reports and Output, and Handling Errors. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Federation Server: Accessing and Virtualizing Enterprise Data
SAS Federation Server makes it easier for business users to access secure data for reporting and analysis. It provides a virtual layer or view, giving users the appropriate level of control without physically moving data. This frees up IT staff to focus on other tasks by giving them a simple method of sharing data using a centralized, governed security layer. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Hadoop Data Management with Hive, Pig, and SAS
In this course, you use processing methods to prepare structured and unstructured big data for analysis. You learn to organize this data into a variety of Hadoop distributed file system (HDFS) storage formats for processing efficiency using Apache Hive and Apache Pig. You also learn SAS software technologies that integrate with Hive and Pig and how to leverage these open source capabilities by programming with Base SAS and SAS/ACCESS Interface to Hadoop. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Report Writing
This course teaches you how to create tabular reports using the REPORT and TABULATE procedures. You also learn how to enhance your reports using the Output Delivery System (ODS). The self-study e-learning includes:
|
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Introduction to SAS and Hadoop
This course teaches you how to use SAS programming methods to read, write, and manipulate Hadoop data. Base SAS methods that are covered include reading and writing raw data with the DATA step and managing the Hadoop file system and executing Pig code from SAS via the HADOOP procedure. In addition, the SAS/ACCESS Interface to Hadoop methods that allow LIBNAME access and SQL pass-through techniques to read and write Hadoop Hive table structures are discussed. Although not covered in detail, a brief overview of additional SAS and Hadoop technologies, including executing DS2 in Hadoop with the SAS Code Accelerator for Hadoop and using Hadoop data sources for the distributed in-memory analytics platform of SAS Viya, is included. This course is included in the Expert Exchange on Hadoop: Using SAS/ACCESS service offering to configure SAS/ACCESS Interface to Hadoop or SAS/ACCESS Interface to Impala to work with your Hadoop environment. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Programming 3: Advanced Techniques
This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS Programming 2: Data Manipulation Techniques course. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
SAS Macro Language 1: Essentials
This course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
Introducing SAS Enterprise Guide and SAS Programming
This course introduces SAS Enterprise Guide as an interface to write and submit code, as well as use some of the basic tasks to point-and-click to generate queries and reports. This course will focus on queries and data processing and will also introduce how to write basic SAS programs. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
SAS® Advanced DATA Step and Macro Techniques
This new special course is for people that have basic knowledge about SAS programming, such as data steps, proc sql, the macro language, but want to learn more and get a deeper understanding for SAS programming. The course will focus on the data step, and corresponds to the course SAS Programming 3: Advanced Techniques and Efficiencies and SAS® Macro Language 2: Advanced Techniques. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
DS2 Programming Essentials with Hadoop
This course focuses on DS2, a fourth-generation SAS-proprietary language providing modern programming techniques and structures for parallel processing and preparing large data for analysis. A brief introduction to Hadoop, including a comparison to traditional relational databases, is included. If you are a programmer/data scientist who wants training and hands-on experience manipulating Hadoop data using powerful SAS algorithms, this class is for you. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
High-Performance Data Manipulation with SAS DS2
This course focuses on learning DS2, a fourth-generation SAS language for advanced data manipulation. DS2 blends DATA step and SQL syntax with modern programming structures, and enables parallel processing in Base SAS as well as massively parallel processing environments such as Hadoop and SAS Viya Cloud Analytic Services (CAS). A brief introduction to SAS Viya is included. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
SAS Macro Language 2: Advanced Techniques
This course covers macro quoting functions, macro storage, and macro techniques for advanced data access, table lookup operations, advanced parameter validation, and macro windows. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |
Feature Engineering and Data Preparation for Analytics
This course introduces programming techniques to craft and feature engineer meaningful inputs to improve predictive modeling performance. In addition, this course provides strategies to preemptively spot and avoid common pitfalls that compromise the integrity of the data being used to build a predictive model. This course relies heavily on SAS programming techniques to accomplish the desired objectives. The self-study e-learning includes:
|
4 Expert | ![]() ![]() ![]() ![]() ![]() |