udemy

SAS programming on SAS Macro Language


  • flag Udemy
  • student All Levels
  • database eLearning
  • earth English
  • clock 4h

About

Learn SAS Macro step by step with examples

Covered topics:

  • Create and Use Macro variables and Macro Functions: Automatic & User-Defined Macro Variables^ Displaying Macro Variable Values in the SAS Log using SYMBOLGEN^ Displaying Macro Variable Values in the SAS Log using PUT^ Macro Functions including %STR^ %UPCASE^ %SUBSTR^ %SCAN^ %SYSFUNC^ Combining Macro Variable References with Texts (text&variable
  • &variable&variable
  • &variabletext)
  • Create and Use Macro Programs: Basic Concepts: Defining^ Compiling and Calling Macros
  • Developing and Debugging Macros with options: MPRINT^ MLOGIC
  • Using Macro Parameters: Positional Parameters
  • Using Macro Parameters: Keyword Parameters
  • Using Macro Parameters: Mixed Parameters
  • Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END
  • Processing Statements Interactively With the iterative %DO statement
  • Create and Use macro variables during execution of a data step: Use macro variables during execution of a data step: Symput routine
  • Create multiple macro variables with SYMPUT and Indirect referencing with &&
  • Obtaining Macro Variable Values during DATA Step Execution with SYMGET Function
  • Create and Use macro variables during execution of a proc SQL step: Creating Macro Variables during PROC SQL Step Execution: INTO clause
  • Creating a series of related Macro Variables with the INTO Clause in Proc SQL
  • Creating one macro variable holding a Delimited List of Values with INTO clause

Description

Course Highlights:

  • 4 hours and 43 lectures full coverage on SAS Macro programming --- a SAS advanced topic

    (The contents of this course is also included in SAS Programming Advanced Certification Prep Course: 3 in 1^ which is a combined course with 4 individual courses. If you purchased SAS Programming Advanced Certification Prep Course: 3 in 1^ you don t need to purchase this course)

  • easy to follow and code-by-code explanation teaching style

  • help prepare you for the SAS Advanced Certification Exam

  • downloadable data and SAS ,programs used in the course for practice (the course materials are ONLY ,for practice^ , they are protected by copyright)

  • quizzes^ coding exercises for practice


Course summary: ,  ,  ,

The SAS macro language is often used to reduce the amount of regular SAS code. SAS macro allows us to avoid repetitive sections of code and write SAS programs that are efficient^ reusable and dynamic. SAS Macros Language has been widely used for SAS users^ especially advanced SAS users. , This course is an intermediate level course. It is designed to help you master SAS Macros Language programming skills and also help prepare you for the advanced SAS certification exam. ,

Course Contents ( 4 hours and 43 lectures):

  • SAS Macro programming introduction:

    SAS Macro Overview,

    Replacing Text Strings Using Macro Variables,

    Generating SAS Code Using Macros,

    Passing Information into a Macro Using Parameters

  • Macro variables and macro Functions:

    Automatic &, User-Defined Macro Variables^

    Displaying Macro Variable Values in the SAS Log: using SYMBOLGEN^

    Displaying Macro Variable Values in the SAS Log: using PUT^

    Using Macro Quoting Function to Mask Special Characters:%STR

    Using Macro Functions to Manipulate Character Strings: %UPCASE

    Using Macro Functions to Manipulate Character Strings: %SUBSTR

    Using Macro Functions to Manipulate Character Strings: %SCAN

    Using %SYSFUNC function to execute other SAS functions

    Combining Macro Variable References with Texts in various patterns (text&,variable, &,variable&,variable, &,variabletext) ,

    Using delimiter for a macro variable name immediately before text

  • Macro variables and macro Functions: Automatic &, User-Defined Macro Variables^ Displaying Macro Variable Values in the SAS Log: using SYMBOLGEN^ Displaying Macro Variable Values in the SAS Log: using PUT^ SAS ,Functions including %STR^ %UPCASE^ %SUBSTR^ , %SCAN^ %SYSFUNC^ , Combining Macro Variable References with Texts (text&,variable, &,variable&,variable, &,variabletext)

  • Creating and using macro variables during execution of a data step:

    Use macro variables during execution of a data step: Symput routine,

    Create multiple macro variables with SYMPUT and Indirect referencing with &,&,,

    Obtain Macro Variable Values during DATA Step Execution with SYMGET Function

  • Creating a macro variable during execution of  ,a proc sql step:

    Creating Macro Variables during PROC SQL Step Execution: INTO clause,

    Creating a series of related Macro Variables with the INTO Clause in Proc SQL,

    Creating one macro variable holding a Delimited List of Values with INTO clause

  • Creating and Using Macro Programs:

    Basic Concepts: Defining^ , Compiling and Calling Macros,

    Developing and Debugging Macros with options: MPRINT^ MLOGIC,

    Using Macro Parameters: Positional Parameters,

    Using Macro Parameters: Keyword Parameters,

    Using Macro Parameters: Mixed Parameters,

    Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%END,

    Processing Statements Interactively With the iterative %DO statement


REFERENCE: ,  , ,

  • SAS certification prep guide: advanced programming for SAS 9 by SAS Institute ,  ,

  • SAS® 9.4 Macro Language: Reference^ Fifth Edition ,

A  ,SAS software ,licence ,allows SC statistical programming to create and sell video-based SAS programming online courses.