SAS Base Programmer

SAS Programming 1: Data Manipulation Techniques


Learn Modern Technology This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data.
  • Essentials
    • The SAS programming process
    • Using SAS programming tools
    • Understanding SAS programming syntax
  • Accessing Data
    • Understanding SAS data structures
    • Accessing data through libraries
    • Importing data into SAS
  • Exploring and Validating Data
    • Data Exploration
    • Filtering and formatting data
    • Arranging data
  • Preparing Data
    • Reading and filtering data
    • Computing new columns
    • Conditional processing
  • Analysing and Reporting on Data
    • Enhancing reports with titles, footnotes, and labels
    • Creating frequency reports
    • Creating summary statistics reports
  • Exporting Results
    • Exporting data and reports
  • Using SQL in SAS
    • Using SQL
    • Joining tables using SQL in SAS
Anyone starting to write SAS programs
  • No prior SAS experience is needed
  • Experience using computer software
  • Understand file structures and system commands on your operating systems
  • Access data files on your operating systems
Enter the exciting work of data analytics and business intelligence by learning to
  • Use SAS to write and submit SAS programs
  • Access SAS, Microsoft Excel, and text data
  • Explore and validate data
  • Prepare data by creating subsets of rows and computing new columns
  • Analyze and report on data
  • Export data and results to Excel, PDF, and other formats
  • Use SQL in SAS to query and join tables.
Delivery Method : Classroom Training / Live Web / Self Learning
Duration : 3 days
Level : Fundamental
Languages : English


SAS Programming 1: Data Manipulation Techniques


Learn Modern Technology This course will help the beginners to go deeper into the technology and learn exciting word of data manipulation using Base SAS tool.
  • Controlling DATA Step Processing
  • Accessing Data
  • Summarizing Data
  • Manipulating Data with Functions
  • Creating Custom Formats
  • Combining Tables
  • Processing loops
  • Restructuring tables
Business analysts and SAS programmers
  • Ability to use DATA code to subset rows and columns, compute new columns, and process data conditionally
  • Ability to use SORT procedure
  • Knowledge on applying SAS formats
Enter the exciting work of data analytics and business intelligence by learning to
  • Create an accumulating column and process data in groups
  • Manipulate data with functions
  • Convert column type to other formats
  • Create custom formats
  • Concatenate, merge and restructure tables
  • Using loops
Delivery Method : Classroom Training / Live Web / Self Learning
Duration : 3 days
Level : Intermediate
Languages : English


Enquire Now – Smartree