SAS Training by Reviewing and Solving Certificate Questions

BY
Udemy

Mode

Online

Fees

₹ 1999

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 1,999
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Course introduction

  • Course introduction : content, resources and approach
  • SAS installation, version and environment

Walk through each question by reviewing SAS

  • Teaching approach (with PDF downloadable)
  • Know SAS library and current folder
  • Learn data type, missing values in SAS data sets
  • Learn set statement, _n_ and logical operators in SAS
  • Know if statement to restrict or subset SAS data sets
  • Understand output statement, do loop structure
  • Know page number setting for SAS procedure output
  • Learn SAS format to display data as you want
  • How to input data from data step using position input
  • Learn data input using DSD, how to input missing values
  • How to use filename statement in SAS for data input and output
  • Rename methods and how it affects other operations
  • About date type, data conversion, functions and informat
  • Understand data line holding, strongly holding and training sign @
  • Understand holding, strong holding and trailing
  • Learn in operator, if then statement
  • Learn output statement, merge statement
  • Understand set statement, (in=) and if statement
  • Test sort and merge data sets in SAS
  • Learn relational merging data sets
  • Learn sorting data, nodupkey option
  • Understand ranuni() function and random sampling
  • Learn usages of set statement in setting multiple data stes
  • Setting multiple data sets in one data step
  • Learn date type data and operations
  • Learn date format and date operations
  • Concatenate string, date type, input() and put() functions
  • Compbl() function, do loop and output statement
  • Test date function -- weekday()
  • Understand how to use informat in reading date and missing values
  • Know how to save observations into external files
  • data _null_, put statement, infile statement and DSD option
  • Test variable expression, logical expression
  • About usages of the keep statements
  • Learn the output about proc contents
  • Learn statements and options in proc datasets
  • Understand functionality of proc flist
  • Delete data in the library
  • Understand array and data transformation
  • Learn SAS array and its relationship with variables
  • Extract variables with a specified data type using array
  • Learn how to transform data set using data step
  • Use array and summarized function in data step
  • Understand usage of SAS array in data step
  • About proc sort and its nodupkey option
  • Know how to use data step to get cumulative data
  • Knowledge about do loop, output and return statements
  • Know how to use _error_ and error handling method in SAS
  • Understand merging data sets by consistent order
  • Learn round() function in data step
  • Understand missing value and logical operation
  • How to use lag and dif function in SAS
  • Understand date format and relationship with string
  • Test how to use proc format to create format used in data step
  • Learn how to create format based on numerical range
  • Test your understanding about proc means
  • Understand by and class statements in proc means
  • About debug option and usage in data step
  • Data conversion: substr(), input() and put() functions
  • Understand the concept about SAS macro _error_
  • Define valid library
  • Read data based on position, informat and modifier
  • Understand firstobs, obs options in SAS data step and procedures
  • Understand firstobs and obs options (2)
  • Read raw data into SAS table from external files
  • Test output, _n_ and if..else statements in one data step
  • Know SAS format definition and location
  • Test how to use do while and break condition
  • Understand how to use label statement in data step
  • Know how to apply cat() and catx() functions
  • Learn string function: finding positions in a string
  • Learn how to split data based on coditions
  • Use array and create missing values
  • Use array and create missing values (2)
  • Use array to create variables in data step
  • Understand logical conditions in if statements
  • Learn how to apply multiple filters based on several if statements
  • Understand date, character types in data step
  • Learn how to apply universal string matching to query data
  • Apply proc means to create descriptive statistics and output
  • Apply proc means to create descriptive statistics and output (2)
  • Apply proc freq and obtain the intended output
  • Create two ways frequency cross tab and intended output
  • Understand options in proc report
  • How to apply ODS in SAS to create intended output
  • Getting resulting table based on if then filters
  • Use if...else if statement
  • Debug syntax errors in data step
  • Understand trailing symbols used to read data
  • Data type conversion using put() function
  • Data tytpe conversion (2)
  • Keep and drop variables in data step
  • Use single trailing to conditionally read data
  • Transpose data, create cumulative data using retain statement
  • About data error and log
  • Correctly use firstobs and obs option in SAS procedures
  • Apply composite functions in data step
  • Apply eof option in SAS data step
  • How to split data in one column when reading raw data
  • Understand output containing descriptive statistics in proc means
  • Understand how SAS variables are listed
  • Learn how to merge two tables with different manners

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses