£30.00
(incl. VAT):
Order
|
Contact us |
In this module you will learn how to transform character data using a variety of useful functions including:
SUBSTR, SCAN, TRIM, COMPRESS, LEFT, RIGHT, CATX, INDEX, FIND, UPCASE, LOWCASE, PROPCASE and TRANWRD
Each function is introduced in standard syntax form, illustrating both the required arguments and any optional arguments which are available with an explanation of their purpose.
This is followed by an example of each function in action using data from a simple dataset.
There are also mini quizzes and comprehensive exercises throughout to help assess and reinforce your learning.
By the end of this module you will be able to describe how functions are used to perform character transformation.
This module is aimed at those who are new to the Language of SAS.
You should already have:
For the hands-on practice activities you will need access to an environment that runs the programming Language of SAS. On our courses, we signpost you to some of the free tools available.
Check out the link below to review system requirements:
The following reference modules are included to support your learning:
Introduction to SAS Programming
Learning Objective: Explain what the Language of SAS is used for and by whom.
Basic Concepts
Learning Objective: Explain how the Language of SAS is used to access, manage, analyse and present data.
Investigating SAS datasets
Learning Objective: Define how to investigate datasets in the Language of SAS using two types of Procedure.
Programming Concepts
Learning Objective: Describe the key programming concepts within the Language of SAS.
Data Step Processing
Learning Objective: Explain how the two phases of Data Step Processing work to create new datasets and variables.
Selecting Variables and Observations
Learning Objective: Define Variables and Observations to be read from and written to datasets.