SAS – Radical Technologies Bangalore HSR Layout
Open Quick Enquiry
Please Contact Us
rad

SAS

Best SAS Training in Pune India

Duration of Training: 4 days.

  • Extensive Hands-on training
  • Customized and flexible training options
  • 24X7 Lab practice facility allowed
  • Latest Printed study material will be provided
  • Well-equipped, sophisticated Training center

 

SAS Syllabus

Mainframe SAS BASE and SAS MACROS: –

Day 1

  • Why SAS – advantages of using it against COBOL and PL1
  • SAS DATA STEP
  • SAS PROC (PROCEDURE) STEP
  • Basic concept on What happens when a SAS program is submitted
  • Basic concept on how SAS files are stored
  • Referencing SAS files
  • SAS Dataset – Data Portion, Observations, Variables, Missing Values
  • SAS Dataset – Descriptor Portion : Dataset Attributes
  • SAS Dataset – Descriptor Portion : Variable Attributes (Variable Name, Variable Type, Variable Length, Variable Informats, Variable Formats and Variable Labels)
  • Understanding SAS DATA Step Processing – Compilation Phase and Execution Phase
  • Program Data Vector (PDV)
  • SAS statements and their 2 types, important Executable and Declarative SAS Statements
  • SAS Statement – Informats
  • SAS Statement – Formats
  • SAS Statement – ATTRIB
  • SAS Statement CARDS or DATALINES or LINES
  • SAS Statement CARDS4 or DATALINES4 or LINES4
  • SAS Statement DELETE
  • SAS Statement DROP
  • SAS Statement – KEEP
  • SAS Statements LABEL
  • SAS Statements LENGTH
  • SAS Statements RETAIN
  • SAS Statements SUM

Day 2

  • SAS Data Set Options – What are these actually?
  • Important SAS Data Set Options : KEEP, DROP, RENAME, FIRSTOBS, OBS, IN, LABEL, WHERE
  • Optimize the various SAS steps usage
  • SAS System Options – what are these, OPTIONS statement
  •  Frequently used SAS System options : OBS, FIRSTOBS, BUFNO, BUFSIZE, LINESIZE,PAGESIZE, NODATE, YEARCUTOFF
  • Differences between system options, data set options and statement options
  • SAS Functions – an overview
  • Very important SAS functions – INPUT and PUT
  • Important SAS Functions for Date and Time – MONTH, YEAR, DAY, MDY, DATE, TODAY, DATETIME
  • Other important SAS functions – SCAN, SUBSTR, TRIM, LEFT, RIGHT, INDEX, UPCASE, LOWCASE, MEAN, COMPRESS, LENGTH
  • Compare the usage of different functions usage in SAS and best place to use it
  • Arrays in SAS : ARRAY statement
  • Creating variables via ARRAY
  • Assigning Initial Values to Arrays
  • Multidimensional Array
  • DIM function

Day 3

  • Conditional Processing – IF, Subsetting, Subsetting concepts
  • Conditional Processing : IF-THEN/ELSE statement
  • DO statement in Conditional Processing
  • Iterative Processing : DO Iterative statement
  • Nesting of the DO Loop
  • DO UNTIL statement
  • DO WHILE statement
  • Using Conditional Clauses with the Iterative DO Statement
  • SAS Variables – Creating Variables
  • FTP thru SAS
  • Connect to different servers ( SQL server etc)
  • Reading Raw data, LIBNAME statement, FILENAME statement, INFILE Statement
  • Reading Raw data – Missover,Truncover,Stopover,Flowover,DSD,DLM
  • Reading Raw data – DATA statement, INPUT statement
  • Reading Raw data – Column INPUT,Formatted INPUT,List INPUT,Modified List INPUT
  • Reading Raw data – Line Pointer Controls
  • Reading Raw data – Line Hold Specifiers

Day 4

  • Merging & Appending Data – SET statement, MERGE Statement
  • MODIFY and UPDATE Statements
  • WHERE Statement
  • RETAIN Statement
  • RETURN Statement
  • SAS Procedures
  • Important Procedures such as Proc Print, Proc Sort, Proc Import, Proc Export and more
  • Creating Excel using SAS
  • Basic Intro with PROC SQL
  • AN INTRODUCTION TO SAS MACRO LANGUAGE
  • Storing SAS Macros
  • Defining and Calling Macros
  • Referencing Macro Variables
  • Macro Parameters
  • Macro Quoting Technique
  • Macro Debugging Technique
  • A detailed look into the internal process of the SAS system – How SAS processes statements
  • An overview of mainframe SAS with DB2

Our Courses