£1,350.00 (ex. VAT):
As an existing SAS programmer, Newtyne’s SAS to Python conversion course is perfect for you.
It will enable you to transfer your understanding and experience of working with the Language of SAS to develop meaningful programs and achieve the required results in Python.
Completion of this course will help you attain PCEP professional certification from the Python Institute.
Written by SAS and Python experts, this course has been designed for those with prior knowledge of the Language of SAS and will provide direct comparisons to the Language of SAS throughout the course to provide context aiding learning and skills transfer.
There are mini quizzes and hands-on practices exercises throughout to help assess and reinforce your learning with access to FREE bonus material.
Once you have completed the learning you will have an opportunity to enrol to join a live online Masterclass with one of our trainers.
By the end of this course, you will be able to:
This course is delivered using a blended learning approach of self-paced eLearning and live online masterclass with an experienced instructor.
This course is aimed at SAS Programmers and/or Analysts who wish to learn Python in the context of their SAS Language knowledge. You should already have:
For the hands-on practice activities in the course, you will need access to an environment that runs Python. On our course we signpost you to Anaconda, a free open source platform, to run Python via Jupyter Notebook.
Anaconda must have a suitable operating platform installed:
Full system requirements can be found here.
Introduction to Python
Learning Objective: Explain the history of Python and its common uses today
Learning Objective: Explain what an Integrated Development Environment is and describe how use Jupyter Notebook.
Learning Objective: Describe the basic concepts of Python syntax.
Learning Objective: Describe variable naming conventions, storage concepts and data types used in Python.
Everything is Data
Learning Objective: Explain what data objects are and how they relate to a class.
Learning Objective: Know where and how to access help in Python
Lists, Tuples & Dictionaries
Learning Objectives: How to initialise and use lists, tuples and dictionaries
Learning Objectives: Explain the similarities between Python user-defined functions and SAS macros
Learning Objective: Explain the similarities between Python and SAS loop methods
Learning Objective: Using conditional logic within your Python code
Learning Objectives: Explain the benefits of Python modules and how to use them
Learning Objectives: Explain the similarities between Python and SAS date and time objects
Learning Objectives: Describe the similarities between SAS and Python pandas
Learning Objectives: Using pandas to create DataFrames
Learning Objective: How to importing and export pandas DataFrames
Learning Objective: How to investigate the metadata of a pandas DataFrame
Learning Objective: How to investigate the data portion of a pandas DataFrame
Querying & Updating Data
Learning Objective: Using the loc[I,C] property to query and update a pandas DataFrame
Iteration (live online class)
Learning Objective: Using iteration techniques to update a pandas DataFrame
Branches in a Pandas Context
Learning Objective: Using suitable techniques to update a pandas DataFrame cell based on conditional logic
Learning Objective: How to identify and dealing with missing data
Learning Objective: How to sort pandas DataFrames
Combining Data Vertically
Learning Objective: How to combine pandas DataFrames vertically
Combining Data Horizontally
Learning Objective: How to combine pandas DataFrames horizontally