SAS® Programming 2: Data Manipulation Techniques Training in Hong Kong

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: From €1,027+VAT
BOOK NOW
We can host this training at your preferred location. Contact us!

This course is for those who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. 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.

Before attending this course, you should be able to do the following:

  • write DATA step code to subset rows and columns, compute new columns, and process data conditionally
  • sort tables using the SORT procedure
  • apply SAS formats

This course addresses Base SAS software.

  • understand and control DATA step processing
  • create an accumulating column and process data in groups
  • manipulate data with functions
  • convert column type
  • create custom formats
  • concatenate and merge tables
  • process repetitive code
  • restructure tables.

Controlling DATA Step Processing

  • setting up for this course
  • understanding DATA step processing
  • directing DATA step output

Summarizing Data

  • creating an accumulating column
  • processing data in groups

Manipulating Data with Functions

  • understanding SAS functions and CALL routines
  • using numeric and date functions
  • using character functions
  • using special functions to convert column type

Creating Custom Formats

  • creating and using custom formats
  • creating custom formats from tables

Combining Tables

  • concatenating tables
  • merging tables
  • identifying matching and nonmatching rows

Processing Repetitive Code

  • using iterative DO loops
  • using conditional DO loops

Restructuring Tables

  • restructuring data with the DATA step
  • restructuring data with the TRANSPOSE procedure
Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
09 September 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
13 September 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
19 September 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
16 October 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
02 November 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
19 November 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
20 November 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
Classroom / Virtual Classroom
21 November 2024
Hong Kong, Kowloon, Tsuen Wan
2 Days
SAS® Programming 2: Data Manipulation Techniques Training Course in Hong Kong

Hong Kong is officially known as the Hong Kong Special Administrative Region of the People's Republic of China (HKSAR) and is a city and special administrative region of China on the eastern Pearl River Delta in South China. Hong Kong is one of the most densely populated places in the world, with over 7.5 million population. The official languages of the HKSAR are Chinese and English. Hong Kong is a highly developed territory and ranks fourth on the United Nations Human Development Index and the residents of Hong Kong have the highest life expectancies in the world.

The best time to visit Hong Kong is from September to December, since the temperatures, averaging between 19 to 28 degree Celsius. During this outdoor activities-friendly travelling season, you can take a walk along Victoria Harbour, visit the islands of Lantau, Lamma and Cheung Chau and participate in the Mid-Autumn Festival. Top choices of the tourists to visit in Hong Kong are Big Buddha statue, Wong Tai Sin Temple, Repulse Bay and the Beaches and Hong Kong Disneyland.

Explore our diverse range of IT courses, encompassing programming, software development, cyber security, data science, business skills, and Agile/Scrum. Wherever you are in Hong Kong, our seasoned instructors will bring practical training and expert knowledge to your preferred training venue.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.