Menu
  • Hyderabad 9030070095 040-42204262
Advance SAS

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
  • PROCESSING A SAS PROGRAM THAT CONTAINS MACRO LANGUAGE

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 PROGRAMS

  • CREATING MACRO PROGRAMS
  • EXECUTING A MACRO PROGRAM
  • PASSING VALUES TO A MACRO PROGRAM THROUGH MACRO PARAMETERS

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

Enquiry Now

Need to talk to us ?

Institute Of Good Clinical Practice

Hyderabad

2nd Floor, Above Super Market, Near Sripuram Colony Bus Stop, Moosarabagh, Malakpet, Hyderabad-500036

+91 9030070095,

+91 8790209568.