We can host this training at your preferred location. Contact us!

This course is for SAS programmers who prepare data for analysis.

The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation.

Who should attend:

Experienced SAS programmers

This course is not appropriate for beginning SAS software users.

Before attending this course, you should have at least nine months of SAS programming experience and should have completed the SAS Programming 2: Data Manipulation Techniques course. Specifically, you should be able to do the following:

understand your operating system file structures and perform basic operating system tasks
understand programming logic concepts
understand the compilation and execution processes of the DATA step
use different varieties of input to create SAS data sets from external files
use SAS software to access SAS libraries
create and use SAS date values
read, concatenate, merge, match-merge, and interleave SAS data sets
use the DROP=, KEEP=, and RENAME= data set options
create multiple output data sets
use one-dimensional array processing and DO loops to process data iteratively
use SAS functions to perform data manipulation and transformations
use the FORMAT procedure to create user-defined formats.

This course addresses Base SAS software.

This course is appropriate for students who are using SAS 9 software.

Learn how to:

compare various SAS programming techniques that enable you to benchmark computer resource usage
control memory, I/O, and CPU resources
create and use indexes
combine data horizontally
use hash and hiter DATA step component objects and arrays as lookup tables
compress SAS data sets
sample your SAS data sets
create and use SAS data views
safely reduce the length of numeric variables
create user-defined functions and informats.

Introduction

overview of SAS Foundation
course logistics
creating the course data

Efficient SAS Programming

identifying computer resources related to efficiency

Controlling I/O Processing and Memory

SAS DATA step processing
controlling I/O
reducing the length of numeric variables
compressing SAS data sets
using SAS views

Accessing Observations

access methods
accessing observations by number
creating an index
using an index

DATA Step Arrays

introduction to lookup techniques
one-dimensional arrays
multidimensional arrays
loading a multidimensional array from a SAS data set

DATA Step Hash and Hiter Objects

introduction
hash object methods
loading a hash object from a SAS data set
DATA step hiter object

Combining Data Horizontally

DATA step merges and SQL procedure joins
using an index to combine data
combining summary and detail data
combining data conditionally

User-Defined Functions and Formats

user-defined functions
user-defined formats

Learning More

areas of support from SAS
other courses to consider

Combining Raw Data Files Vertically

combining raw data files vertically

SAS® Programming 3: Advanced Techniques Training Course in Finland

Finland is a country located in northern Europe. Helsinki is the capital and largest city of the country. The majority of the people are Finns but there is also a small Lapp population in Lapland, where the country is famous for the Northern Lights. Finland's national languages are Finnish and Swedish.

Known for its vast forests, lakes, and natural beauty, Finland is one of the world's largest producers of forest products, such as paper, pulp, and lumber. One of the world's largest sea fortresses Suomenlinna, Rovaniemi with the "White Nights", dogsled safaris and of course the Northern Lights are what makes Finland so popular for tourists. Finland is one of the best places in the world to see the Northern Lights and attracts millions of tourists during its seasons.

Finland is home to a thriving technology industry and is widely recognized as one of the world's leading technology hubs. Companies such as Nokia and Rovio (creator of the popular game Angry Birds) are based in Finland. Some of the key factors that have contributed to Finland's success in technology include; strong investment in research and development, a highly educated workforce and fundings.

Finland has a strong educational system, and is widely regarded as one of the world's most literate countries. In fact, Finland's literacy rate is one of the highest in the world, and its students consistently perform well in international tests of math and reading ability.

Also, as a pioneer in environmental sustainability, Finland is known for its efforts to reduce its carbon footprint and promote clean energy. This Nordic country is also famous for its unique and distinctive cultural heritage, including its traditional folk music and its elaborate traditional costumes.

Helsinki, Finland's capital city, is the country's business center. Helsinki is Finland's largest city, and it is home to many of the country's major corporations and organizations, including many of the country's leading technology firms. The city is also a commercial, trade, and financial center, as well as one of the busiest ports in the Nordic region.

Take advantage of our diverse IT course offerings, spanning programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our knowledgeable instructors will provide you with practical training and industry insights, delivered directly to your chosen venue in Finland.

SAS® Programming 3: Advanced Techniques Training in Finland

Who should attend:

Upcoming Trainings

SAS® Programming 3: Advanced Techniques Training in Finland

Who should attend:

Prerequisites

What You Will Learn

Outline

Upcoming Trainings