SAS Advanced Programming Training Course Online Course

SAS Advanced Programming Training Course

All levels
English

Course Description

Advance SAS (Statistical Analysis System) training enables you to explore the depth and width of SAS knowledge. The training takes you to the higher level of data analysis helping enterprises in taking advantage of business intelligence. This business analyst course is divided into three sections, namely. The SAS SQL will deliver skills in accessing data using SQL. The participant will learn how to generate detailed and summary reports from a single table or multiple tables. Using SQL procedure, you will also learn how to construct sub-queries and ways to access dictionary tables. The SAS Macro Language focuses on macro processing. By using SAS macro language, the trainees will work on user-defined and automatic macro variables, automate programs, use macro functions, create data driven programs, and use system options for debugging. The SAS Programming cover Advanced Techniques and Efficiencies section provides hands-on experience on advance data look-up techniques.

See more less

What you’ll learn

Live Class Practical Oriented Training
Timely Doubt Resolution
Dedicated Student Success Mentor
Certification & Job Assistance
Free Access to Workshop & Webinar
No Cost EMI Option
Process repetitive code, rotate data, and perform table lookups using arrays.
Perform table lookups and sort data using hash and hash iterator objects.
Create numeric templates using the FORMAT procedure.
Create custom functions using the FCMP procedure.
Perform text substitution in SAS code. Use macro variables and macro functions. Automate and customize the production of...
Conditionally or iteratively construct SAS code. Write self-modifying, data-driven programs.
Query and subset data. Summarize and present data. Combine tables using joins and set operators.
Create and modify tables and views. Create data-driven macro variables using a query. Access DBMS data with SAS/ACCESS...

Covering Topics

Part-1 Accessing Data Using SQL

Lecture-1 Generate detail reports in SQL

Lecture-2 Generate summary reports in the SQL

Lecture-3 Construct sub-queries and in-line views

Lecture-4 Use SAS SQL procedure enhancements

Part-2 Macro Processing

Lecture-5 User-defined and automatic macro variables

Lecture-6 Automate programs by defining and calling macros

Lecture-7 Use macro functions

Lecture-8 Debug macros

Lecture-9 Data-driven programs using SAS Macro Language

Part-3 Advanced Techniques

Lecture-10 Process data using 1 and 2 dimensional arrays

Lecture-11 Process data using hash objects

Lecture-12 Use SAS utility procedures

Lecture-13 Use advanced functions

Curriculum

  Part-1 Accessing Data Using SQL
Live Lectures 1-4

  Lecture-1 Generate detail reports in SQL
Live Lecture 
·      Use PROC SQL to perform SQL queries

·      Select columns in a table with a SELECT statement and FROM clause

·      Create a table from a query result set

·      Create new calculated columns

·      Assign an alias with the AS keyword

·      Use case logic to select values for a column

·      Retrieve rows that satisfy a condition with a WHERE clause

·      Subset data by calculated columns

·      Join tables - inner joins, full joins (coalesce function), right joins, left joins

·      Combine tables using set operators - union, outer union, except, intersect

·      Sort data with an ORDER BY clause

·      Assign labels and formats to columns

·      Practical Exercise

  Lecture-2 Generate summary reports in the SQL
Live Lecture 
·      Summarize data across and down columns using summary functions (AVG, COUNT, MAX, MIN, SUM)

·      Group data using GROUP BY clause

·      Filter grouped data using HAVING clause

·      Eliminate duplicate values with the DISTINCT keyword

·      Practical Exercise

  Lecture-3 Construct sub-queries and in-line views
Live Lecture 
·      Subset data by using non-correlated subqueries

·      Reference an in-line view with other views or tables (multiple tables)

·      Practical Exercise

  Lecture-4 Use SAS SQL procedure enhancements
Live Lecture 
·      Use SAS data set options with PROC SQL (KEEP=, DROP=, RENAME=, OBS=)

·      Use PROC SQL invocation options (INOBS=, OUTOBS=. NOPRINT, NUMBER)

·      Use SAS functions (SCAN, SUBSTR, LENGTH)

·      Access SAS system information by using DICTIONARY tables (members, tables, columns)

·      Use the CALCULATED keyword

·      Practical Exercise

  Part-2 Macro Processing
Live Lecture 5-9

  Lecture-5 User-defined and automatic macro variables
Live Lecture 
·      Define and use macro variables

·      Use macro variable name delimiter. (.)

·      Use INTO clause of the SELECT statement in SQL to create a single variable or a list of variables

·      Use the SYMPUTX routine in a DATA Step to create a single variable or a list of variables

·      Control variable scope

·      Practical Exercise

  Lecture-6 Automate programs by defining and calling macros
Live Lecture 
·      Define a macro using the %MACRO and %MEND statements

·      Calling a macro with and without parameters

·      Document macro functionality with comments

·      Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements or iterative %DO statements

·      Use the SAS AUTOCALL facility to permanently store and call macros

·      Practical Exercise

  Lecture-7 Use macro functions
Live Lecture 
·      Use macro functions. (%SCAN, %SUBSTR, %UPCASE)

·      Use macro quoting functions. (%NRSTR, %STR)

·      Use macro evaluation functions. (%SYSEVALF)

·      Use %SYSFUNC to execute DATA step functions within the SAS Macro Language

·      Practical Exercise

  Lecture-8 Debug macros
Live Lecture 
·      Trace the flow of execution with the MLOGIC option

·      Examine the generated SAS statements with the MPRINT option

·      Examine macro variable resolution with the SYMBOLGEN option

·      Use the %PUT statement to print information to the log

·      Practical Exercise

  Lecture-9 Data-driven programs using SAS Macro Language
Live Lecture 
·      Create a series of macro variables

·      Use indirect reference to macro variables. (&&, etc.)

·      Incorporate DICTONARY tables in data driven macros

·      Generate repetitive macro calls

·      Practical Exercise

  Part-3 Advanced Techniques
Live Lectures 10-13

  Lecture-10 Process data using 1 and 2 dimensional arrays
Live Lecture 
·      Define and use character arrays

·      Define and use numeric arrays

·      Create variables with arrays

·      Reference arrays within a DO loop

·      Specify the array dimension with the DIM function

·      Define arrays as temporary arrays

·      Load initial values for an array from a SAS data set

·      Practical Exercise

  Lecture-11 Process data using hash objects
Live Lecture 
·      Declare hash and hash iterator objects

·      Dataset argument

·      Ordered argument

·      Multidata argument

·      Use hash object methods

·      definekey()

·      definedata()

·      definedone()

·      find()

·      add()

·      output()

·      Use hash iterator object methods

·      first()

·      next()

·      last()

·      prev()

·      Use hash objects as lookup tables

·      Use hash objects to create sorted data sets

·      Use hash iterator objects to access data in forward or reverse key order

·      Practical Exercise

  Lecture-12 Use SAS utility procedures
Live Lecture 
·      Specify a template using the PICTURE statement within the FORMAT Procedure

·      Specify templates for date, time, and datetime values using directives

·      Specify templates for numeric values using digit selectors

·      PICTURE statement options: round, default, datatype, multiplier, prefix

·      Create custom functions with the FCMP procedure

·      Create character and numeric custom functions with single or multiple arguments

·      Create custom functions based on conditional processing

·      Use custom functions with the global option CMPLIB=

·      Practical Exercise

  Lecture-13 Use advanced functions
Live Lecture 
·      Finding strings or words with the FINDC/FINDW functions

·      Counting strings or words with the COUNT/COUNTC/COUNTW functions

·      Retrieve previous values with the LAG function

·      Regular expression pattern matching with PRX functions

·      Practical Exercise

  Case Studies

Frequently Asked Questions

The professionals with experience in SAS programming and basic understanding of SQL can undergo this training.

The course offers a variety of online training options, including: Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.

Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.

If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.

The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.