- Home
- SAS Programming 2: Data Manipulation Techniques
SAS Programming 2: Data Manipulation Techniques
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.
Power up your staff’s skills and boost your business
About Program
Format of Training
Training Features
Course Curriculum
Course Fees
Watch
ContactAbout Program
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.
This course can help prepare you for the following certification exam(s): SAS Base Programming for SAS 9, SAS Certified Clinical Trials Programmer Using SAS 9.
Format of Training
Taught by certified instructors at high-tech facilities across the country
- A SAS expert at your side.
- Focused learning away from the office
- Networking opportunities
- State-of-the-art facilities
- Electronic course notes downloadable to your device and permission to print
- Business Knowledge Series: in-depth courses on the latest business topics
- We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.
All the benefits of the classroom without the travel
- Join the classroom right from your desktop
- Led by an expert instructor who can virtually look over your shoulder
- Ask questions and get answers in real-time
- Access the latest software via a virtual lab
- Receive 20 business days' access to a recording of your course
- Discuss, share, exchange ideas with participants from different countries
Training Features
- control SAS data set input and output
- combine SAS data sets
- summarize, read, and write different types of data
- perform DO loop and SAS array processing
- transform character, numeric, and date variables.
Course Curriculum
Introduction
- course logistics
- creating course data file
Controlling Input and Output
- writing observations explicitly
- writing to multiple SAS data sets
- selecting variables and observations
Summarizing Data
- creating an accumulating total variable
- accumulating totals for a group of data
Reading Raw Data Files
- reading raw data files with formatted input
- controlling when a record loads
Data Transformations
- manipulating character values
- manipulating numeric values
- converting variable type
Debugging Techniques
- using the PUTLOG statement
Processing Data Iteratively
- DO loop processing
- conditional DO loop processing
- SAS array processing
- using SAS arrays
Restructuring a Data Set
- rotating with the DATA step
Combining SAS Data Sets
- using data manipulation techniques with match-merging
Creating and Maintaining Permanent Formats
- creating permanent formats
Other SAS Languages
- an overview of other languages
- using the SQL procedure
- the SAS macro language
Learning More
- SAS resources
- next steps
Course Fees
Are you ready to take on SAS Programming 2: Data Manipulation Techniques?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
SAS® Academy for Clinical Programming SAS® Academy for Data Science Introduction to CDISC Domains & Standards Data Visualization Machine Learning & AI Data Management Data Analytics Predictive Business AnalystCertification
SAS Certified Base Programmer for SAS 9 SAS® Certified Big Data Professional Using SAS®9 Predictive Modeling certification exam SAS® Certified Clinical Trials Programmer Using SAS®9 SAS® Certified Data Scientist SAS® Certified Platform Administrator for SAS®9
© 2024 Epoch Research Institute India Pvt. Ltd. All Rights Reserved. All Contents Shown from SAS are sole propriety of © SAS Institute Inc. All Rights Reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Adobe and the Acrobat logo are trademarks of Adobe Systems Incorporated.