Mobile Number:
+91 9030070095
Email Address :
career@igcp.co.in

SAS/MACROS

UNDERSTANDING THE CONCEPTS AND FEATURES OF MACRO PROGRAMMING
  • WHAT IS SAS MACRO FACILITY?
  • WHAT ARE THE ADVANTAGES OF SAS MACRO FACILITY?
  • WHERE CAN THE SAS MACRO FACILITY BE USED?
  • EXAMPLES OF THE SAS FACILITY
  • COMPARING MACRO LANGUAGE PROCESSING AND SAS LANGUAGE PROCESSING/span>
  • PROCESSING A SAS PROGRAM THAT CONTAINS MACRO LANGUAGES

Need to talk to us ?

+91 9030070095

career@igcp.co.in
Contact Me
MACRO PROGRAMS
  • CREATING MACRO PROGRAMS
  • EXECUTING A MACRO PROGRAM
  • PASSING VALUES TO A MACRO PROGRAM THROUGH MACRO PARAMETERS
MACRO VARIABLE
  • BASIC CONCEPT OF MACRO VARIABLE
  • REFERENCING MACRO VARIABLES
  • UNDERSTANDING MACRO VARIABLES
  • DISPLAYING MACRO VARIABLE VALUES
  • UNDERSTANDING AUTOMATIC MACRO VARIABLES
  • UNDERSTANDING USERDEFINED MACRO VARIABLES
  • COMBINING MACRO VARIABLES WITH TEXT
  • REFERENCING MACRO VARIABLES INDIRECTLY
MACRO LANGUAGE FUNCTIONS
  • MACRO CHARACTER FUNCTIONS
  • MACRO EVALUATION FUNCTIONS
  • MACRO QUOTED FUNCTIONS
MACRO EXPRESSION AND MACRO PROGRAMMING STATEMENTS
  • CONSTRUCTING MACRO EXPRESSION
  • CONDITIONAL PROCESSING WITH THE MACRO LANGUAGE
  • ITERATION PROCESSING WITH THE MACRO LANGUAGE
  • BRANCHING IN MACRO PROCESSING
APPLYING YOUR KNOWLEDGE OF MACRO PROGRAMMING
  • STORING AND REUSING MACRO PROGRAMS
  • DEBUGGING MACRO PROGRAMMING
  • UNDERSTANDING THE TYPES OF ERROR THAT CAN OCCUR IN MACRO PROGRAMMING

SAS/SQL

INTRODUCTION TO THE SQL PROCEDURE
  • WHAT IS SQL?
  • TERMINOLOGY
  • COMPARING PROC SQL WITH SAS DATA STEP
RETRIEVING DATA FROM A SINGLE TABLE
  • OVERVIEW OF THE SELECT STATEMENT
  • SELECTING COLUMNS IN TABLE
  • CREATING NEW COLUMNS
  • SORTING DATA
  • RETRIEVING ROWS THAT SATISFY A CONDITION
  • SUMMARIZING DATA
  • GROUPING DATA
  • FILTERING GROUPED DATA
CREATING AND UPDATING TABLES
  • CREATING TABLES
  • INSERTING ROWS INTO TABLES
  • UPDATING DATA VALUES IN TABLE
  • DELETING ROWS
  • ALTERING COLUMNS
  • DELETING A TABLE
  • USING SQL PROCEDURE TABLES IN SAS SOFTWARE
  • USING PROC SQL WITH THE SAS MACRO FACILITY
  • CREATING AND USING MACRO VARIABLES IN SQL